Database testing is often skipped until there is a problem. Here is my approach to testing database performance with tSQLt and SQLQueryStress.
SQL SERVER – CLONEDATABASE: Generate Statistics and Schema Only Copy of the Database
CLONEDATABASE can Generate Statistics and schema-only diagnostic copies without copying table rows. I use that distinction when investigating optimizer behavior.
SQL SERVER – CREATE OR ALTER Supported in Service Pack 1 of SQL Server 2016
SQL Server 2016 Service Pack 1 introduced CREATE OR ALTER. I use it for repeatable deployments of supported object types.
How to Use OR Condition in CASE WHEN Statement? – Interview Question of the Week #102
How do you use an OR condition in a CASE WHEN statement? A tricky interview question, and how to write it so the logic works.
Linked Servers and What Goes Wrong With Them
Investigate linked server performance and failures by checking remote work, provider settings, security mappings, and the alternatives available.
SQL SERVER – Performance Analysis of Backup to Azure
Compression saves backup space, but does it save time too? My Performance Analysis of backup to Azure compares timings with and without compression.
DMV to Replace DBCC INPUTBUFFER Command – Interview Question of the Week #100
Is there a DMV to replace the DBCC INPUTBUFFER command? An interview question that caught me off guard, answered with sys.dm_exec_input_buffer.