Understand bitwise XOR, AND and OR in T-SQL, test and change integer flags, explain two sevens, and compare the newer bit functions.
SQL SERVER – Copy Database – SQL in Sixty Seconds #067
Backup and restore or detach and attach are not the only ways. This SQL in Sixty Seconds #067 video shows how to copy the database with the built-in copy feature.
Slow SQL Server? Three Queries to Run in the First Minute
A slow SQL Server needs a quick look before any deep tuning. Three queries, using only what SQL Server ships, show what is running, which session sits at the head of a blocking chain and what the server is waiting on. Every result here comes from a slowdown staged on SQL Server 2025.
Memory-Optimized Table Variables
Memory-optimized table variables can avoid tempdb work, but they need a filegroup, indexed table type, memory budget, and workload tests.
Presentation Skills for Technical Speakers: Notes from SQL Bangalore
Presentation skills were the focus of my SQL Bangalore session in May 2014. These original photos and slides accompany practical advice for explaining technical ideas clearly.
SQL SERVER – Windows File/Folder and Share Permissions – Notes from the Field #029
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.










