A New Word: Dorgone
dorgone– adj. wondering if you could slip away from an event or group conversation without anyone noticing your absence. I’m not often concerned about announcing my arrival or departure...
2026-09-18
30 reads
Tell It Once: Setting Up Claude With Skills and MCP Servers
Many of us use AI the same way every single day. Open a tab. Paste in a question. Copy the answer out. Fix what it got wrong. Then tomorrow,...
2026-09-30 (first published: 2026-09-18)
292 reads
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
This is the companion to Why sys.fn_dblog...
2026-09-30 (first published: 2026-09-18)
178 reads
What Does It Mean to Make Data AI-Ready?
Making Data AI-Ready, Part 1 (This is the first article in a three-part series on making data AI-ready. Part 1 explains what AI-ready data actually means, Part 2 looks...
2026-09-28 (first published: 2026-09-17)
357 reads
Using the Data API Builder–VS Live San Diego Resources
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: https://github.com/way0utwest/DAB-Experiments
2026-09-17
29 reads
Running a Local LLM On Your Laptop Resources
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It was a fun session and I’m glad a few people came up to ask questions....
2026-09-16
33 reads
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger
I was creating a question on sp_readerrorlog and realized that this procedure is different from the one it wraps: xp_readerrorlog. This post digs into a few differences. Another post...
2026-09-28 (first published: 2026-09-16)
253 reads
Why sys.fn_dblog Is Undocumented And Why It's Still There
Why sys.fn_dblog Is Undocumented And Why It's Still There
Why sys.fn_dblog Is Still Undocumented — And Still There
This article is about why things are the way...
2026-09-16
46 reads
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what kind of stories would come out of it.
The topic was simple:
That one SQL Server outage...
2026-09-25 (first published: 2026-09-15)
198 reads
A Last Minute Trip to the EU
My life has some crazy travel stretches for sure. Between speaking, office visits, customer trips, I can be on the road a lot. As it is, I’ve flown across...
2026-09-14
51 reads
Blogs
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Forums
Adding new column with DEFAULT II
Comments posted to this topic are about the item Adding new column with DEFAULT...
Advanced Deployment Scenarios: Stairway to Reliable Database Deployments Level 7
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
You Need a DBA Pipeline
Comments posted to this topic are about the item You Need a DBA Pipeline
Question of the Day
Adding new column with DEFAULT II
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers