SQLSaturday Orlando 2019 Begins
We’ll be event number 911, set for September 28th at our usual location at Seminole State College. Maybe something interesting to do there as far as a theme. Call...
2019-06-14
49 reads
Blog Posts
12 Ways To Rewrite SQL Queries for Better Performance
Watch this week’s video on YouTube. Thanks to you, we just crossed the 2k subscriber mark! Over the past several week’s I’ve been exploring ways to rewrite queries to improve...
2019-06-13 (first published: 2019-05-28)
3,756 reads
As a DBA, how do I offload some of my work?
I don't have time for this “I am a DBA, I am busy, too busy. Developers keep pushing changes to production without me reviewing the code, and now I...
2019-06-13
12 reads
As a DBA, how do I offload some of my work?
I don’t have time for this “I am a DBA, I am busy, too busy. Developers keep pushing changes to production without me reviewing the code, and now I...
2019-06-13
278 reads
Does the case statement short circuit?
Let’s start with definitions: CASE Statement: This is basically an inline IF .. ELSE IF .. ELSE IF ….. etc ... Continue reading
2019-06-13
515 reads
Get the Source of PREEMPTIVE_OS_PIPEOPS Waits
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to capably monitor the server for any issue be it...
2019-06-13
215 reads
Get the Source of PREEMPTIVE_OS_PIPEOPS Waits
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to capably monitor the server for any issue be it...
2019-06-13
10 reads
Get the Source of PREEMPTIVE_OS_PIPEOPS Waits
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to capably monitor the server for any issue be it...
2019-06-13
69 reads
How Developers and DBAs Collaborate in a DevOps World (video)
You’re a DBA, and your development team is all-in on doing DevOps, and they want to include the database. Should your DBA team limit the permissions or options for...
2019-06-13
10 reads
What is a distributed transaction?
A while back I did a post defining a transaction. Basically, a transaction is a unit of work. The example ... Continue reading
2019-06-13 (first published: 2019-05-28)
822 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers