Short version You want to get this running as fast as possible. Do these four steps, and then check the compatibility section later in this post. Step 1: Install...
2025-11-18
69 reads
Last week I asked you to write about SQL Server 2025 and what things you might be looking forward to in the new version. First, as usual, is Rob...
2025-11-18
147 reads
Writing Better Dynamic SQL
This updated and "sort" of a style guide is for SQL developers and, to some extent, DBAs, essentially anyone daring (and sometimes...
2025-11-18
380 reads
Holy cow FabCon Vienna was incredible! This recap is extremely delayed because I’ve run into some serious decision fatigue about what to include (and my amazing hubby got me...
2025-11-18
18 reads
The Power BI Enhanced Report Format (PBIR) will soon become the default, and that’s a good thing because it significantly makes git integration easier. You can already enable it...
2025-11-20 (first published: 2025-11-18)
148 reads
SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is a great feature that can help with writing SQL queries and scripts sql development. However,...
2025-11-15
197 reads
If it fails where you thought it would fail that is not a failure. – from Excellent Advice for Living This is a great quote, especially for those of...
2025-11-28 (first published: 2025-11-14)
437 reads
Quite a long title for a short blog post ??While deploying a DACPAC (from a SQL Server Data Tools Database Project) through Azure Devops, I got the following error...
2025-11-16 (first published: 2025-11-14)
59 reads
I had a great question asked of me the other day and thought I would turn the answer into a blog post. The question is “I’m an experienced DBA...
2025-11-12
34 reads
Some of the best career enhancers you can buy. Why I Go to Conferences I go for two big reasons: Learning from the best. The folks teaching at...
2025-12-01 (first published: 2025-11-12)
290 reads
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Comments posted to this topic are about the item Adding new column with DEFAULT
I've got a web application for my side business. I've added a SQL Server...
Comments posted to this topic are about the item Looking for New Blood
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers