DBAs often skip Windows security because they are not Windows experts. Brian Kelley explains file, folder and share permissions and why teamwork matters.
Keeping msdb Small With sp_delete_backuphistory
Use sp_delete_backuphistory to control msdb growth, choose a retention window, and schedule weekly SQL Server Agent cleanup.
SQL SERVER – Reset SA Password – SQL in Sixty Seconds #066
Forgot the SA password or your DBA just left? This SQL in Sixty Seconds video shows how to reset SA password by logging in with Windows Authentication.
Syncing a Lookup Table Without MERGE: Insert, Update, Delete
Three plain statements can do the job of MERGE, and each one gives you its own row count. Here is how to build it, test it and trust it.
SQL SERVER – CTE can be Updated
Users often confuse a CTE with a temp table, but a CTE works like a view, and a CTE can be updated just like one. Matthew Spieth’s tip, with my notes.
UNISTR and Unicode Escapes in SQL Server 2025
Build Unicode strings with UNISTR in SQL Server 2025, compare NCHAR, and preserve accented letters, Hindi text, and emoji in storage.
Index Usage Stats Reset: Reading Them Without Being Fooled
Use index usage stats reset in SQL Server with practical examples, clear checks, and the limits you need before changing your database.