Author: Steve Stedman

By Posted on Posted in Uncategorized

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 »

By Posted on Posted in Uncategorized

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 »

By Posted on Posted in SQL Server Consulting Services

Why Stedman Solutions Should Be Your SQL Server Consultant If you’re looking for a reliable SQL Server consultant to enhance your database environment’s performance, stability, and security, look no further than Stedman Solutions. Here’s why you should consider us: 1. True SQL Server Specialists Stedman Solutions is dedicated exclusively to SQL Server. Unlike general IT consultants, we focus 100% on SQL Server, enabling us to offer in-depth expertise across all areas, including Performance Tuning, Disaster Recovery, and high availability. Our …

Your SQL Server Consultant Read more »

By Posted on Posted in Uncategorized

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 »

By Posted on Posted in Uncategorized

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 »

By Posted on Posted in Uncategorized

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 Database Performance Read more »

By Posted on Posted in SQL Server Corruption Tagged with

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 …

Database Integrity in SQL Server Read more »

By Posted on Posted in Uncategorized

Stay Ahead with Our Free SQL Server Newsletter If you manage SQL Server environments, staying up-to-date with the latest tools and techniques is crucial. That’s why we created the SQL Server Newsletter—a free, weekly resource packed with expert insights and practical tips. Whether you’re a DBA, developer, or IT manager, our newsletter delivers valuable, actionable information. What’s Inside the Newsletter? Our newsletter keeps you informed and equipped to tackle SQL Server challenges. Here’s what you can expect each week: 1. …

Stay Ahead with Our Free SQL Server Newsletter Read more »

By Posted on Posted in Uncategorized

What is a SQL Query Subquery? A subquery (also known as an inner select or nested query) is a query nested inside another SQL query. It allows you to build more complex queries by embedding one SELECT statement within another. Subqueries can help solve problems that require multiple steps or aggregations, and they enable you to retrieve data dynamically based on the results of the subquery. In this blog post, we’ll explore what a subquery is, how it works, and …

What is a SubQuery Read more »

By Posted on Posted in Uncategorized

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 List Read more »