Category Archives: Uncategorized

I have a couple of Oracle performance reports that I upload from my work Windows 7 laptop to our corporate SharePoint site on Office 365 on a regular basis. I thought that it would save me time to automate the … Continue reading →

A coworker of mine asked me to look at a MySQL query that was running longer than we want it too. If they added a LIMIT 1000 clause at the end of the query it popped up the results in … Continue reading →

This is the sftp version of the ftp script I published in an earlier post. It logs into a remote host using sftp and backs up a remote directory recursively backing up all subdirectories. This one uses Paramiko instead of … Continue reading →

A few days or weeks ago I saw a Twitter post about database links failing on Oracle databases next year. So, I have researched this issue. My company has a bunch of Oracle databases with a web of database links … Continue reading →

So, I was at the Collaborate 2018 Oracle user group conference last week and I am on call this week. I have not posted anything about the conference so I thought I would try to get something out there. I … Continue reading →

I’m leaving for Las Vegas a week from this Sunday for the Collaborate 2018 conference #C18LV. I’m doing the same two talks that I did in Denver at RMOUG Training Days. Here are the times and locations for the talks if … Continue reading →

This is a quick note about a problem I had creating a Delphix virtual database clone of a production database. This is an older 11.1.0.7 HP-UX Itanium database. I tried to make a new virtual database copy of the production … Continue reading →

This is a late post inspired by my time at RMOUG Training Days 2018. I attended two RMOUG Training Days presentations about automated cloud data warehouse database systems. The first was about Snowflake. The second was about Oracle’s coming Autonomous … Continue reading →

I am just getting started looking at MySQL performance tuning but I thought I would share something that I may have figured out. I’m working with a query that does a count and a group by in a subquery and … Continue reading →

I have uploaded a zip of my two RMOUG Training Days talks here: zip During the Toastmasters talk there was a question about finding a club in your area. Here is how to find a Toastmasters club near you. Go … Continue reading →