GET_BIT reads a zero-based bit position. Compare tinyint offsets, retain the source value, and check type width before selecting a position.
SQL SERVER – Unable to Set Cloud Witness. Error: An Existing Connection Was Forcibly Closed by The Remote Host
Setting up a cloud witness for a client failed with: An existing connection was forcibly closed by the remote host. Test-NetConnection pointed to the real cause.
SQL SERVER – How to Get Started with Docker Containers with Latest SQL Server?
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.