Gratitude
I want to take a moment to thank a few people for being amazing.
First up, Thomas LaRock is wrapping up...
2017-07-06
334 reads
Writing Dynamic and Random Tests Cases for Pester
I have written a module SQLDiagAPI for consuming the SQL Server Diagnostics API with PowerShell. I blogged about how I...
2017-07-06
461 reads
Upgrade Your SQL Server CASE Statements With IIF and CHOOSE
SQL Server 2012 introduced IIF and CHOOSE functions and I completely missed they even existed until recently. They make some...
2017-07-06
59 reads
Book Review: VMware vSphere 6.5 Host Resources Deep Dive
If you are actively managing VMware environments with workloads that have high performance needs (such as all of the virtualized...
2017-07-05
497 reads
SSoL–Exiting Root
I don’t think most of us need to know Linux, but if you end up managing a system, it’s good...
2017-07-05
598 reads
Balanced Power Saving T-SQL script
We can easily spend tens of thousands of dollars on core licences for SQL Server, and then we go and...
2017-07-05
186 reads
I Love Entity Framework
I love Entity Framework. I also like (not love) nHibernate. That’s right, as a DBA and data professional, I’m telling...
2017-07-17 (first published: 2017-07-05)
2,784 reads
When do Distribution Statistics Get Updated?
Statistics objects are important to us for allowing SQL to make good estimates of the row-counts involved in different parts...
2017-07-05
787 reads
What is the system_health extended events session?
Similar to the default trace the system_health session is automatically started up when the instance starts and collects information about...
2017-07-19 (first published: 2017-07-05)
2,159 reads
Persisting data in docker containers – Part Three
Last week in Part Two I went through how to create named volumes and map them to containers in order...
2017-07-19 (first published: 2017-07-05)
3,194 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers