A Microsoft white paper on the Implementation of Database Object Schemas, which act like namespaces and make security easier to manage in SQL Server.
SQL SERVER – Introduction to SQL Azure
What is SQL Azure? A simple introduction to Microsoft’s cloud database, why it is mostly a branding change, and why it appeals to SQL Server users.
SQL SERVER – SQL Server Express – A Complete Reference Guide
A complete reference guide to SQL Server Express: what it costs (it is free), when to use it over the full version, and its maximum database size.
ISO Week Numbers vs DATEPART(week): Grouping Sales by Week
Group sales by ISO week and ISO year, compare DATEPART week behavior, and avoid New Year errors caused by session settings.
SQL SERVER – Index Seek vs. Index Scan – Difference and Usage – A Simple Note
Index seek vs. index scan: the two ways SQL Server reads data through an index, how they differ, and when each one is used. A simple note.
Raising a Database Compatibility Level Safely
Raise a compatibility level safely by capturing a Query Store baseline, changing one database, comparing plans, and keeping a tested reversal.
sys.objects, sys.all_objects and sys.system_objects
Compare sys.objects, sys.all_objects and sys.system_objects to find SQL Server user objects, system objects, and metadata visibility gaps.