It's time for T-SQL Tuesday #198! This month's topic is change detection.
The post T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes? first appeared on Data Savvy.
2026-05-05
165 reads
Model Context Protocol, or MCP, is one of those technical ideas that sounds more complicated than it really is. The easiest way to think about it is this: MCP...
2026-05-20 (first published: 2026-05-04)
510 reads
When starting with AWS RDS Aurora for managing relational databases in the cloud, many data engineers face the challenge of leveraging its cutting-edge features while maintaining performance and reliability....
2026-05-22 (first published: 2026-05-04)
191 reads
This is Week 1 of PowerShell Strikes Back – a four-week May series for SQL Server DBAs who have dabbled in PowerShell but never stopped to nail down the...
2026-05-20 (first published: 2026-05-04)
509 reads
This happened to me recently after being busy with non-data modeling tasks for a few weeks. I went to add a relationship and was confused about the behavior. Read...
2026-05-18 (first published: 2026-05-04)
215 reads
Every major model out there can summarise documents, write code and answer multi step questions – then if you decide to go with a specific vendor based on costs...
2026-05-18 (first published: 2026-05-04)
972 reads
For about the last … hmmm…maybe decade or more, when you downloaded a release update from MOS for your database, the patch would consist of a single folder which...
2026-05-04
59 reads
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework (DTEF) foundation exam. I’m blogging about it because I know a lot of people struggle...
2026-05-08 (first published: 2026-05-01)
365 reads
“On the way to a grand goal, celebrate the smallest victories as if each one were the final goal. That way, no matter where it ends, you are victorious.”...
2026-05-15 (first published: 2026-05-01)
159 reads
Hopefully you have just seen that APEX patchset bundle 16 has just been released for 24.2. Of particular note is that a well-publicised Chrome change to deprecate the unload...
2026-05-01
66 reads
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
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...
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