Author: Steve Stedman

Discover Stedman Solutions: Your Go-To for SQL Server Management Welcome to an exciting exploration of how Stedman Solutions can transform your business challenges into opportunities for growth. In today’s fast-paced and ever-evolving market, staying ahead requires innovative strategies and reliable support. Whether you’re grappling with operational inefficiencies, seeking to streamline processes, or aiming to enhance your technological capabilities, Stedman Solutions offers tailored expertise to meet your unique needs. Let’s dive into the ways this dynamic company can become your partner …

Discover How Stedman Solutions Can Help Read more →

This Veterans Day, we’re taking time to recognize and thank those who have served — including the Veterans who are part of our own team at Database Health Monitor. From November 11th through November 17th, we’re offering a special opportunity for Veterans who purchase a Database Health Monitor subscription: a free 1-hour onboarding session with the Database Health Monitor development team. This session is designed to help you get the most out of Database Health Monitor. We’ll walk through setup, …

Honoring Veterans with a Complimentary 1-Hour Onboarding Session Read more →

There’s a lot happening in the world of AI right now, and tools like Grok, ChatGPT, and GitHub Copilot are becoming essential for developers and DBAs. In the latest versions of SQL Server Management Studio (SSMS) 2025 and Visual Studio, Copilot is now built-in, offering real-time code suggestions. But when working outside those environments, I’ve found Grok — accessible via X (formerly Twitter) — to be especially powerful and flexible. Why This Matters: Small Wins Add Up A task that …

Using AI Tools Like Grok and Copilot to Boost SQL Productivity Read more →

Saying Thank You with Database Health Monitor Rewards At Stedman Solutions, we wanted to find a meaningful way to thank everyone who uses Database Health Monitor. The longer you use the tool, the more value you should get — without any additional cost. This idea came to me while working with a hosting provider that increased customer benefits each month as a loyalty perk. We decided to bring that same spirit to Database Health Monitor. Here’s an example: after three …

Database Health Rewards Program Read more →

One of the checks in the Database Health Monitor Quick Scan Report that often raises questions is check #243: data and log files on the same drive. At first glance, this might not seem like a big deal. After all, it’s just disk space, right? But in reality, placing your MDF/NDF files (data) and your LDF files (logs) together is a bad practice for two main reasons: Performance & I/O SQL Server accesses data and log files in very different …

Why You Should Not Put Data and Log Files on the Same Drive in SQL Server Read more →

One of the fundamental aspects of working with SQL Server is understanding how to get the number of rows affected by a query. Whether you’re working with SELECT, INSERT, UPDATE, or DELETE statements, knowing the row count can provide critical insights into your database operations. In this blog post, we’ll explore different methods to retrieve the row count in SQL Server and discuss scenarios where each method is most effective. 1. Using COUNT(*) with SELECT Statements When you need to …

Various was To Count Rows in SQL Server Read more →

SQL Server Business Continuity Self-Assessment Ensuring the resilience of your SQL Server environment is critical in today’s data-driven world, where downtime can result in significant financial losses and reputational damage. Business continuity planning goes beyond just backup and recovery; it encompasses a comprehensive strategy to maintain operations during unexpected disruptions. Whether it’s a hardware failure, a cyberattack, or a natural disaster, your organization needs to be prepared to keep data accessible and systems operational. This self-assessment will guide you through …

SQL Server Business Continuity Self Assessment Read more →

Ensuring the optimal performance of your SQL Server databases is crucial for your business operations. Database monitoring plays a vital role in maintaining this performance, identifying issues before they escalate into significant problems. At Stedman Solutions, we specialize in SQL Server management, offering comprehensive managed services that elevate your database monitoring to the next level. Here’s how our services can help you achieve seamless and efficient database monitoring. Why Database Monitoring Matters Effective database monitoring is essential for several reasons: …

How Stedman Solutions Managed Services Enhances Your SQL Server Read more →