The SSIS Catalog captures a lot of cool information by default. Andy Leonard shares the query he uses for parsing SSIS Catalog messages in SSISDB.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SELECT 7 & 7 or 7 ^ 7: Bitwise XOR, AND and OR on Integers
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 slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.