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

SQLU DBA Week – Set It And….

Welcome to the third day of DBA week at SQL University. On day one, I kicked off the “back to basics” journey I’ve chosen for fellow students with my post reminding you that you’re only as good as your ability to restore. Microsoft Certified Master Robert Davis brought us a good reminder on Day 2 … Read more

SQLU DBA Week – You Can Restore It! (right?)

sql server restore

Welcome to my first contribution to SQL University’s Database Administration Week! I am going to go back to some basics here this week. I know you’ve probably been with us for a few semesters and you don’t want to hear that. That’s fine, Microsoft Certified Master Robert Davis is also covering DBA week and he … Read more