The Ironic DBA—My First Year as a DBA [Part 1]
Whoo! It’s been six months since my last post. There are reasons for this, none of which are probably valid, but it’s the way it is. I’ve been a...
2020-07-13 (first published: 2020-06-30)
696 reads
New Pluralsight Course – Maintaining, Monitoring and Troubleshooting Kubernetes
My new course “Maintaining, Monitoring, and Troubleshooting Kubernetes” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to Pluralsight! ...
2020-06-30
15 reads
New Pluralsight Course – Maintaining, Monitoring and Troubleshooting Kubernetes
My new course “Maintaining, Monitoring, and Troubleshooting Kubernetes” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to Pluralsight! This course will...
2020-06-30
10 reads
New Pluralsight Course – Maintaining, Monitoring and Troubleshooting Kubernetes
My new course “Maintaining, Monitoring, and Troubleshooting Kubernetes” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to https://app.pluralsight.com/library/courses/maintaining-monitoring-troubleshooting-kubernetes/! This course will...
2020-06-30
40 reads
Measuring Well Being
I need to write something more on this, but it struck me that this is something I wish previous employers had done, anonymously, and reported results back to others....
2020-07-10 (first published: 2020-06-29)
400 reads
SQL Server Backups on AWS RDS
One of the things I love the most about Platform as a Service offerings is the fact that it makes it so I don’t have to do silly things...
2020-07-09 (first published: 2020-06-29)
323 reads
Daily Coping 29 Jun 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-06-29
22 reads
HAL0004 – I don’t feel well Dave
It’s another HAL! Every once in a while (4 times now) I come up with a terrible terrible idea for ... Continue reading
2020-06-29
53 reads
New Free Course: The Dirty Secrets of NOLOCK
I’m excited to begin moving over courses from SQL Workbooks and making the material available here. The first course up for grabs is The Dirty Secrets of NOLOCK. A...
2020-07-09 (first published: 2020-06-29)
1,247 reads
Last Week Reading (2020-06-28)
Press ExpandString in Powershell This function can do much more than you think. Pester – using -should -throw Useful example when you want to filter output by ExceptionType or ErrorId....
2020-06-28
15 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers