Be Mindful of Deprecated Features in SQL Servers
Relying on deprecated SQL Server features is one of the fastest ways to turn a planned migration into an emergency. Learn how to audit and address them before you upgrade.
Read article →
How to Set up DB Mirroring using T-SQL
Set up SQL Server database mirroring with T-SQL to bypass GUI edition restrictions and configure synchronous or asynchronous mirroring with a repeatable, scripted process.
Read article →
How to Remove Replication Monitor Red Crosses
Red crosses in Replication Monitor usually mean orphaned metadata left behind after an incomplete replication removal. Here are the methods to clear them.
Read article →
How to Resolve Database Restore Operation-Related Errors
Learn how to recover a SQL Server database stuck in the restoring state using RESTORE WITH RECOVERY and alternative recovery paths when log files are missing or corrupt.
Read article →
How to create a SQL Server Database Snapshot
A SQL Server database snapshot captures your database at a point in time, giving you a fast rollback option before risky changes with minimal overhead.
Read article →
SQL Server Migration Checklist
A comprehensive SQL Server migration checklist to ensure nothing gets left behind, from data files and logins to agent jobs and linked servers.
Read article →
How to Find a Blocking Process
Blocking processes can cascade and cripple SQL Server performance within minutes. Learn how to find them quickly and act on what you find.
Read article →
Top Wait Types and Descriptions
Learn how to read SQL Server wait statistics and identify the wait types that actually matter, with inline descriptions built into the query result set.
Read article →
SQL Server Fixed Server-Level Roles
SQL Server includes 9 fixed server-level roles that are commonly misused. Learn what each role does and how to apply them correctly to protect your instance.
Read article →
How to Find Which Files Belong to Which SQL Database
Learn how to map SQL Server database files to their databases using a simple JOIN on sys.master_files and sys.databases, ordered by file size to spot problems fast.
Read article →
How to Find and Alert on Deadlock Conditions
Deadlocks can silently wreck application performance. Learn four practical methods to detect and alert on SQL Server deadlock conditions before they escalate.
Read article →
How to Check Fragmentation Level of a Database
Index fragmentation builds silently and drags down SQL Server performance over time. Learn how to check fragmentation levels and identify which indexes are worth acting on.
Read article →