How do you know when memory constraints are hurting CPU in SQL Server? Someone asked me this loaded question before a Health Check, and here is my answer.
SQL SERVER – Default Worker Threads Per Number of CPUs
The default Worker Threads limit depends on SQL Server version, logical CPUs and memory. A workshop reader asked about automatic configuration.
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.