A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most of my adult life drinking whatever was closest, usually instant, usually while standing over the...
2026-08-12
244 reads
T-SQL Tuesday #201 - Temp Tables, Friend or Foe?
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Jeff Taylor
(blog) asks us for our take on temp tables:
So, do you...
2026-08-31 (first published: 2026-08-12)
426 reads
Excellent article on securing msdb
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's why you should read it if you're a DBA or security professional.
2026-08-11
303 reads
T-SQL Tuesday #201: Temp Tables
This month we have a new host, which I am grateful for. So many people have stopped blogging that it’s a challenge to keep this going. Jeff Taylor has...
2026-08-11
137 reads
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than simply creating one and using it. As I started digging into the topic, I realized...
2026-08-11
327 reads
Accept the no and move on
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin. When we are rejected, whatever the situation, many of us want to know why. We...
2026-08-10
295 reads
Don’t Fight with AI
I was recently trying to handle a simple task with a few AI tools to see how well things worked. I realized that AI isn’t great for everything and...
2026-08-10
433 reads
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the diagnosis and it will usually stop at the first two subtasks that come to mind:...
2026-08-07
193 reads
Car Update: August 2026
It’s been some time since I provided a car update, so I decided to showcase a few things I’ve learned about my cars since the last one. In this...
2026-08-07
166 reads
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales owns sales transactions, Finance owns budgets, and Shared Data owns common tables such as Customer,...
2026-08-06
210 reads
Blogs
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
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...
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