Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built content in them takes a lot longer. Moving content to another workspace usually means redeploying...
2026-09-29
10 reads
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the object history for different schema changes, so as you are evaluating how your changes might...
2026-09-28
15 reads
Software is hard. While I love our Lucid Gravity, I realize that they are behind Tesla with software. A few of the weird UX and software engineering decisions they’ve...
2026-09-25
34 reads
Making Data AI-Ready, Part 2 (This is the second article in a three-part series on making data AI-ready. Part 1 covered the fundamentals of AI-ready data, this article looks...
2026-09-24
383 reads
Can you use your GPUs when running a local model under Ollama? You can, and it really depends on how you run Ollama and what your hardware is. Ollama...
2026-09-23
36 reads
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
130 reads
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
224 reads
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
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
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
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