My Docker container broke a day before my SQLBits talk and I had to rebuild it. Here is a beginner’s step-by-step guide to running the latest SQL Server in Docker.
Price in Effect on a Date: Querying a Price History Table
Query a price history table for the price effective on each order date, enforce unique starts, and compare APPLY lookups with range joins.
SQL SERVER – FIX: Database Diagram Error 15517 – Cannot Execute as the Database Principal Because the Principal ‘dbo’ Does Not Exist
Opening a database diagram failed with error 15517: Cannot execute as the database principal because the principal ‘dbo’ does not exist. Let me show you the fix.
What is Clean Buffer in DBCC DROPCLEANBUFFERS? – Interview Question of the Week #215
What is a clean buffer in DBCC DROPCLEANBUFFERS? No one had asked me this in 20 years, so here is the answer in the simplest words I could find.
SQL SERVER – FIX: The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) Node.
After a cluster rebuild, adding a replica failed: The specified instance is hosted by a system that is not a Windows Server Failover Cluster node. Here is the fix.
SQL SERVER – SQL Server Configuration Manager Missing from Start Menu
SQL Server Configuration Manager missing from the Start Menu? Open it directly from C:\Windows\System32 with the SQLServerManager msc file for your version.
Hypothetical Indexes in SQL Server: Find and Drop Them All
Hypothetical indexes are leftovers from the Database Engine Tuning Advisor. They hold a name and statistics but no data. This post lists them, shows they cannot serve a query, and drops them in two steps: a list you read first, and a drop second.