Opportunity Cost versus Real Cost
One of the hardest lessons to learn and put into practice as a self-employed consultant is that of Real Cost...
2011-02-08
1,029 reads
Immersions Training
The last week of January 2011, I wrote a blog post entering a contest for free training at the hands of SQLSkills. Later that week an announcement was made...
2011-02-08
8 reads
Immersions Training
The last week of January 2011, I wrote a blog post entering a contest for free training at the hands...
2011-02-08
542 reads
T-SQL Tuesday #15 – Automation
It’s that time of the month again, and this month Pat Wright and his SQL Asylum are hosting the T-SQL...
2011-02-08
1,021 reads
February OPASS Meeting
Don’t forget to join us tonight for the OPASS meeting sponsored by RedGate and Signature Consultants.
Event Date/Time: Tuesday February 8th...
2011-02-08
8 reads
TSQL Tuesday #15–Automation in SQL Server
Automation is the separation point for the professional DBA from the amateur. That makes this a very important topic. Thanks...
2011-02-08
911 reads
T-SQL Tuesday #15 Automation and the SSIS Dumper
This post is my contribution to T-SQL Tuesday, hosted this month by Pat Wright (blog | twitter).
In my previous post...
2011-02-08
1,066 reads
February OPASS Meeting
Don’t forget to join us tonight for the OPASS meeting sponsored by RedGate and Signature Consultants.
Event Date/Time:Tuesday February 8th @ 6:00...
2011-02-08
829 reads
What's OLD in SQL Server 11 aka Denali? - Deprecated Feature List
Well, we always see, hear, and read about the list of NEW features in the myriad of articles, columns and blogs...
2011-02-08
1,746 reads
SQL University: SQL Server Security Architecture - 3rd Party, No Options
Welcome back to day 2 of Security Week for this semester of SQL University. If you missed yesterday's introduction, you'll...
2011-02-08
2,482 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