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)
121 reads
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)
107 reads
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)
337 reads
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: https://github.com/way0utwest/DAB-Experiments
2026-09-17
27 reads
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
31 reads
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)
241 reads
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
45 reads
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)
193 reads
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
49 reads
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with edges, and uses greedy graph traversal to avoid comparing a query against every vector in...
2026-09-23 (first published: 2026-09-14)
138 reads
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Comments posted to this topic are about the item Adding new column with DEFAULT...
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
Comments posted to this topic are about the item You Need a DBA Pipeline
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