SQL Homework – August 2023 – Have the best practices changed while you weren’t looking?

It’s been a bit since I did one of these so let’s go back to the basics. Best practices. We ... Continue reading

T-SQL Tuesday #165: What Do All The Database Job Titles Actually Mean?

It’s an honor to host this month’s T-SQL Tuesday. In case you don’t know the rules already, here is a recap of them: Earlier this year, when I was...

A Basic SQL Script to Monitor Long Running SQL Server Agent Jobs

A Basic SQL Script to Monitor Long Running SQL Server Agent Jobs

 As a SQL Server DBA, especially Production/Operations DBA in a relatively large environment,...

Getting a Summary of Changes in SQL Compare 15

A client asked for a summary of changes, so I wrote this quick post to show where to find this in SQL Compare 15. If you use SQL Compare,...

Updated training list for a new DBA

Met an eager young volunteer at SQLSatBR over the weekend who inspired me to update a blog post that hadn't been refreshed in a few years. See the [UPDATED] Training...

A New Word: Fitzcarraldo

fitzcaraldo – n. a random image that becomes lodged deep in your brain – maybe washed there by a dream, or smuggled inside a book, or planted during a...

I’m back! I’m still a Microsoft Data Platform MVP. And other minor life updates.

I stopped blogging late last year. I’ll be honest, I was tired. I had decided to take a month or ... Continue reading

Presenting at PASS Summit 2023 – Atomic Habits

I’m excited to be presenting at PASS Summit 2023, not only because it is PASS Summit but because of the topic.  I do a lot
The post Presenting at PASS...

Which Schema is Queried First?–#SQLNewBlogger

I had to test something for a customer, and as a part of this there as a need to have a different default schema for a user. I wrote...

Running SQL Server in Docker Swarm

I haven’t touched Docker Swarm for a looooong time but I was asked about running SQL Server in Swarm at a conference a while back…so here’s how it can...