PASS 2012 NomCom
I’m officially on the slate and running for the PASS 2012 Nomination Committee!
I love the SQL Community and everything it embodies. ...
2012-06-13
671 reads
PASS Nomination Committee
For some reason, which isn’t completely clear to me, we’re voting for part of the members of the Nomination Committee...
2012-06-13
814 reads
Guest Post – The Last Starfighter
Today I am delighted to be able to share with you a guest post from one of my all time...
2012-06-13
1,218 reads
@LearningTree: 2108 SQL Server 2012 Database Administration
This past week my international adventures have continued. As some of you know, for the past couple of years, I...
2012-06-13
1,543 reads
Command Line Prompts for Checking Active Directory Membership
Using Active Directory groups are a great way to manage and maintain security for a solution. Think about if you...
2012-06-13
1,908 reads
T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore
T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore
This blog entry is participating in T-SQL Tuesday #31, hosted this month...
2012-06-12
1,910 reads
SQL Server 2005 Diagnostic Information Queries (June 2012)
Here is the latest version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements, including...
2012-06-12
1,149 reads
T-SQL Tuesday #31 – Logging
This month’s T-SQL Tuesday is hosted by Aaron Nelson (@SQLvariant | Blog). The topic is about logging. Many will talk about...
2012-06-12
1,052 reads
Using PowerPivot to Monitor Reporting Services
PowerPivot is a powerful new tool from Microsoft that has been improved even more in the 2012 release, which you...
2012-06-12
1,539 reads
T-SQL Tuesday #31 – Logging
It’s T-SQL Tuesday time again, and this month Aaron Nelson (blog | @sqlvariant) is hosting. The topic is logging, and if...
2012-06-12
1,647 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
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...
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