SQLAuthority.com crossed 6 Million Visits in 2 years and 3 months. Thank you, readers! I also announce a small surprise for readers who take part here.
Granting VIEW SERVER STATE Without Handing Out sysadmin
Grant VIEW SERVER STATE or SQL Server 2022 performance permissions to a monitoring login, add job history access, and test its limits.
Keeping SSMS Up to Date
Keeping SSMS up to date means reading release notes, choosing a supported channel, planning side by side installs, and checking settings.
Five DMVs Worth Memorizing
Five DMVs worth memorizing show SQL Server sessions, active requests, waits, index use, and file I/O during an incident.
An Upgrade Checklist That Fits on One Page
An upgrade checklist that fits on one page keeps before, during, and after checks visible, including backups, logins, jobs, clients, and rollback.
Comparing Two Wait Stats Snapshots to See What Changed
Compare wait stats snapshots over a chosen window, subtract cumulative counters, remove background waits, and calculate rates and average waits.
Skills That Make a DBA Hard to Replace
The skills that make a DBA hard to replace combine tested recovery, careful performance work, useful automation, and clear communication.