Steve Stedman

Hello everyone, I’m Steve Stedman, and today, I’m excited to share with you a feature of the Database Health Monitor software that I’ve developed: The Blocking Query Monitor. Understanding and addressing performance bottlenecks in SQL Server is not always an easy task, and one of the biggest contributors to these bottlenecks is often blocking queries. That’s why I’ve built the …

Blocking Query Monitor – Part of Database Health Read more »

At Stedman Solutions when we talk about corruption in a database, that is something very different from ransomware. Don’t confuse a damaged database with a database that has been fully encrypted by ransomware. Determining when corruption was introduced into a SQL Server database can be challenging, as corruption can occur without generating any obvious symptoms. However, there are some steps …

SQL Server Corruption: When Did It Happen Read more »

Hi there, I’m Steve Stedman, the creator of Database Health Monitor, and I’m thrilled to bring you our groundbreaking class. If you’re tired of dealing with sluggish database performance and unexpected downtime, then this class is tailor-made for you. Join me on this exciting journey as we revolutionize the way you manage and monitor your databases. In the Database Health …

The Database Health Monitor Class: Your Key to Optimal Database Performance! Read more »

July is here and that means it’s time for us to pivot our collective gaze to the pulse of our digital lifeblood – our databases! As the founder of Database Health and Stedman Solutions, I am excited to declare this month as Database Health Monitor Month! This is our annual opportunity to appreciate the often-unseen guardians of our valuable data, …

July is Database Health Monitor Month Read more »

SQL Server instance level settings allow you to control various aspects of the behavior of your SQL Server instance. One such setting is the ability to force encryption for all connections to the instance. This is a security feature that ensures that all communication between the client and the server is encrypted, which helps protect against eavesdropping and man-in-the-middle attacks. …

Securing SQL Server: Force Encryption Setting Read more »

Performance Issues When Querying Over Linked Servers in SQL Server Linked servers in SQL Server provide a way to query and execute commands against OLE DB data sources on remote servers. This can be extremely useful for accessing data across different servers and even different database systems. However, querying over linked servers can introduce significant performance issues if not managed …

Linked Server Query Performance Read more »

This month marks the anniversary of Database Health Monitor, that I started building in 2011. To celebrate I am offering 25% off the licensing fee for the annual subscription for Database Health Monitor. As many of you know, maintaining healthy and high-performing databases is critical for any organization that relies on data to drive business decisions. And that’s precisely what …

Early release – July is Database Health Monitor Month Read more »

Handling Divide by Zero Errors in SQL Server One of the common errors encountered in SQL Server is the divide by zero error. This error occurs when a division operation has a denominator of zero, which is mathematically undefined. Understanding how to handle and prevent this error is crucial for maintaining robust SQL Server applications. What Causes a Divide by …

Handling Divide by Zero Errors in SQL Server Read more »

Understanding Table-Valued Parameters in SQL Server and Handling Parameter Sniffing Issues Table-Valued Parameters (TVPs) in SQL Server are a powerful feature that allows you to pass entire tables of data to stored procedures or functions. This can significantly simplify your code and improve performance when dealing with multiple rows of data. However, it’s important to be aware of potential parameter …

Understanding Table-Valued Parameters Read more »

DBCC PROCCACHE is a database console command (DBCC) in Microsoft SQL Server that can be used to display information about the procedure cache, which is a region of memory used by the database engine to store compiled versions of stored procedures, triggers, and other objects. Displaying information about the procedure cache can be useful for troubleshooting performance issues or for …

SQL Server DBCC Commands: DBCC PROCCACHE Read more »