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 SERVER – Database Coding Standards and Guidelines Introduction
Coding Standards and Guidelines Introduction: after my interview questions series, readers asked for coding standards, so I kept this set short and practical.
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.