Moved blog to Ghost
Another year, another blog update lol!… Last year I remember doing a significant version upgrade for my self-hosted Orchard CMS software on the DiscountASP hosting platform and it all...
2017-04-12
30 reads
Moved blog to Ghost
Another year, another blog update lol!... Last year I remember doing a significant version upgrade for my self-hosted Orchard CMS...
2017-04-12
260 reads
Getting intimate with Brent Ozar (The First Responder Kit)
Imagine this scenario, you are a database professional at your place of business and you look after a mountain of SQL...
2017-04-12
521 reads
T-SQL Tuesday #089: The Cloud and Job Security
Do you fear the coming turbulence of the Cloud uprising? I think the cloud is a good thing for the data professional, when done right.
Related Posts:
Coping with Self...
2017-04-12
9 reads
T-SQL Tuesday #089: The Cloud and Job Security
The Cloud
Today I am doing a quick entry for my participation points in the monthly blog party called TSQL Tuesday. I...
2017-04-12
606 reads
T-SQL Tuesday: Finding issues with your query plan
This is my first time blogging with a T-SQL Tuesday topic. If you follow my blog you’ve probably noticed that...
2017-04-11
495 reads
Avoiding Cloud Lock In – T-SQL Tuesday
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-04-11
622 reads
Why Volunteer at SQLBits ?
WARNING – Contains Orange and light-hearted photos
I have returned home from SQLBits 2017 The Disco Edition. I am exhausted, my...
2017-04-11
555 reads
I Like to Move It, Move It – But Azure Data Factory Doesn’t
I’ve spent the last couple of months working on a project that includes Azure Data Factory and Azure Data Warehouse. ADF...
2017-04-11
611 reads
Power BI and Data Security – Sharing Data
As Power BI becomes more prevalent in data analytics and visualization within the enterprise, data security becomes a significant concern....
2017-04-11
961 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