A server trigger can turn a wrong-tab DROP DATABASE into an error message. Here is a small demo that guards one name and removes itself at the end.
Rebuilding System Databases With Setup When master Is Lost
Plan rebuilding system databases with Setup when master has no usable backup, then restore logins, jobs, and configuration.
Measuring Space Used by Tables per Filegroup in T-SQL
Measure tables per filegroup from allocation metadata, include LOB and overflow pages, and separate partition placement from growth history.
Keeping Your Own Script Library
A script library stays useful when folders, names, review history, and safe headers make each SQL file understandable before it runs.
Counting Current Connections by Login, Host and Application
Try counting current connections by login, host, application and database, then inspect sleeping transactions and save a baseline.
Granular Server Roles: ##MS_ServerStateReader## and Friends
Assign granular server roles in SQL Server 2022, inspect membership, and give monitoring accounts the state access their queries need.
Auditing Failed Logins With the Error Log and Extended Events
Investigate failed logins with the SQL Server error log and a focused Extended Events session, then group attempts and decide what to do.