Month: April 2021

By Posted on Posted in Corruption No Comments Tagged with ,

The Stedman Solutions team shares ways to reduce the impact of server corruption. Transcription: Steve Stedman 0:10All right. Ways to reduce impact are backups, good backups, frequent backups, and off site backups with that, it’s not just SQL backups, but also virtual machine and system backups, not just backups, but backups that have been confirmed and tested. And tested recently. …

How to Reducing the Impact of Database Corruption – Video Tips Read more »

By Posted on Posted in Database Health, SQL Daily Checkup No Comments

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 occasionally. These are settings that we optimize or configure on the SQL Server in order to help with performance. Usually, …

Optimize For Ad-Hoc Workloads Read more »

By Posted on Posted in Database Health, SQL Daily Checkup No Comments

Cost threshold for parallelism and the max degree of parallelism ( maxdop ) are 2 important setting for your SQL Server. Find out how to set these and what they should be set to. Transcription: Steve Stedman 0:09Hi, this is Steve Stedman and I’m here to talk about a couple of the daily checkup or database health quick scan items …

SQL Server Parallelism Settings – Video Tip Read more »

By Posted on Posted in Classes, JOIN Types, TSQL No Comments Tagged with ,

Join us May 11th @ 12 pm PST – Steve Stedman will teaching a FREE lesson on SQL Server Join Types. TSQL joins – what’s the difference, and how can you use joins correctly? Sometimes an inner join is the right join type to use, other times the left outer join, right outer join, full outer join, cross join or …

TSQL Basics: SQL Server Join Types Webinar Read more »

By Posted on Posted in Classes, CTE No Comments Tagged with , ,

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
By Posted on Posted in Corruption No Comments Tagged with ,

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 »

By Posted on Posted in Monitoring, SQL Daily Checkup, SQL Monitoring No Comments Tagged with , ,

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 »

By Posted on Posted in SSMS No Comments Tagged with ,

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 »