Fix the backup error Cannot open backup device, Operating system error 5, Access is denied: common causes and the solution that worked for me.
Hash Index Bucket Count for Memory-Optimized Tables
Size hash index bucket count from distinct keys, inspect empty buckets and chains, rebuild a test index, and choose range indexes wisely.
SQL SERVER – Customization of New Query in SQL Server Management Studio
A junior DBA was fired for dropping a table on production. Here is how to customize the New Query window in SSMS so it opens with the commands you need.
SQL SERVER – User Defined Audit with SQL Server
Bank security checks taught me patience about audits. Here is how a user defined Audit in SQL Server lets you write your own events to the audit log.
Why SELECT 28F3 Returns 28: Float Literals and Hidden Aliases
Explain float literals, why SELECT 28F3 creates an alias, how 28E3 uses scientific notation, and why explicit AS prevents confusion.
Linked Server Logins: Stop Mapping Everyone to sa
Audit linked server logins for blanket remote sysadmin mappings, test with a low-privilege identity, and replace broad access safely.
SQL SERVER – What are my Trace Flags Enabled on SQL Server?
A DBA friend wanted to see the trace flags enabled on his production servers. Here is how to find them easily, and a word of caution about using them.