Blog: Bobby Durrett


210 blogs updated: 37 min. ago
MySQL client slow to display the first row of a large result set
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 e...
3
01-06-2018 23:41:35 Bobby Durrett Oracle
Python script to backup remote directory using sftp
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 direc...
3
30-05-2018 19:46:53 Bobby Durrett Oracle
Database links and SCNs on June 23, 2019
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. M...
0
17-05-2018 01:38:18 Bobby Durrett Oracle
Larger SCN numbers July 1, 2019 on 11.2.0.3.5
I'm trying to research a couple of notes about database links failing in June of 2019. Evidently somewhere around that time the SCN numbers ...
3
11-05-2018 23:18:55 Bobby Durrett Oracle
Post Collaborate and on call week post
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 co...
6
02-05-2018 20:12:43 Bobby Durrett Oracle
Getting geared up for Collaborate 2018 #C18LV
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 Den...
4
14-04-2018 02:40:19 Bobby Durrett Oracle
Had to set parallel_max_servers to 2 for Delphix clone
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-...
4
10-04-2018 01:18:51 Bobby Durrett Oracle
Does an automated cloud data warehouse need partitioning and indexes?
This is a late post inspired by my time at RMOUG Training Days 2018. I attended two RMOUG Training Days presentations about automated cloud ...
6
08-03-2018 23:54:40 Bobby Durrett Oracle
Pushing predicates into MySQL subqueries
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...
6
06-03-2018 20:50:50 Bobby Durrett Oracle
Follow up from RMOUG Training Days talks
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 i...
9
23-02-2018 23:14:32 Bobby Durrett Oracle


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.