Temptation – When The Cloud Looks Like Heaven (but isn’t…)

temptation

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 … Read more

SQL Server Backups and the Illusion of Safety: Confusion

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 … Read more

SQL Server Vulnerability Alert: CVE-2025-49719

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 … Read more

How to Automatically Validate SQL Server Backups With Test-DbaLastBackup (Dbatools)

How to Automatically Validate SQL Server Backups With Test-DbaLastBackup

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 … Read more

How to Restore a SQL Server Database Using dbatools Restore-DbaDatabase

How to Restore a SQL Server Database Using dbatools Restore-DbaDatabase

In this blog post, we will audit the dbatools command Restore-DbaDatabase. 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. Restore-DbaDatabase is powerful tool to automate the restore of any database, … Read more

SQLU DBA Week – DBA Progress Report

This week was DBA Week At SQL University. We’ve seen two great posts from Robert Davis, a couple posts from me and some input from DBA Coach LaRock. Today we’ll lighten things up. It’s Friday so let’s close our notebooks and have a classroom discussion about our attitudes and learning. There are all sorts of … Read more