S3OLV April Change
Earlier this week I announced the meeting for the Las Vegas User Group. I blasted some of you with emails – along with people in our mailing list. Those...
2011-04-07
9 reads
S3OLV April Change
Earlier this week I announced the meeting for the Las Vegas User Group. I blasted some of you with emails...
2011-04-07
489 reads
Me Me Me, Event Event Event
Dear Readers,
Today’s blog shall be entirely stream-of-consciousness, which is to say, I don’t know exactly what I’m going to talk...
2011-04-07
817 reads
SQL Saturday #70
This blog is long overdue about my journey to Columbia SC for SQL Saturday #70. I was very fortunate to...
2011-04-07
431 reads
Should a DBA be involved in the physical set up of a Database Server? Part 3
This series of blog is to give a general idea what you could look at when setting up a new...
2011-04-07
1,502 reads
I Got Registered!
I’m going to SQL Rally! Are you going to SQL Rally? Have you heard of SQL Rally?
What’s SQL Rally?
I’m glad...
2011-04-07
424 reads
SnapManager Epic Fail – oh dear!
An ex colleague and good friend of mine has recently been having trouble with Snapmanager for SQL, anyone had similar...
2011-04-07
683 reads
Powershell Day 7
Day 7 – Security With great power comes great responsibility.—Stan Lee, The Amazing Spiderman So far We have discussed simple general...
2011-04-07
220 reads
On Leadership - Lead by Example
This is the second part of a leadership series I started with On Leadership - Lead from the Front. To recap...
2011-04-07
1,610 reads
Getting More Hardware Information from SQL Server Denali DMV Queries
As I recently discussed, I often hear from database professionals who are not allowed to access their database servers directly....
2011-04-06
2,839 reads
Blogs
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...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
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