I wrote a blog post SQL SERVER on Linux – Commands, lots of people asked me that I should create a video about it as not everyone has Linux.
SQL SERVER on Linux – Version Specific Installation References and Commands
SQL Server on Linux installation requires instructions matched to the exact supported releases. My older customer checklist concerned Ubuntu.
Query Ignoring CPU Threads – SQL in Sixty Seconds #161
I have an interesting experience to share about the Query Ignoring CPU Threads. I was hired by a large eCommerce organization.
OS Threads by Scheduler in SQL Server: Count Them per CPU
OS threads by scheduler shows how many Windows threads each SQL Server scheduler owns. This post joins the scheduler, worker and thread views and counts them per CPU. It compares the counts with the server totals and explains the hidden schedulers that a careless query counts as CPUs.
Convert Empty String to NULL Date in SQL Server: Use NULLIF
To convert empty string to NULL in a date column, wrap the text in NULLIF before you cast it. A plain CAST returns 1900-01-01 and hides the problem. This post tests five expressions on six text values, including a real 1900 date, a run of spaces and a tab, and shows which ones stay correct.
Checking SQL Server Service Startup Type and Status From T-SQL
Inspect service startup type, current status, service account, and SQL TCP registry values, then compare configuration with live listeners.
SQL SERVER – List Service Broker Queue Count
I inspect Service Broker Queue Count through queue and internal-table catalogs. A customer requested a quick inventory.