SQL Daily Monitoring – SQL Server Versions
Here listed is the current percentages of SQL server versions running our Daily Check-up with Database Health Monitor.
Default Maintenance Plan Shrink Database – Video Tip
The problem with using the default maintenance plans is that SQL Server Management Studio makes it easy to turn on some features that are really bad practice. Transcription: Steve Stedman 0:09Welcome to today’s training video. I’m Steve Stedman. I’m the founder of Stedman Solutions. Today we’re going to talk about one of the common items reported by the sequel daily …
Default Maintenance Plan Shrink Database – Video Tip Read more »
End of the Month Blog Post Wrap-up
by Steve Stedman and the Stedman Solutions Team Database Corruption vs Drive Failure Explained Thu, 25 Mar 2021 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 w Read more… …
Quick Scan Report – High VLF Count – Video Tip
Virtual Log Files (VLFs) are part of the SQL Server log file. When space is allocated in the log due to growth, that new chunk of log is broken up into Virtual Log Files. High VLF counts can slow down the following actions: – Transaction Log Backup – Crash Recovery, the process your database goes through on startup. – Writing …
Stedman Solutions 6 Year Anniversary SALE!
NO Pranks Just Thanks! We’d like to extend our gratitude! April 1-8 we will be offering 50% off our SQL Daily Check-Up Annual Subscription! <—— Click Here to purchase & to learn more.
Steve & Derrick Share Corruption Stories
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 …
Database Corruption vs Drive Failure Explained – Video
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 »
Possible Causes of Database Corruption – Video
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 …
Detecting Database Corruption – Video
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 …
Transactional Replication – is it keeping up?
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 …