Are Your SQL Servers Actually Secure? Linked In Live event on 9/16
August 20, 2026
Notes From The Session: Download the slide show from today’s session: 20260916 Are Your SQL Servers Actually Secure Most Recent SQL Server Updates at Microsoft’s site. Get sp_CheckSecurity from our github. Read more about sp_CheckSecurity here. This one is really designed for the accidental DBAs, the IT leaders and the folks who deal with SQL
It’s Still Not Your Emergency
August 4, 2026
A message hit our Teams “Lounge” channel where we talk about anything in life, sometimes work. One of our DBAs was worried about a client’s data – some rows that didn’t look the way they should look with a likely data issue, and a growing question about how far back the problem went hit her.
Psst: “Vibe Ops” Isn’t a Thing…
February 27, 2026
I was maybe 12 years old the first time I really smelled ozone. Not from a thunderstorm. From a Radio Shack 200-in-1 electronics kit… the kind with the spring terminals and the little instruction booklet that made you feel like a real engineer. I forgot what I was supposed to be building, maybe a lap
To Kill a SPID or Not To Kill a SPID
October 24, 2025
Quick Summary We received an on-call call from a client who had noticed something was running slowly over the weekend and decided to issue a KILL command. The KILL command did what it does – it started the KILL/ROLLBACK process. They had done that once or twice before, they thought, and didn’t remember it taking
Temptation – When The Cloud Looks Like Heaven (but isn’t…)
October 21, 2025
A heaven? A gateway? A hope? Let’s continue the SQL Server Regrets series… The planned next post was about the cloud anyway, my reminder for this post was the really long day a lot of tech folks relying heavily on AWS experienced today… Another cloud-based DNS related outage/wave of interruptions. A heaven….. A hope?- Someone
SQL Server Backups and the Illusion of Safety: Confusion
October 14, 2025
With the recent data center fire and missing government data in South Korea, it felt like a good time to continue with the SQL Server Regrets series of blog posts. We’ll talk about the confusion of thinking you are covered for recoverability – when you just aren’t. This “Regret” comes up far too often when
SQL Server Vulnerability Alert: CVE-2025-49719
July 10, 2025
On patch Tuesday this week, Microsoft released an Important severity security update (a CVSS base score of 7.5) The details of this 0-day exploit are available to read at the NIST site, and the Microsoft security update site. In short, the exploit that Microsoft has discovered and subsequently fixed can allow information disclosure. (That’s the
How to Automatically Validate SQL Server Backups With Test-DbaLastBackup (Dbatools)
June 24, 2025
In this blog post, we will audit the dbatools command Test-DbaLastBackup. I will test, review, and evaluate the script based on a series of identical steps. Our goal is to provide insights, warnings, and recommendations to help you use this script effectively and safely. Test-DbaLastBackup is a powerful tool to automate the validation of a