I make myself smile
Sometimes, usually when I’m editing video, I see myself do something silly. Today was one of those times, and these...
2011-02-09
710 reads
Work Goals for 2011-Part 2
It’s been a few weeks since I wrote my early thoughts on my goals for this year, and you can...
2011-02-09
796 reads
SQL University: SQL Server Security Architecture - 3rd Party, Some Options
Day 3 of Security Week at SQL University is now in session. You're implementing a third party solution and you...
2011-02-09
4,161 reads
A NULL Is Not Unknown
Like it or not, NULLs happen. I don’t think that’s I’ve ever seen a production database that didn’t have NULLs.
Waiter,...
2011-02-09
787 reads
PowerShell Interfaces with Other Hammers
This month’s installment of T-SQL Tuesday is hosted by Pat Wright (blog | twitter). Pat says: “So the topic I have chosen for this month is Automation! It can...
2011-02-09
13 reads
PowerShell Interfaces with Other Hammers
This month’s installment of T-SQL Tuesday is hosted by Pat Wright (blog | twitter). Pat says: “So the topic I have...
2011-02-09
840 reads
T-SQL Tuesday #15 DBA Automaton
Often, we hear about DBA's automating everything under the sun. Why? It simplifies the job and creates time to work on other projects.
Related Posts:
Automating like an Enterprise DBA January...
2011-02-09
11 reads
T-SQL Tuesday #15 DBA Automaton
I have been incognito for the last couple of weeks and nearly missed TSQL Tuesday this month. If it weren’t...
2011-02-09
826 reads
You really like me?
And a bunch of other people who are really talented. My Zero to Cube session won the Summit Spotlight track...
2011-02-08
755 reads
Conquering Kilimanjaro & Cancer !
Day 1 – Leaving for Africa
After almost 12 months of fundraising, training, walking up various mountains, sleepless nights and plenty of...
2011-02-08
470 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