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.
SQL SERVER – Fix – Agent Starting Error 15281 – SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the security configuration for this server
SQL Server Agent fails to start with Error 15281 because Agent XPs are turned off? Here is how to enable Agent XPs with sp_configure and start the agent.
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 – Fix: Error: Compatibility Level Drop Down is Empty
Fix it when the compatibility level drop down is empty in database properties, with SQL Server 2012 and 2014 on one machine. Cause and fix.