Unexpected Fire

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 …

Possible Causes of Database Corruption – Video Read more »

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 …

Detecting Database Corruption – Video Read more »

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 …

Transactional Replication – is it keeping up? Read more »

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 »

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 …

Preventing Server Corruption – Video Read more »

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 …

Query to Find Free Space on All Databases Read more »

Steve Stedman and the Stedman Solutions Team celebrate the 10 year anniversary of Database Health Monitor. Kiana talks to Steve about this tool he built, how it’s evolved, why its useful and its plans for it in the future. Go to http://www.Databasehealth.com​ to download this free tool today! STEVE: This is the 10-year anniversary of database health monitor and it …

10 Year Anniversary of Database Health Monitor Read more »