Analyze Actual Execution Plan
One of the many new sets of functionality introduced in SQL Server Management Studio 17 is the new option “Analyze...
2018-08-22 (first published: 2018-08-06)
2,634 reads
The Scary DBA
Youtube Channel Update: 3 August 2018
I’ve posted a number of new videos to the Youtube channel that might be of interest if you’re a data...
2018-08-03
404 reads
Identifying HIPAA, PCI & SOX Data for Masking
Working for a company based in the UK (still currently a part of the EU) I had a lot of...
2018-08-15 (first published: 2018-07-30)
2,691 reads
Database Fundamentals #18: The SELECT Statement
In my previous Database Fundamentals post, I showed you how to use the Query Designer to build a query. That...
2018-07-23
830 reads
Databases and DevOps, Tools are the Easy Part
Moving your database development, deployment and management into a DevOps methodology does involve choosing and implementing tools and tooling. Tools...
2018-07-25 (first published: 2018-07-16)
2,074 reads
What Is The Preferred Join Operator in SQL Server?
I schedule many of my blog posts at least 2-3 weeks out, so I have time to adjust them, change,...
2018-07-16 (first published: 2018-07-09)
3,816 reads
Why Aren’t You Using SSMS 17?
Last fall, Microsoft split the coding and release of SQL Server Management Studio away from any dependency on the server...
2018-07-12 (first published: 2018-07-05)
4,774 reads
My Speaking Schedule
I have quite a few speaking engagements coming up. Rather than an intermittent blog post, I’ve decided to have a...
2018-07-04 (first published: 2018-06-25)
1,657 reads
Database Fundamentals #17: Learning T-SQL
While SQL Server Management Studio (SSMS) provides a robust graphical user interface (GUI), the commands you’re going to use the...
2018-06-18
977 reads
Plan Metrics Without the Plan: Trace Flag 7412
I place a lot of emphasis on capturing actual execution plans because of the runtime metrics, but with Trace Flag...
2018-06-19 (first published: 2018-06-11)
1,804 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers