A simple puzzle: why does SQL Server show such a complicated execution plan for a single row, single table query on WideWorldImporters? Try to solve it.
Serial Zones in Parallel Plans: Where One Thread Does the Work
A parallel plan can still leave one core busy. See a harmless serial zone, a costly one, and how to read per-thread rows from the plan.
Event ID 7034: MSSQLSERVER Service Terminated Unexpectedly
Event ID 7034 reports that the MSSQLSERVER service terminated unexpectedly. The Application log held an APPCRASH entry with exception code 0xC0000005, an access violation. A clean restart of the server cleared the problem.
SQL SERVER – Backup to URL – Script to Generate the Create Credential and Backup Command using Access Keys
Backup to URL can use a SAS token or access keys. Here is a script that builds the CREATE CREDENTIAL and BACKUP commands from your Azure storage access keys.
How to Generate Random Password in SQL Server? – Interview Question of the Week #181
Question: How to Generate Random Password in SQL Server?
Answer: This is a fantastic question and here is the script to generate a random password in SQL Server
SQL SERVER Analysis Services – Unable to Start Service. Error: The Filename, Directory Name, or Volume Label Syntax is Incorrect
SQL Server Analysis Services would not start: the filename, directory name, or volume label syntax is incorrect. Here is what the event log showed and the fix.
Listing Server Credentials and Where They Are Used
Credentials hide their secrets but still tell you who depends on them. Build a small demo and follow a credential to its login, proxy and job step.