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)
259 reads
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
I have said and written this many times: Redgate Software is the type of company I’d want to build if I founded another company. It’s a great place, and...
2026-09-11
66 reads
How to Check TDE Progress and Elapsed Time in SQL Server
Transparent Data Encryption (TDE) protects SQL Server data and log files while they are stored...
2026-09-25 (first published: 2026-09-11)
235 reads
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
Ten years ago today, I filmed a Pluralsight Play by Play on open source PowerShell. I was standing between Jason Helmick and Jeffrey Snover, trying very hard not to...
2026-09-09
74 reads
It’s time for T-SQL Tuesday again and this is a great prompt to start writing. I might have written about this before, but it’s a story that sticks with...
2026-09-16 (first published: 2026-09-08)
231 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Marlon Ribunal
(blog) asks us to talk about that one SQL Server outage...
2026-09-08
42 reads
How I used AI for this postChatGPT to generate images based on info specifically provided by me,including examples.Grammarly to catch grammar and sentence construction errors. In Part 1, we...
2026-09-16 (first published: 2026-09-08)
168 reads
My T-SQL Tuesday #202 entry for Marlon Ribunal's invitation on memorable SQL Server outages. Two nights I still remember minute by minute, and what I do differently because of...
2026-09-18 (first published: 2026-09-08)
304 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