Runtime Metrics In Execution Plans
Capturing query execution metrics is much easier now that you can see the runtime metrics in execution plans when you’re...
2017-09-06 (first published: 2017-08-22)
1,610 reads
SQL Puzzle 3: Knights and Queens
I thought I’d do another chess puzzle this month. This one is a variant on the Eight Queens problem:
SQL Puzzle...
2017-09-01 (first published: 2017-08-22)
2,344 reads
SQL Saturday Charlotte (#683)
I am so excited to be helping out with SQL Saturday Charlotte again this year. This is the 6th year...
2017-08-22
411 reads
SQLpassion Online Trainings in September 2017
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-08-22
235 reads
Using the SSIS Script Component With Multiple Outputs
One of the more common questions I find in SQL Server SSIS forums is how to split apart a single...
2017-08-22
487 reads
Training and tips to get certified with Microsoft (Part 4 and last)
In the previous posts I posted some questions that I usually get when we talk about getting certified with SQL Server also listed some resources you can use to...
2017-08-21
12 reads
Adding a New Default to a Column
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-21
497 reads
Automatic Seeding in Always On Availability Groups in SQL Server 2016
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-08-21
997 reads
Training and tips to get certified with Microsoft (Part 4 and last)
In the previous posts I posted some questions that I usually get when we talk about getting certified with SQL...
2017-08-21
140 reads
New Whitepaper – Capture Production Error States
System administrators of the world, if a VM experiences a problem that takes down business-critical application, your job is to...
2017-08-21
120 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