Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn everything needed to start using CTE’s for recursive queries, as temporary views, and to use the result set multiple times in the same query. Learn how simplify query syntax using CTE’s. One of the most …

Common Expression Tables – Introduction Read more »

Corruption or Ransomware

Steve Stedman and Derrick Bovenkamp explain the difference between ransomware and database corruption. We offer SQL server corruption repair and even Emergency repair. Generally we will have you up and running again within 24-48 hours! Schedule a free 30 consultation and see how we can help. Transcription: Steve Stedman 0:05Let’s take a look at how ransomware relates to your SQL …

Ransomware and Database Corruption, What’s the Difference? Read more »

As a DBA you regularly schedule backups you might have regular full backups, incremental backups and hopefully regular backups. Over time you might realize that your error log is not longer filled with errors, but instead a majority of your error log is filled with backup messages. “Backup Database successfully … “, “Database backed up…”, “Log was backed up”. This …

Quick Scan Report – Logs Flooded with Backup Messages Read more »

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 »

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… …

End of the Month Blog Post Wrap-up Read more »

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 …

Quick Scan Report – High VLF Count – Video Tip Read more »

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 …

Steve & Derrick Share Corruption Stories Read more »

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 »