Author: Steve Stedman

Are you looking to elevate your SQL Server expertise without breaking the bank? Our free weekly newsletter is your gateway to mastering SQL Server management with cutting-edge insights and practical advice. Designed for database administrators, developers, and IT professionals, this resource is tailored to help you stay ahead in a fast-evolving field. Each week, the SQL Server Newsletter delivers a wealth of knowledge straight to your inbox, from performance tuning tricks to security best practices. We distill complex concepts into …

Boost Your SQL Server Skills with Our Free Weekly Newsletter Read more »

Finding Peace of Mind with SQL Server Managed Services As the owner or manager of a business that relies on SQL Server for critical data management and operations, the thought of your SQL Server encountering issues during the off-hours can be a significant source of stress. The fear of waking up to a server crash, data loss, or performance issues is enough to keep anyone up at night, questioning if their SQL Servers are properly taken care of. This concern …

Sleep Better With Our SQL Server Managed Services Read more »

Monitoring long-running queries is an essential part of database performance monitoring, as it can help identify queries that are causing performance issues and take corrective action to optimize them. Database Health Monitor for SQL Server provides insights into long-running queries, enabling you to identify performance bottlenecks and optimize query execution. Blocking Query Monitor: Identifying Performance Bottlenecks in Real-Time One of the primary ways Database Health Monitor tracks long-running queries is through its Blocking Query Monitor. When a query is blocked …

Troubleshooting Slow SQL Server Queries Read more »

10 Essential SQL Server Metrics to Monitor for Optimal Performance When it comes to managing SQL Server Performance, there are many metrics that need to be monitored continuously to ensure smooth operations. Ignoring these critical metrics can lead to slow response times, bottlenecks, or even system outages. In this blog post, we’ll highlight the top 10 performance metrics you should track, and how Database Health Monitor can make this process easier. Top 10 SQL Server Performance Metrics Wait Statistics What: …

Top 10 SQL Server Performance Metrics to Monitor for Optimal Results Read more »

How to Monitor Database Performance with Database Health Monitor Ensuring that your SQL Server databases are running smoothly is critical for any organization. Consistent monitoring helps prevent performance issues before they escalate into bigger problems. One of the best tools available for this purpose is Database Health Monitor. It’s a free and comprehensive tool designed for real-time monitoring, performance analysis, and proactive diagnostics of SQL Server environments. In this post, we’ll guide you through the process of using Database Health …

How to Monitor SQL Server Performance with Database Health Monitor Read more »

The Meaning Behind the Colors in Database Health Monitor Charts One of the key aspects of effective database monitoring is quick, visual insight into what’s happening with your SQL Server. The Database Health Monitor tool has always aimed to make database management easier and more intuitive, and a big part of that is in how information is displayed. A central feature of the tool is the color-coding used in its charts and reports, which help DBAs instantly spot problems or …

Database Health Monitor Charts Colors Read more »

Database Integrity in SQL Server: What It Is and Why It Matters Maintaining database integrity is one of the most critical aspects of managing any SQL Server environment. Simply put, database integrity ensures that the data stored in your SQL Server remains accurate, consistent, and reliable. However, when database integrity is compromised, it can lead to corruption, which can cause major headaches, data loss, and potentially catastrophic downtime for your organization. In this blog post, I will explain what database …

Checking Database Integrity in SQL Server Read more »

Help Shape the Future of Database Health Monitor One of the best parts of building Database Health Monitor is seeing how people use it and the ideas that come from that experience. Maybe you’ve had a moment where: A feature saved you time and made your day easier You thought of a small tweak that would make something even better You imagined a new report that would fit perfectly into your workflow That kind of feedback is exactly what helps …

Help Shape the Future of Database Health Monitor Read more »

Cut Costs Without Compromising Quality: Outsource Server Maintenance with Managed Services and Watch Your Savings Grow Welcome back, fellow data enthusiasts! Today, we’re diving into a topic that’s not only crucial for your business but also a game-changer in the world of database management: outsourcing server maintenance with Managed Services. At Stedman Solutions, we understand the importance of efficiency, reliability, and, above all, cost-effectiveness when it comes to managing your Microsoft SQL servers. Why Outsource SQL Server Maintenance? Let’s face …

Cut Costs Without Compromising Quality Read more »

SQL Server Version Number List: From SQL Server 7.0 to SQL Server 2022 Here is the updated blog post, including the pre-release code names for each major version of SQL Server: Understanding the version of SQL Server you’re working with is essential for troubleshooting, compatibility, and taking advantage of new features. Over the years, SQL Server has introduced many improvements, with each version being identified by a unique version number (or build number). During the development phase, each major version …

SQL Server Version Number Up to SQL 2025 Read more »