SQL Server Blog Posts from Stedman Solutions
SQL Server Blog Posts
Welcome to the hub for all things SQL Server! Here, you’ll find the latest blog posts covering tips, tricks, and insights into SQL Server management, performance tuning, query optimization, and much more. Whether you’re a seasoned database administrator or just starting your journey with SQL Server, our blog is packed with valuable content to help you tackle real-world challenges and improve your skills.
At Stedman Solutions, we’re passionate about SQL Server and dedicated to sharing knowledge gained from over three decades of experience. Our blog posts cover a range of topics, including resolving database corruption, enhancing query performance, understanding T-SQL techniques, and leveraging tools like Database Health Monitor. Each article is written with a practical focus, offering solutions and advice you can apply directly to your SQL Server environment.
Take a moment to explore the latest posts below. Whether you’re here to solve a specific problem, learn about a new feature, or stay updated on best practices, you’re in the right place. If you find a topic that resonates with your current challenges, be sure to dive in—and feel free to contact us if you need personalized assistance or want to learn more about our SQL Server services.
Latest SQL Server Blog Posts
- What a SQL Server Index Health Score Really Tells Youby SteveStedmanSQL Server index health is more than a fragmentation percentage: one score with its reasons, backed by ten indexing reports rolled into cards.
- SQL Server Index Fragmentation: Stop Chasing the Percentby SteveStedmanSQL Server index fragmentation percentage can be misleading. Here is the number that actually predicts what a rebuild will buy you, and where to find it.
- SQL Server LOB Columns in Indexes Are Costing You Diskby SteveStedmanSQL Server LOB columns in indexes duplicate data on disk. Here’s how to find every one, measure the cost, and know which are safe to remove.
- Database Health Monitor V4 Stedman SQL Podcast Sn 3 Ep 14by Shannon LindsayStedman SQL Podcast Sn 3 Ep 14 Database Health Monitor Version 4 Database Health Monitor Version 4 is here, and it’s one of the biggest updates we’ve ever made! In Season 3, Episode 14 of the Stedman SQL Podcast, Steve Stedman, George Stedman, and Mitchell Glasscock take a tour through what’s new in Database Health… Read More »Database Health Monitor V4 Stedman SQL Podcast Sn 3 Ep 14
- Backup and recovery for SQL Serverby SteveStedmanAs a database professional, you know how critical it is to have a solid backup and recovery plan in place for your SQL Server environment. Whether you’re dealing with accidental data deletes, ransomware attacks, disk failures, or complete datacenter outages, having a well-planned backup and recovery strategy is essential to ensure that your organization can… Read More »Backup and recovery for SQL Server
- Database Health Monitor Version 4 Has Been Releasedby Mitchell GlasscockWe’re excited to announce that Database Health Monitor Version 4 is now available! Version 4 represents one of the biggest updates to Database Health Monitor since its original release. While the most obvious change is the completely redesigned interface, this release goes far beyond a visual refresh. We’ve rebuilt and improved nearly every part of… Read More »Database Health Monitor Version 4 Has Been Released
- What SQL Server Suspect Pages Are Trying to Tell Youby SteveStedmanSQL Server suspect pages sit quietly in msdb until a disk finally fails. Learn what each event means and how to tell damage from a fix.
- SQL Server Scalar UDF Inlining: Free Speed You’re Missingby SteveStedmanSQL Server scalar UDF inlining can erase a function’s cost entirely, or it can silently never fire. Here is how to see which is true for yours.
- Happy Labor Dayby SteveStedmanIn observance of the US federal holiday Labor Day, Stedman Solutions, LLC will be closed for the first Monday in September. As the founder of Stedman Solutions, LLC, I would like to take this opportunity to thank all of the Team members for everything they do every day. If you need emergency help during this… Read More »Happy Labor Day
- How to Find Local SQL Server Instances Without Guessingby SteveStedmanSee how Database Health Monitor can find local SQL Server instances automatically, so you are not guessing a name during an incident.
- Why Your SQL Server Alert History Is Full of Noiseby SteveStedmanHundreds of alert emails don’t mean hundreds of problems. Learn to read SQL Server alert history before you touch a single threshold.
- Reserved Versus Used Space: What Your Tables Hideby SteveStedmanSee reserved versus used space for every table in your database, and find exactly which one is wasting space you could reclaim today.
- Backup and recovery relating to disk failureby SteveStedmanRecovering from disk failure is a critical aspect of backup and recovery for SQL Server. A disk failure can occur due to a variety of reasons such as hardware failure, power outages, or natural disasters. When a disk failure occurs, it can result in data loss, system downtime, and even business disruption. To mitigate the… Read More »Backup and recovery relating to disk failure
- How to Track SQL Server Table Size Before It Surprises Youby SteveStedmanSee SQL Server table size ranked across every table, spot which ones dominate the database, and know before a restore or migration bites.
- Find Patterns in Your SQL Server Blocking Historyby SteveStedmanSee your SQL Server blocking history as an hour-by-day heat map, so a recurring problem shows up as a pattern instead of a guess.
- The Importance of SQL Server Backup and Recovery: Learn from Expertsby SteveStedmanIn the wise words of Benjamin Franklin, “If You Fail to Plan, You Are Planning to Fail.” This timeless adage holds particular relevance when it comes to safeguarding your SQL Server databases. A failure to adequately prepare for data loss scenarios—be it due to hardware malfunctions, data corruption, or increasingly prevalent ransomware attacks—can have devastating… Read More »The Importance of SQL Server Backup and Recovery: Learn from Experts
- SQL Server Waits by Query: Find What’s Actually Slowby SteveStedmanSee SQL Server waits by query, split into CPU time and wait categories, so you know whether to tune the query or fix what is blocking it.
- A Sneak Peek at the Backup and Recovery Courseby SteveStedman“Oh yes of course I have SQL Server backups” Take another look. Do they fit your needs? About 40% of new customers we meet do not have adequate backups for their business! That’s 1 in 3 companies! Insufficiently meeting the business needs, the consequences of inadequate database backups can be perilous. Failing to align backups… Read More »A Sneak Peek at the Backup and Recovery Course
- September Promotion on my backup and recovery course.by SteveStedmanHey there! Steve Stedman here, and I’m thrilled to announce a special sale on my Backup and Recovery Course for SQL Server! As a database professional, you understand the critical importance of having a solid backup and recovery plan. It’s the difference between a minor hiccup and a major catastrophe that could disrupt your entire… Read More »September Promotion on my backup and recovery course.
- Introducing SQL Server Mentoring: Your Shortcut to Expert Guidanceby SteveStedmanHey there, Steve Stedman here, ready to share some exciting news with you. At Stedman Solutions, we understand that sometimes all you need is a little assistance without committing to a long-term arrangement. That’s why we’ve developed our SQL Server Mentoring service to cater specifically to your needs. SQL Server Mentoring is the perfect blend… Read More »Introducing SQL Server Mentoring: Your Shortcut to Expert Guidance
- Logical Reads vs. Physical Readsby Mitchell GlasscockIf you’ve spent time tuning SQL Server queries, you may have seen these two numbers side by side: logical reads and physical reads. Maybe you have seen one or the other be some absurdly high number and didn’t think much of it. But in reality they could be eye openers on behind the scenes query… Read More »Logical Reads vs. Physical Reads
- LCK_M_RIn_S_LOW_PRIORITY Wait Type on SQL Serverby SteveStedmanUnderstanding the LCK_M_RIn_S_LOW_PRIORITY Wait Type in SQL Server In SQL Server, understanding wait types is crucial for diagnosing performance issues and improving database efficiency. One of the less commonly encountered wait types that can impact performance is LCK_M_RIn_S_LOW_PRIORITY. Let’s dive into what it means, the context in which it occurs, and how to mitigate this… Read More »LCK_M_RIn_S_LOW_PRIORITY Wait Type on SQL Server
- August special – SQL Server Mentoring (and more)by SteveStedmanAt Stedman Solutions, we strive to offer flexible consulting services to our clients, ranging from fixed-price projects to ongoing hourly work. Each approach caters to different needs, but today I want to shed light on one of our unique services that has proven particularly beneficial for our clients – our mentoring packages. Here’s how our… Read More »August special – SQL Server Mentoring (and more)
- SQL Server Database Health Monitor: Job History, Problem Indexes & Backup Reportsby SteveStedmanFeatures in Database Health Monitor: Job History, Problem Indexes, and Backup Reports Managing a SQL Server environment requires constant attention to job activity, index health, and backup reliability. Without clear visibility into these areas, DBAs can easily miss scheduling conflicts, inefficient index configurations, or gaps in protection that lead to larger issues later. Database Health… Read More »SQL Server Database Health Monitor: Job History, Problem Indexes & Backup Reports
- Understanding Color Meanings in Database Health Monitor Charts for SQL Server Performanceby SteveStedmanUnderstand SQL Server performance with Database Health Monitor’s color-coded charts. Learn red, green, and blue meanings for efficient database health.alth Monitor tool transforms complex data into accessible insights through its intuitive use of color-coded charts. These visual cues allow database administrators to quickly identify issues, track improvements, and maintain optimal performance with minimal effort. Each… Read More »Understanding Color Meanings in Database Health Monitor Charts for SQL Server Performance
- SQL Server Mentoring – We’ve got your back.by SteveStedmanHey there, it’s Steve Stedman from Stedman Solutions. I’m reaching out today because I understand that, at times, we could all use a guiding hand without necessarily tying ourselves down to a lengthy commitment. And that’s exactly why we’ve introduced our SQL Server Mentoring service. Think of SQL Server Mentoring as a pocket-sized consultant, ready… Read More »SQL Server Mentoring – We’ve got your back.
- Expertise at Its Best: Unleashing the Power of our Experienced DBAs and Programmersby SteveStedmanWith a technical team of 5 people with well over 100 years of combined experience we are available to help with your next project. Our team of highly experienced Database Administrators (DBAs) and programmers is uniquely qualified to support and elevate your projects. They bring an array of expertise to the table, each with their… Read More »Expertise at Its Best: Unleashing the Power of our Experienced DBAs and Programmers
- How to Select the Best SQL Server Performance Tuning Consultantby SteveStedmanHow to Choose a SQL Server Performance Tuning Consultant When your SQL Server starts to lag, with queries taking longer than expected or applications grinding to a halt, it’s a clear sign that Performance Tuning is needed. Hiring a SQL Server Performance Tuning consultant can be a game-changer, transforming your sluggish database into a high-performing… Read More »How to Select the Best SQL Server Performance Tuning Consultant
- Master Your SQL Projects with Stedman Solutions SQL Server Mentoringby SteveStedmanWhether you’re diving into an exciting new SQL project or struggling with ongoing ones, there’s one resource that can provide the support you need to drive your project to successful completion—Stedman Solutions’ SQL Server Mentoring. We are here to offer unmatched expertise and insights, helping you navigate the challenging landscape of SQL Server with ease.… Read More »Master Your SQL Projects with Stedman Solutions SQL Server Mentoring
- Exclusive SQL Performance Tuning Trainingby SteveStedmanSteve and the team at Stedman Solutions, LLC have put together an email based performance tuning course where each week you can get tips and tricks to get more performance out of your SQL Server. Become part of this exclusive group of subscribers learning to put the horse power back into their SQL Server. What… Read More »Exclusive SQL Performance Tuning Training
- The Time-Saving Power of Line Numbers in SQL Server Management Studioby SteveStedmanThe Time-Saving Power of Line Numbers in SQL Server Management Studio The Time-Saving Power of Line Numbers in SQL Server Management Studio When working with SQL Server, small adjustments in your environment can lead to big improvements in productivity. One feature that often goes unnoticed in SQL Server Management Studio (SSMS) is the use of… Read More »The Time-Saving Power of Line Numbers in SQL Server Management Studio
- What’s New in Database Health Monitor – August 2026 Releaseby Mitchell GlasscockVersion 1458 is now available. The headline addition is the new tray icon and Windows service, which lets you set up historic monitoring on servers where SQL Server Agent isn’t available to schedule the collection. Alongside that, there’s a new least-privilege role for granting access to monitoring data without granting sysadmin, several alerting enhancements, new… Read More »What’s New in Database Health Monitor – August 2026 Release
- Stedman Solutions, LLC Presents: The August Special on SQL Server Mentoringby SteveStedmanWe are excited to announce our August special promotion tailor-made for those looking to hone their SQL skills and ensure their SQL servers operate at peak efficiency. Here’s the deal: When you sign up for our 4 or 8-hour SQL Server Mentoring program, you won’t just benefit from our comprehensive guidance and expertise. As a… Read More »Stedman Solutions, LLC Presents: The August Special on SQL Server Mentoring
- Exploring AI Tools for SQL Server Workby SteveStedmanExploring AI Tools for SQL Server Work AI is everywhere right now, and there are a lot of interesting developments happening in this space. Tools like GROK, ChatGPT, and Copilot are making their way into the daily workflows of developers and DBAs. Each has its strengths, and depending on how you work, one might be… Read More »Exploring AI Tools for SQL Server Work
- Proactively Manage SQL Server Disk Space with the New Disk Space Forecast Report in Database Health Monitorby SteveStedmanDisk Space Forecast Report: Proactively Manage SQL Server Disk Space in Database Health Monitor As SQL Server DBAs, one of the most stressful surprises is a sudden “out of disk space” error, especially in production environments where backups, logs, and data growth can quickly fill drives. That’s why the Disk Space Forecast Report in Database… Read More »Proactively Manage SQL Server Disk Space with the New Disk Space Forecast Report in Database Health Monitor
- Join Types Posterby SteveStedmanI have been getting a lot of good feedback on twitter lately about the JOIN Types poster. Hi, Steve Stedman here, and I want to share with you a poster that I have created that provides a visual representation of the different join types in SQL Server. The poster is available at https://stedman.us/largePoster, and it… Read More »Join Types Poster
- Exclusive SQL Performance Tuning Trainingby SteveStedmanSteve and the team at Stedman Solutions, LLC have put together an email based performance tuning course where each week you can get tips and tricks to get more performance out of your SQL Server. Become part of this exclusive group of subscribers learning to put the horse power back into their SQL Server. What… Read More »Exclusive SQL Performance Tuning Training
- Need some help? We provide mentoringby SteveStedmanDo you aspire to refine your SQL Server abilities and elevate your professional standing? Your search ends here! Stedman Solutions’ SQL Server Mentoring offers an ideal solution for IT specialists keen on advancing their skillset. Our mentoring program is characterized by its personalized, interactive nature, ensuring you receive tailored guidance and support to maximize your… Read More »Need some help? We provide mentoring
- SQL Server MAXDOP Settings: Recommended Configurations and Best Practicesby SteveStedmanProper configuration of the Max Degree of Parallelism setting remains one of the most impactful yet frequently overlooked aspects of SQL Server performance tuning. This server-level option directly influences how queries are distributed across available processors, affecting everything from response times on large analytical workloads to overall throughput in busy transactional environments. Understanding its behavior… Read More »SQL Server MAXDOP Settings: Recommended Configurations and Best Practices
- August Promotion Mentoring includes Free Daily Monitoringby SteveStedmanFor the month of August we are running a promotion. When you purchase a 4 or 8 hour mentoring block with Stedman Solutions, you will receive 6 months of our Daily Monitoring product for free. The monitoring is over a $600 value. As an IT professional working on SQL projects, you may occasionally find yourself… Read More »August Promotion Mentoring includes Free Daily Monitoring
- SQL Code Smells: Non-Parameterized Queriesby Mitchell GlasscockYour SQL Server is running hot. CPU is elevated, the plan cache is bloated, and queries that should be instant are taking seconds. You look at the query text and everything seems reasonable. The problem is not what the queries are doing. It is how they are being sent. Non-parameterized queries are one of the… Read More »SQL Code Smells: Non-Parameterized Queries
- 5 Things Every Junior DBA Should Know Stedman SQL Podcast Sn 3 Ep 12by Shannon LindsayStedman SQL Podcast Sn 3 Ep 13 5 Things Every Junior DBA Should Know In this episode, Mitchell Glasscock and George Stedman discuss the situations they have been faced with starting as Junior DBA’s and gaining knowledge and tips over the years. They explain the top 5 tips and tricks to make sure you don’t… Read More »5 Things Every Junior DBA Should Know Stedman SQL Podcast Sn 3 Ep 12
- Table Use Report in Database Healthby SteveStedmanJuly is Database Health Monitor Month! July has arrived, and it’s time to turn our attention to the heartbeat of our digital world – our databases! As the founder of Database Health and Stedman Solutions, I’m thrilled to proclaim this month as Database Health Monitor Month! This is our annual chance to celebrate the unsung… Read More »Table Use Report in Database Health
- The Feature That Prevents 2 AM Calls: How Database Health Monitor Forecasts Disk Capacity Problems Weeks in Advanceby SteveStedmanDisk space exhaustion is one of the most preventable SQL Server emergencies in existence. Unlike hardware failures or unexpected query plan changes, disk space issues develop on a predictable trajectory. Databases grow. Log files accumulate. The available space decreases at a rate that is measurable, trackable, and extrapolatable into the future. There is no reason… Read More »The Feature That Prevents 2 AM Calls: How Database Health Monitor Forecasts Disk Capacity Problems Weeks in Advance
- Download Free Database Health Monitor for SQL Server Trialby SteveStedmanThe Database Health Monitor for SQL Server is available for download on our website, and the best part is that it’s a free trial ! The free download provides access to all the core features of the tool, including real-time monitoring, customizable dashboard, alerting system, and reporting capabilities. Download Today! The Database Health Monitor offers… Read More »Download Free Database Health Monitor for SQL Server Trial
- Monitor Wait Statistics and Blocking Queries for Better Database Performanceby SteveStedmanEffective database performance often hinges on identifying and addressing the hidden delays that impact query execution. Wait statistics and blocking queries represent two of the most common yet overlooked sources of slowdowns, where resource contention can cascade into broader system inefficiencies if left unchecked. Database Health Monitor provides targeted visibility into these areas, enabling administrators… Read More »Monitor Wait Statistics and Blocking Queries for Better Database Performance
- SQL Server Database Health Monitor: Optimize Performance & Prevent Issuesby SteveStedmanSQL Server is the backbone of many critical business applications, and ensuring its performance and reliability is a top priority for database administrators. However, identifying potential issues before they escalate into major problems can be a daunting task without the right tools. That’s where a robust solution like the Database Health Monitor comes in, offering… Read More »SQL Server Database Health Monitor: Optimize Performance & Prevent Issues
- Database Health Featuresby SteveStedmanJuly is Database Health Monitor Month! July has arrived, and it’s time to turn our attention to the heartbeat of our digital world – our databases! As the founder of Database Health and Stedman Solutions, I’m thrilled to proclaim this month as Database Health Monitor Month! This is our annual chance to celebrate the unsung… Read More »Database Health Features
- Load Testing with Query Loading Ramp Stedman SQL Podcast Sn 3 Ep 12by Shannon LindsayLoad Testing with Query Loading Ramp Stedman SQL Podcast SQL Podcast Sn 3 Ep 12 Steve Stedman and Mitchell Glasscock discuss the Query Loading Ramp feature of Database Health Monitor, a tool for load testing SQL queries. They demonstrate running a load test with 400 sessions, simulating real-world traffic, and identify performance issues. The test… Read More »Load Testing with Query Loading Ramp Stedman SQL Podcast Sn 3 Ep 12
- The Hidden Danger of Missing Primary Keys in SQL Serverby SteveStedmanThe Hidden Danger of Missing Primary Keys in SQL Server One of the most overlooked issues in SQL Server databases is missing primary keys. You might be surprised at how often I come across production databases—sometimes mission-critical ones—where tables don’t have a primary key defined. At first glance, this may seem like a minor oversight,… Read More »The Hidden Danger of Missing Primary Keys in SQL Server
- Detecting Failing Database Health Monitor Jobs in SQL Serverby SteveStedmanCatching Failing Database Health Monitor Jobs with Check 239 Catching Failing Database Health Monitor Jobs with Check 239 One of the most valuable aspects of Database Health Monitor is its ability to watch for issues that might otherwise go unnoticed until they become much larger problems. Check 239 is a great example of this proactive… Read More »Detecting Failing Database Health Monitor Jobs in SQL Server
- How UPDLOCK in SELECT Statements Causes SQL Server Performance Issues and Blockingby SteveStedmanWhen working with SQL Server, subtle misconfigurations can lead to significant performance challenges. One such issue arises from the misuse of the UPDLOCK hint hint in SELECT statements, which can cause excessive wait times and blocking. While update locks are designed to protect data integrity during UPDATE operations, applying them to SELECT queries can inadvertently… Read More »How UPDLOCK in SELECT Statements Causes SQL Server Performance Issues and Blocking
- 7 SQL Server Issues Keeping IT Managers Awake at Night (And How to Fix Them)by SteveStedmanAs an IT manager, the demands of maintaining a reliable database environment often extend far beyond standard working hours, particularly when critical business applications depend on SQL Server. Even with established processes in place, underlying issues can develop without immediate visibility, leaving leaders to wonder about the stability of systems that support daily operations. Proactive… Read More »7 SQL Server Issues Keeping IT Managers Awake at Night (And How to Fix Them)
- Optimize SQL Server Performance with Database Health Monitor Toolkitby SteveStedmanManaging SQL Database Efficiency can often feel like navigating a complex maze, especially when dealing with large datasets and high transaction volumes. As a DBA or developer, you know that even minor inefficiencies can lead to significant slowdowns, frustrated users, and costly downtime. The key to maintaining a healthy database environment lies in having the… Read More »Optimize SQL Server Performance with Database Health Monitor Toolkit
- The Hidden SQL Server Performance Killer: Implicit Conversionsby SteveStedmanThe Hidden SQL Server Performance Killer: Implicit Conversions When SQL Server Performance issues begin appearing, many companies assume the only solution is to add more hardware, increase cloud resources, or purchase additional SQL Server licenses. In reality, some of the biggest performance problems come from small development decisions that quietly consume CPU resources over time.… Read More »The Hidden SQL Server Performance Killer: Implicit Conversions
- Who Is Database Health Monitor Built For?by SteveStedmanWhen we created Database Health Monitor, we had one simple goal in mind: SQL Server monitoring should be accessible to everyone. Monitoring your SQL Servers should not require a massive budget, a complicated licensing model, or weeks of procurement meetings just to get started. Whether you manage one SQL Server or hundreds, Database Health Monitor… Read More »Who Is Database Health Monitor Built For?
- SQL Server Performance Tuning: Boost Efficiency with Expert Tipsby SteveStedmanUnlock the full potential of your SQL Server with expert SQL Server Optimization Techniques strategies. Whether you’re a seasoned database administrator or an IT professional looking to enhance your skills, optimizing your SQL Server environment is crucial for maintaining efficiency and scalability. In this blog post, we’ll dive into key techniques and insights that can… Read More »SQL Server Performance Tuning: Boost Efficiency with Expert Tips
- History of Database Health Monitorby SteveStedmanDatabase Health Monitor has a rich history rooted in the ongoing need for SQL Server professionals to gain deeper visibility into their database environments. What began as a focused effort to simplify performance diagnostics has evolved into a comprehensive tool relied upon by DBAs and developers worldwide. Over more than a decade of development, the… Read More »History of Database Health Monitor
- The Backup Gap You Dont Know You Haveby SteveStedmanThe Backup Gap You Don’t Know You Have: How Database Health Monitor Surfaces Recovery Blind Spots Most SQL Server environments have backup jobs. Most of those backup jobs have been running for years, completing on schedule, logging success in the SQL Server Agent job history, and never triggering an alert. The people responsible for those… Read More »The Backup Gap You Dont Know You Have
- Table Use Report in Database Health Monitor: Track SQL Server Table Usage and Optimize Performanceby SteveStedmanThe Table Use Report in Database Health Monitor shows exactly how often each SQL Server table is queried, helping DBAs find active versus idle tables fast. With this level of insight, teams can make smarter decisions around indexing priorities, data archiving, and security reviews without relying on guesswork. This post examines how the report surfaces… Read More »Table Use Report in Database Health Monitor: Track SQL Server Table Usage and Optimize Performance
- The Affordable SQL Server Monitoring Toolby Mitchell GlasscockIf you’re a DBA or SQL Server professional shopping for a monitoring tool, you’ve probably experienced sticker shock. Many SQL Server monitoring tools on the market can run into the thousands of dollars per year, per server. That’s a real budget problem for anyone who just needs clean, reliable visibility into their SQL Server environments.… Read More »The Affordable SQL Server Monitoring Tool
- Closed in observance of Independence dayby SteveStedmanAs the summer season reaches its peak and patriotic displays begin to appear across the country, the Fourth of July stands as a cherished reminder of America’s journey toward independence and self-determination. At Stedman Solutions, this holiday provides a welcome opportunity to step away from daily operations and join in the national celebration of freedom… Read More »Closed in observance of Independence day
- Stop Guessing: Your First SQL Server Load Test in 10 Minutesby SteveStedmanIf you have never run a load test against SQL Server before, the idea can sound like itrequires a separate team, a separate tool, and a separate budget line. It does not. WithQuery Loading Ramp, included free in Database Health Monitor, you can run a real,meaningful load test in about ten minutes. Here is exactly… Read More »Stop Guessing: Your First SQL Server Load Test in 10 Minutes
- Happy Canada Day: Celebrating Our Canadian Clientsby SteveStedmanAs July 1st approaches, Canadians across the country and around the world prepare to mark Canada Day with pride and gratitude. This annual celebration honors the nation’s rich history, diverse communities, and the enduring spirit that has shaped a welcoming and innovative land from coast to coast. At our company, we are especially thankful for… Read More »Happy Canada Day: Celebrating Our Canadian Clients
- The Making of Database Health Monitor Stedman SQL Podcast Sn 3 Ep 11by Shannon LindsayThe Making of Database Health Monitor Stedman SQL Podcast Sn 3 Ep 11 Steve Stedman and his team discuss the evolution of Database Health Monitor from its inception in 2011 to its current state. Initially developed using SSRS reports, DHM transitioned to a standalone desktop application by 2014. Key features include the SQL Performance Viewer,… Read More »The Making of Database Health Monitor Stedman SQL Podcast Sn 3 Ep 11
- Monitor Wait Statistics and Blocking Queries with Database Health Monitorby SteveStedmanThank you for considering Database Health Monitor as your go-to tool for monitoring and optimizing your databases. In addition to the benefits I mentioned in my previous article, I’d like to discuss how our tool can help you with two specific challenges: wait statistics and blocking queries. Wait Statistics Wait statistics are critical for understanding… Read More »Monitor Wait Statistics and Blocking Queries with Database Health Monitor
Additional Thoughts
Thank you for exploring our SQL Server blog! We’re committed to providing fresh, relevant, and actionable content to help you navigate the complexities of SQL Server. From troubleshooting performance issues to mastering advanced features, our articles are designed to empower you with the knowledge you need to succeed. Whether you’re solving a specific problem or expanding your expertise, we’re here to support you every step of the way.

SQL Server is constantly evolving, and so are the challenges and opportunities that come with managing it. That’s why we frequently update our blog with new posts, insights, and tutorials. By staying engaged with our latest articles, you’ll gain an edge in understanding new features, identifying best practices, and applying innovative solutions in your SQL Server environment. We aim to keep you informed and ahead of the curve.
If you’ve found value in the content here, be sure to bookmark this page and check back regularly. With each new post, we strive to address the topics that matter most to SQL Server professionals, based on the real-world scenarios we encounter every day. Our goal is to create a resource you can rely on for timely, trustworthy, and practical SQL Server advice.
Don’t miss out on future updates! Whether it’s an in-depth guide, a quick tip, or a thought-provoking perspective, there’s always something new to discover. And if you have specific topics you’d like us to cover, we’d love to hear from you. Keep checking back, and let us help you make the most of your SQL Server journey.





















































