PostgreSQL Support in the Data API Builder
Next week I’m at VS Live in San Diego (register and join me) and one of my talks is on the Data API Builder. I want to show how...
2026-09-23 (first published: 2026-09-09)
137 reads
Blog Posts
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting something a little more practical for day-to-day DBA work. Something I could open, work through...
2026-09-22
222 reads
Don’t Fear the Technology
The concern that a particular technology is going to destroy the world seems to be an ever present fear. The technology changes but the fear and the marketing around...
2026-09-22
129 reads
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates HammerDB benchmarking for SQL Server using Docker. If you’ve ever needed to run TPC-C or...
2026-09-21 (first published: 2026-09-12)
258 reads
Creating a Local Model Chatbot on Windows
After my session at VSLive last week, I had a few questions from the audience. I’m adding some of these into blogs, and this was one: How do I...
2026-09-21
241 reads
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice to have; in many cases, they’re what gets your résumé through the door. I’ve been...
2026-09-21
25 reads
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups. The ability to leverage the snapshot capabilities of modern storage arrays to take application consistent...
2026-09-21 (first published: 2026-09-11)
168 reads
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
27 reads
Advice I Like: Lots of Ideas
“A multitude of bad ideas is necessary for one good idea” – from Excellent Advice for Living Whenever we read about the success of someone or something, we often...
2026-09-18 (first published: 2026-09-04)
263 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-18
52 reads
Blogs
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...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
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