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 »

In the realm of SQL Server, the NOLOCK hint is a frequently discussed and often misunderstood topic. Many developers and database administrators resort to using NOLOCK in their queries to improve performance, without fully understanding its implications. This live stream, hosted by Steve Stedman, aims to demystify NOLOCK, addressing common myths and misconceptions, while providing clear guidance on when and …

Understanding NOLOCK Hint in SQL Queries Read more »

Hey there! Steve Stedman here, founder of Database Health Monitor, and I’ve got something exciting to share with you. If you’re tired of dealing with slow database performance and unexpected downtime, then you’re in the right place. Let me introduce you to our game-changing class that will transform the way you manage and monitor your databases. Here is the deal:Use …

Database Health Monitor Class Deal Read more »

Hello, I’m Steve Stedman, and I’d like to share my experience with you regarding my SQL Server course on preparing for corruption. This course is designed to help SQL Server professionals be better prepared for the event of corruption within their databases. Over the years, I have seen many instances of database corruption, which can cause data loss and downtime …

SQL School: Database Corruption Course Read more »