One sequence, two tables, and an auditor asking about number 8. See where gaps come from, how duplicates sneak in, and where uniqueness should live.
Indexed Views: When the Faster Reads Are Worth It
Evaluate indexed views by building a sales summary, comparing read savings with write maintenance, and using NOEXPAND where required.
Running SQL Server in a Container for Testing
Create a SQL Server container for testing from Windows PowerShell, keep data in a named volume, and separate disposable runtime from backups.
Puzzle – Usage of New Index Hints – ForceSeek and ForceScan
SQL Server Denali adds the FORCESCAN hint next to FORCESEEK. A weekend puzzle on these Index Hints: write a query where each one improves performance.
SSAS Tabular vs Multidimensional: Choosing for a New Project
Compare Tabular vs Multidimensional for SSAS projects, including storage, relationships, write-back, team skills, and model checks.
Logging ETL Runs in a Table
Logging ETL runs in SQL Server gives each step start and end times, row counts, and errors so the next morning’s investigation has facts.
SQL SERVER 2012 Functions – 14 New Functions – A Quick Guide
All 14 new SQL Server 2012 Functions in one quick guide, from TRY_CONVERT and PARSE to DATEFROMPARTS and CHOOSE, each linked to my post and Books Online.