The Mirroring and Transaction Log Shipping options were missing in Database Properties for my freshly created database. Here is what caused it and the fix.
Refactoring Old T-SQL One Procedure at a Time
Begin refactoring old T-SQL with one procedure, repeatable inputs, duplicate-aware result checks, measured reads, and a simple change log.
Exporting and Sharing Registered Server Groups in SSMS
One shared server list can save you from running a query on the wrong server. Here is how to build it, export it without passwords and use it.
SQL SERVER – UNION and UNION ALL with TEXT DataType – Observation
UNION fails on a TEXT column with Msg 5335, yet UNION ALL with TEXT datatype works fine. Here is the code so you can try the difference yourself.
The Last Entered Row: Why a Table Needs an Ordering Column
A table has no last row until you define one. Here is how identity, event time and ties give different answers.
Page Verify CHECKSUM and Why It Matters
Page verify CHECKSUM detects altered database pages on read; inspect old settings, understand new writes, and review suspect pages.
SQL SERVER – Story of Temporary Objects
Temp tables, table variables and more: the story of Temporary Objects in SQL Server, why you would use them and how they can help performance and scalability.