Here you have all of Steve Stedman’s SQL Server tips, announcements and news posts of January. Hot Topics: Cumulative Update 15 for SQL Server 2019 Just Released by Microsoft Today Microsoft released SQL Server 2019 CU 15 (KB 5008996) If you need help updating and patching your SQL Server, or upgrading to a new version of SQL Server Stedman Solutions …

January Blog Post Wrap-up Read more »

Today Microsoft released SQL Server 2019 CU 15 (KB 5008996) If you need help updating and patching your SQL Server, or upgrading to a new version of SQL Server Stedman Solutions can help. With the amount of ransomware we are seeing, it is becoming more important than ever to apply any updates that contain security patches. Here are the latest …

Cumulative Update 15 for SQL Server 2019 Just Released by Microsoft Read more »

Even though we just release Database Health Monitor version 991 the January 2022 release, I am already working on the next version. I have added a new chart to replace some of those older pie charts. Here is the comparisons on a couple of reports. The Database By Size report from Version 991 Compared to the same report on the …

Working on the February 2022 Database Health Monitor Version Read more »

Just yesterday we were on a call with one of our monthly managed services customers. They have been a customer now for about 2 and a half years, and we have helped them through a few upgrades, and even a corruption repair. The corruption repair was our initial contact with them. Nearly finished, our client says to me, “I can …

Helping Our Clients Sleep Better Read more »

Every DBA, owner or CEO etc. have worries regarding their SQL Server. We face challenges everyday with constant evolving business and technology needs. We at Stedman Solutions are interested and concerned about your worries in regards to SQL Server work. What is your biggest SQL Server worry today? Tell us so that we can focus our attention on the issues …

SQL Server Worries Survey Read more »

When working on different client servers, we often times get asked, why all their memory is not being used, and often times we are hitting the memory limits for SQL Server Standard Edition. Keep in mind that this limit on memory is for the buffer pool and what is being used by databases. SQL Server can use more than this …

SQL Server Memory Limits Read more »

Backup Retention Part 1 Backup Retention Part 3 In part 1 I spoke about why you would want to restore from backups and some other reasons to have an older backup around. In part 2 I will dive more into the specific types of backup retention methods. Part 3 I will define more on methods but also cover combined methods …

Backup Retention – Part 2 of 3 Read more »

We are pleased to announce a new feature for our Monthly Managed Services customers and Daily Monitoring customers! New feature: Email Notification for Blocking Queries. Picture this scenario: Your SQL Server runs into blocking but you don’t find out until it is too late. Your server eventually gets to the point where it is so backlogged on the blocking that …

New Feature for Stedman Solutions Monthly Services Read more »