Sending query results by email with Database Mail requires clear formatting, tested delivery, safe attachments, and size limits.
What Hiring Managers Look for in a DBA
Hiring managers look for DBAs who can restore data, stay calm under pressure, explain tradeoffs, and show evidence of sound operations.
Collecting Server Facts Into One Table Every Night
Collect Server Facts each night to track SQL Server versions, settings, databases, and file sizes in a practical history table.
SQL Server Interview Questions and Answers Part 4
Interview Questions and Answers Part 4 begins with SQL Profiler: what it is, how it captures events to a file or table, and how to keep traces small.
SQL SERVER – Fix: Server: Msg 7391, Level 16, State 1, Line 1
Msg 7391 has no single fix. I list the causes I have hit on my servers, from distributed transactions on linked servers to DTC firewall settings, to try one by one.
Auditing Who Holds CONTROL SERVER and IMPERSONATE Rights
Audit CONTROL SERVER and impersonation grants alongside sysadmin and role inheritance, test effective rights, and remove excess access.
Checking the Update History of an Instance
Reconstruct SQL Server update history from Setup Bootstrap logs, startup error logs, and the current build when no patch ledger exists.