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

Is Your SQL Server Ready for a Compliance Audit?

Compliance audits ensure that organizations adhere to regulatory guidelines, industry standards, and internal policies. As SQL Server DBAs, you can be prepared for most audits if you already check all of the boxes outlined in this blog post. Each of these points could be its own blog posts, so take your time as you go … Read more

DBCC CHECKDB: Look for SQL Server Corruption

A monster’s worse fear is being found. – Richelle Goodrich This is part of the Two Weeks to a healthier SQL Server series. Today we’ll address SQL Server Corruption – or hopefully how to find and deal with it before it finds and deals with you. Data loss and user deletes are expensive and difficult. … Read more