Welcome to our Backup and Recovery Course! In today’s digital age, data is the lifeline of any business. Ensuring its safety and availability is paramount. Our comprehensive Backup and Recovery Course is designed to equip you with the essential skills and knowledge to safeguard your data effectively. What You’ll Learn: Understanding the importance of data backup and recovery. Different types …

Backup and Recovery Course Read more »

Exciting New Features and Enhancements in the Latest Database Health Monitor Release (July 2024 – Version 1067) Hello, Database Health Monitor users! We’re thrilled to announce the latest update, Version 1067, released today. This version brings a host of improvements and new features designed to enhance your experience and make database management even more efficient. Here’s a detailed look at …

Latest Database Health Monitor Release Read more »

With over 12 years of development into Database Health Monitor, there are many features there for many difference scenarios from performance to security, to overall server health. I created the Database Health Monitor course to help people get the most value out of using the product, and with the purchase of that course you also get licensing for up to …

Database Health Monitor with Coaching Read more »

When working with data in SQL Server, there may be times when you need to remove leading zeros from a string. This task can be particularly common when dealing with numerical data stored as strings, such as ZIP codes, product codes, or other formatted numbers. In this blog post, we’ll explore several methods to remove leading zeros in SQL Server. …

Removing Leading Zeros in SQL Server Read more »

Here is a 25% off coupon code for the Database Health Monitor Course wich includes licenses for 20 SQL Server connections. The code is only good this month: Code: July25 Here are the details on a couple of reports that I uses regularly in Database Health Monitor. The databases by size report is a quick and easy way to see …

Database Health Monitor – Database Size and Database IO reports Read more »

Understanding SQL Server Compatibility Levels In the world of SQL Server, compatibility levels play a crucial role in ensuring that your database applications run smoothly even after upgrading to a newer version of SQL Server. By understanding and managing these compatibility levels, you can avoid potential issues and leverage new features while maintaining stability and performance. What is a Compatibility …

Understanding SQL Server Compatibility Levels Read more »

When it comes to managing databases, every second counts. The health of your database can mean the difference between a smoothly running operation and countless hours spent troubleshooting performance issues. The ability to closely monitor, diagnose, and optimize your databases is crucial in maintaining an efficient, productive environment. And that’s exactly where Database Health Monitor by Stedman Solutions comes in. …

Unlocking Database Performance: Database Health Monitor by Stedman Solutions Read more »

Out of all of the customers we have running our daily monitoring here are the versions of SQL Server that are being run. All the data is sanitized, so there is no private client information to expose here. What is this service? With this service we detect and alert you of any issues that arise on your SQL Server. Then …

Daily Server Monitoring – SQL Versions for July Read more »

Monitoring is another important preventative measure that can help ensure the ongoing health and performance of a SQL Server. Administrators should monitor various performance metrics such as CPU usage, memory usage, disk usage, and network traffic to identify performance bottlenecks and potential issues. Monitoring can also help detect and resolve issues related to query performance, execution plans, and blocking sessions. …

Monitoring your SQL Server Read more »