Official X account of the Database Health Monitor Application - Making SQL Servers Run Faster - Get it FREE today! stedman.us/download
Why Hiding Copy-Only Backups Reveals the Truth About Your SQL Server Backup ChainWhy Hiding Copy-Only Backups Reveals the Truth About Your SQL Server Backup ChainBy Steve Stedman – Stedman Solutions,...
A short video by Steve Stedman describing what Database Health Moni...
In the world of database administration, few oversights carry as much weight as the absence of primary keys on SQL Server tables. While it might seem like a minor detail during initial setup or rapid...
Welcome to our YouTube video on the powerful CPU by Hour by Day rep...
Unplanned downtime is a silent thief, stealthily draining resources and disrupting operations across industries. For businesses of all sizes, the financial ripple effects of system failures—whether...
When you need to check compatibility level SQL Server after upgrading, start by reviewing the compatibility levels assigned to your databases. These settings determine which features and behaviors...
You inherit a database and start digging through the schema. Everything looks reasonable on the surface until you notice a handful of tables with no clustered index. No obvious reason. They just...
Navigating the complexities of SQL Server performance issues can be a daunting task for any organization. When your database starts to lag, impacting business operations, finding the right expert...
Learn how to run DBCC CHECKDB in SQL Server, detect database corruption, interpret results, and repair integrity issues before data loss occurs.
Learn how non-parameterized queries bloat the plan cache, spike CPU usage, and slow SQL Server—and how to fix them for better performance and security.
Learn how Database Engine Tuning Advisor (DTA) in SQL Server works, its index recommendations, and the hidden risks of over-indexing.
Learn why SQL Server shows Recovery Pending, what it means, how long recovery takes, and steps to monitor and resolve database issues quickly.
Learn how to implement SQL Server login auditing with Audit and Extended Events. Compare pros, performance impact, and best practices.
Learn how to choose the right SQL Server backup strategy to balance storage, recovery time, and data protection with full, differential, and log backups.
Learn how to protect SQL Server database integrity and prevent corruption with proven strategies, DBCC CHECKDB tips, and best practices.
Heap tables in SQL Server can silently hurt performance. Learn how missing clustered indexes cause scans, RID lookups, and slower reads and writes.
Understanding the Log Shipping Instance Report in Database Health Monitor Log shipping has been a staple in SQL Server for what feels like forever, and for good reason. It's a reliable, time-tested...
Master the SQL Server OUTPUT clause to capture inserts, updates, and deletes for auditing and undo. Boost your T-SQL skills fast with this short course.
Stedman Solutions, LLC will be closed on Memorial Day in honor of those who served. Emergency support is available via our contact form or by phone.