Category: Uncategorized

The Risks of Patching vs. Not Patching SQL Server: Why It Matters and How Stedman Solutions Can Help Patching SQL Server can feel like a double-edged sword. On one hand, it’s essential to maintain a secure, high-performing environment. On the other, there’s the fear that patching might introduce unforeseen issues, potentially causing downtime or breaking applications. So, what’s the right approach? In this post, we’ll explore the risks of both patching and not patching, and how partnering with a professional …

The Risks of Patching vs. Not Patching SQL Server Read more »

Download “The Real Cost of SQL Server Management” White Paper Discover the real costs of SQL Server management by downloading our detailed white paper, “The Real Cost of SQL Server Management: In-House Team vs. Stedman Solutions.” This comprehensive guide delves into the financial, operational, and strategic implications of maintaining an in-house SQL Server team compared to outsourcing your database management to experienced specialists like Stedman Solutions. Building and maintaining a reliable in-house SQL Server team is more complex than it …

Real Cost of SQL Server Management Read more »

SQL Server Deprecated Features Over 25 Years Microsoft SQL Server has seen numerous features marked as deprecated over the past 25 years. Deprecated features are still functional but are planned for removal in future releases. Here’s a summary of major deprecated features across different versions: SQL Server 2000 (8.0) to SQL Server 2005 (9.0) SQL Server 2008 (10.0) and 2008 R2 (10.5) SQL Server 2012 (11.0) SQL Server 2014 (12.0) SQL Server 2016 (13.0) SQL Server 2017 (14.0) SQL Server …

SQL Server Deprecated Features Read more »

How to Monitor SQL Server Health: Best Practices and Tools Monitoring SQL Server health is essential for ensuring database performance, identifying potential issues early, and maintaining overall system stability. Neglecting this vital task can lead to system slowdowns, hidden Corruption, or even full-blown server crashes. In this blog post, I’ll guide you through the best practices and tools for monitoring SQL Server health effectively. Why SQL Server Monitoring Is Critical SQL Server monitoring isn’t just about checking a few metrics …

How to Monitor SQL Server Health Read more »

Hello everyone, today, I’m excited to share with you a feature of the Database Health Monitor software that I’ve developed: The Blocking Query Monitor. Watch this video by Steve Stedman to find out more. 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. The Blocking Query Monitor is a powerful tool specifically designed to …

Blocking Query Monitor – Part of Database Health Read more »

What Are SQL Agent Jobs? If you’ve been managing a SQL Server environment for any amount of time, chances are you’ve come across SQL Server Agent Jobs. But what exactly are they, and why are they so critical to efficient database management? In this blog post, I’ll break down what SQL Agent Jobs are, how they work, and why they’re a key tool in any DBA’s toolkit. Understanding SQL Server Agent Jobs At its core, an SQL Agent Job is …

SQL Agent Jobs Read more »

In the world of database management, maintaining optimal performance is an ongoing challenge. One crucial aspect that often gets overlooked is the management of indexes. While indexes can significantly enhance query performance, having too many of them can lead to issues when it comes to inserts, updates, and deletes. In this blog post, we’ll explore the delicate balance of index management and discuss strategies to identify and remove unnecessary indexes without compromising system stability. The Dilemma of Too Many Indexes …

Dangers of Removing Indexes Read more »