Budget several SQL Server instances on one Windows host, inventory services, assign memory and ports, and monitor shared resource pressure.
Tracking Backup Throughput and Duration From msdb History
Track backup throughput and duration from msdb history, compare recent trends, and keep striped devices from duplicating backup totals.
Finding Edition-Bound Features With sys.dm_db_persisted_sku_features
Use sys.dm_db_persisted_sku_features before an edition move, inventory databases, and distinguish feature evidence from licensing checks.
Diagnosing Blocking Chains With sys.dm_exec_requests
Trace blocking chains from active requests to a candidate head session, inspect sleeping transactions, and verify the owner before action.
Build Your Own SQL Script Library
A SQL script library saves you from solving the same problem twice. This post shows a folder layout by task, a header block with the tested version, naming habits, a safe history, tests on a scratch server and a way to retire old scripts, with one small read-only script as an example.
Right-Sizing SQL Server: Reading CPU and Memory Use Before Consolidation
Base right-sizing SQL Server on sampled CPU, memory pressure, buffer use and interval I/O, then compare peaks across a full business cycle.
Splitting DBCC CHECKDB Across the Week for a Large Database
Keep a large database under regular integrity checks by splitting DBCC CHECKDB work across seven nights and auditing coverage.