Reading the SQL Server Error Log Before It Reads You
The SQL Server error log holds the evidence for your last outage. Here is how to read archives, group the noise, and spot 825 and… Read More »Reading the SQL Server Error Log Before It Reads You
SteveStedman
Common Reasons you may need to restore from backups
Our Backup and Restore Course is designed to give you a comprehensive understanding of SQL Server backup strategies, restoration processes, and best practices. Whether you’re… Read More »Common Reasons you may need to restore from backups
The Questions Your SQL Server Estate Could Not Answer Until Now: Cost, Licensing, Sensitive Data and Risk
Cost per database, unused Enterprise features, where personal data lives, whether servers can be consolidated, and what is about to run out. Database Health Monitor… Read More »The Questions Your SQL Server Estate Could Not Answer Until Now: Cost, Licensing, Sensitive Data and Risk
Datacenter failure, can you get your backups?
Our Backup and Restore Course is designed to give you a comprehensive understanding of SQL Server backup strategies, restoration processes, and best practices. Whether you’re… Read More »Datacenter failure, can you get your backups?
Why SQL Server CPU Pressure Isn’t What Task Manager Shows
Task Manager’s CPU percentage hides real CPU pressure. Learn which SQL Server counter shows it and what a healthy loaded server actually looks like.
What’s Really Driving Your ReportServer Database Size
ReportServer database size rarely grows from report definitions. See which tables, in the catalog and its temp database, actually reserve the space.
Are you ready to restore those backups?
In our data-driven world, having a reliable backup for your SQL Server data is just half the battle; knowing how to effectively recover that data… Read More »Are you ready to restore those backups?
The SQL Server Residual Predicate Hiding in Your Plan
A SQL Server residual predicate lets an index seek report success while it reads and discards most of the rows it touched. Here’s how to… Read More »The SQL Server Residual Predicate Hiding in Your Plan
What Is in Master, and What a Rebuild Would Lose
What is in master often surprises the team that has to rebuild it: credentials, triggers, and startup procedures nobody documented.
What a 515-Bug-Fix Release Says About the SQL Server Estate You Cannot See
Database Health Monitor 4.1540 adds 63 reports, 25 features and 515 bug fixes. Here is what that release actually means for a consulting practice or… Read More »What a 515-Bug-Fix Release Says About the SQL Server Estate You Cannot See