Ten years (and a couple jobs) ago, I wrote about naming default constraints to avoid having SQL Server name them for you. I closed with the following statement:
SQL Server...
2026-04-17 (first published: 2026-04-06)
368 reads
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person twice in May 2026. With summer vacations coming up, this is a perfect time of...
2026-03-30
12 reads
This is long overdue but life and distractions happened. It’s been a little over two months since I returned home from PASS Summit 2025.
2026-02-06 (first published: 2026-01-26)
146 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Mike Walsh
(blog) asks us:
Write two short notes to yourself. One to the...
2025-12-29 (first published: 2025-12-09)
236 reads
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with Automation! I will have a more comprehensive post in the coming days. Slides and demo...
2025-11-21
25 reads
I’ve been enjoying Ben Weissmann (Blog | LinkedIn) & Jess Pomfret’s (Blog | LinkedIn ) weekly program Finding Data Friends for a couple years now, getting to know (by...
2025-10-27
7 reads
In less than one month, I will be speaking not once but twice at PASS Data Community Summit 2025.
Thursday, November 20th at 1 PM I will be in the...
2025-10-20
14 reads
I don’t recall where this came up (probably in SQLSlack), but I had a need to install an older version of dbatools to test something related to loading the...
2025-10-06 (first published: 2025-09-16)
154 reads
In the blink of an eye, summer has passed. I don’t know about you, but I’m ready for things to get back to “normal” after 10 weeks of events...
2025-09-08
17 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, John Sterrett
(blog) asks us:
What are you doing, or what can we do...
2025-07-08
18 reads
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Efficient query performance in Amazon Redshift often comes down to how well you manage...
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Recently, our dev teams approach me for advice on improving their huge heap table...
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Comments posted to this topic are about the item Why Your Index Isn't Being...
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers