Grab a blanket and get comfortable. It’s story time with Steve Stedman and Derrick Bovenkamp! In this 10 min video they will share with you database corruption stories. From these stories hopefully you’ll learn what not to do. Things to watch out for to avoid server corruption. Transcription: Steve Stedman 0:04Let’s roll onto the corruption stories. So the first one …
If you don’t know the difference between server corruption and drive failure then this video is for you. It will all be explained in this quick 6 min video. Transcription: Steve Stedman 0:10Now, one of the things that when we talk about drive failures, whatnot is that want to point out there’s a big difference between corruption and complete drive …
Database Corruption vs Drive Failure Explained – Video Read more »
Easy listen – 6 minute video describing possible server corruption scenarios that’s actually happened. Help yourself and avoid these mistakes. Presented by Steve Stedman and Derrick Bovenkamp. Transcription: Steve Stedman 0:03Now, imagine with this picture, if that was your fiber optic cable running through the middle of that fire and you’re doing a backup or trying to load a database …
You don’t have to be Sherlock Holmes to detect Server Corruption. Steve Stedman and Derrick Bovenkamp share valuable information on how to spot server corruption before the damage is irreversible. And we are always here for guidance or complete corruption repair if you need us! Transcription: Derrick Bovenkamp 0:10How do we find corruption? Man, I wish it was as easy …
Working with Transactional Replication with many of our SQL Server clients, one of the big questions that we are always asking is replication keeping up? Recently when deleting a few hundred million rows from a large table that is synced with transactional replication, I needed to programmatically check how the distribution was keeping up. The one measure that indicated that …
Do you know what to do when corruption hits? You should watch this quick 10 min video first if you plan on fixing it yourself? Steve Stedman and Derrick Bovenkamp wants to save you from making a big mistake. In this video they will share the Do’s and Do Nots when faced with a database corruption. And we are always …
Your Database is Corrupt – Here’s Your “Now What?” Video Read more »
I added a new report to the daily monitoring email, showing the error log over time. What is interesting about this is that it is tracked by hour, so if there is something that changes on your system that suddenly caused many more error log entries to be written, it will show up here. This enhancement came from me trying …
On the SQL Daily Checkup report I have added a new report section called news which we can use to show new features related to the daily checkup email. We provide monitoring tools that alert us when there is an issue so that we can recommend fixes before the issue becomes a bigger problem. The notification runs every hour and …
Anyone who’s experienced database corruption knows they do not want it to happen again. Corruption repair is stressful and could require money and downtime you can’t afford. In some cases, there is no “repair” just rebuild. Unfortunately, no database is immune from server corruption, but there are certain alerts and specific practices that when implemented will greatly lessen the impact …
Occasionally you need to take inventory of how much free space each database has. You can find this quickly and easily in Database Health Monitor, but if you want to get it programmatically you can do it with the following query. This query has been tested on SQL Server 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, and 2019. This …