Database Coding Standards and Guidelines Part 2: skip SELECT *, use SET NOCOUNT ON, prefer CTEs over temp tables, avoid cursors, and more query tips.
SQL SERVER – Database Coding Standards and Guidelines Part 1
Database Coding Standards and Guidelines Part 1: naming rules for tables, stored procedures, triggers, indexes, primary keys and foreign keys.
SQL Agent Alerts Every Instance Should Have
SQL Agent alerts should route serious severity events and errors 823, 824, and 825 through tested operators and Database Mail.
Sending Query Results by Email
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.