SQL Server 2016 SP2 Cumulative Update #17 is available, with 20 enhancements. The build number is 13.0.5888.11.
I use a real-world example showing why you shouldn't use deprecated functionality like SQL Server Profiler.
For this month's T-SQL Tuesday, I talk about my two least favorite data types:
In this tip, I talk about cases where SQL Server will interpret YYYY-MM-DD as YYYY-DD-MM, which is less than optimal.
I talk about one scenario where the system table
sys.sysprocesses almost led us down the wrong path.
After seeing this question pop up on forums multiple times, I wrote a quick tip about enforcing unique constraints where order doesn't matter.
SQL Server 2019 Cumulative Update #9 is available, with 140 enhancements. The build number is 15.0.4102.2.
After a question on #sqlhelp, I dug into what could be making sys.partitions slow, and how they might get the required information in a more efficient way.
While I previously promoted a way to stop storing database name in your Extended Events sessions, there's an upside to collecting it: the ability to filter. Read on for more info.
A security fix for an elevation of privilege issue has been released for all supported versions of SQL Server.
For this month's T-SQL Tuesday I talk about a few distractions I enjoy when not slinging T-SQL.
I explain a recent case where sp_prepare came in handy: trying to validate a plan guide's impact.
I talk about a trade-off when using collect_database_name for DDL events captured by Extended Events.
I recognize this year's recipient of my Community Influence of the Year award.
This month's T-SQL Tuesday is about what we've learned from presenting. I give an embarrassing account about how I learned to be prepared and not go off script.
This month's T-SQL Tuesday is about how we are dealing with the madness that is 2020.
I recently came across an interesting issue with CHECKDB snapshots, as well as a bit of information missing from the documentation.
More background on ParamParser, some recent changes, and several syntax examples.
Rob Volk asks us to share our favorite analogies that help explain database-related concepts to less technical folk.
SQL Server 2019 Cumulative Update #8 is available, with 104 enhancements. The build number is 15.0.4073.23.
I've made the GitHub repository for ParamParser public; here is some more background behind this project.