April Blog Post Wrap-up

by Steve Stedman and the Stedman Solutions Team

Optimize For Ad-Hoc Workloads – Video Tip

Tue, 27 Apr 2021

Learn how Optimize For Ad-Hoc Workloads can save some space in your plan cache. Transcription: Steve Stedman 0:09Hi, this is Steve Stedman and I’m here to talk about daily checkup or database health quick scan items that we come across Read more…

SQL Server Parallelism Settings – Video Tip

Thu, 22 Apr 2021

Cost threshold for parallelism and the max degree of parallelism are 2 important setting for your SQL Server. Find out how to set these and what they should be set to. Read more…

Common Expression Tables – Video Introduction

Thu, 15 Apr 2021

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 us Read more…

Ransomware and Database Corruption, What’s the Difference?

Tue, 13 Apr 2021

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

Quick Scan Report – Logs Flooded with Backup Messages Video Tip

Mon, 12 Apr 2021

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 you Read more…

SQL Daily Monitoring – SQL Server Versions

Mon, 12 Apr 2021

Here listed is the current percentages of SQL server versions running our Daily Check-up with Database Health Monitor. Read more……

Default Maintenance Plan Shrink Database – Video Tip

Tue, 06 Apr 2021

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. Read more…

Quick Scan Report – High VLF Count – Video Tip

Thu, 01 Apr 2021

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