This final level focuses on the practical application of changesets in complex scenarios. From table transformations to ETL-driven logic, it explores how to manage database changes when rollback is no longer purely structural, emphasizing control, predictability, and pragmatic solutions.
Steve notes that DBAs need a privileged pipeline, separate from what they might use to update database schema.
You're looking at page split numbers in a monitoring tool or Perfmon, and you've heard that page splits are bad, so you're lowering fill factor, expecting your page splits to go down.
Share your view on the database landscape and you could win USD$500.
When we build software, or we put together a process, we need to consider how teams use it, not just individuals.
This article looks at how the parameter sniffing performance problem can be helped in SQL Server 2025 with PSPO.
The situation raises a question I’ve been thinking for a while: why does SQL Server allow trigger code to inherit the privileges of whichever principal happens to fire it?
One of the challenges in digital systems involves how we reference other resources. Steve discusses whether absolute or relative references are better.
Steve chats with a few developers and gets some insights into how they are coping with AI.
Diagnosing memory issues can be hard. This article shows how one administrator used custom tracking to determine whether SQL Server, SSAS, or SSRS was the issue.
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