More Azure Goodies
Microsoft keeps sneaking little things under the door for Windows Azure SQL Database. This time it’s a couple of new...
2013-11-12 (first published: 2013-11-05)
1,785 reads
Blog Posts
Power BI first impressions
I have been using Power BI the past few weeks (see my video of all the features) after I was invited...
2013-11-12
1,375 reads
Prevent creating stored procedures with RECOMPILE hint – Policy Based Management is your friend !
I got motivated to write this post as there was a question on twitter which was like -
The user was...
2013-11-12
1,262 reads
The Cloud Is Scary – #TSQL2sDay #49
It’s T-SQL Tuesday time! I haven’t contributed in a while, so I really wanted to participate this time. The topic...
2013-11-12
644 reads
T-SQL Tuesday – Cloud Atlas – #TSQL2sDay
This month, Jorge Segarra (Blog | @SQLChicken) is running T-SQL Tuesday on the cloud. T-SQL Tuesday is a monthly blogging event where a number...
2013-11-12
791 reads
T-SQL Tuesday #48 – Cloud Atlas
T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will...
2013-11-12
552 reads
T-SQL Tuesday #48–Cloud Atlas
I never saw the movie, though it’s on my list to watch sometime. I love the Wachowski’s as directors.
This month...
2013-11-12
981 reads
T-SQL Tuesday: Head in the Clouds
This month’s T-SQL Tuesday is hosted by yours truly. Our topic this month is simply the Cloud. If you work in IT there’s approximately zero chance that you’ve managed...
2013-11-12
21 reads
T-SQL Tuesday: Head in the Clouds
This month’s T-SQL Tuesday is hosted by yours truly. Our topic this month is simply the Cloud. If you work in IT there’s approximately zero chance that you’ve managed...
2013-11-12
14 reads
T-SQL Tuesday: Head in the Clouds
This month’s T-SQL Tuesday is hosted by yours truly. Our topic this month is simply the Cloud. If you work...
2013-11-12
941 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