Daily Coping 24 Aug 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-08-24
25 reads
Blog Posts
Don’t Forget Unique with FILESTREAM–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. While testing FILSTREAM with SQL Clone the other...
2020-08-24
22 reads
2020-08-24
14 reads
2020-08-24
20 reads
Multi-Subnet AlwaysOn - Scripts & Downloads - Part 3
Let’s see how to get access to scripts for this tutorial series
2020-08-24
32 reads
New Pluralsight Course – Configuring and Managing Kubernetes Security
My new course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to Pluralsight! This course...
2020-08-24
26 reads
New Pluralsight Course – Configuring and Managing Kubernetes Security
My new course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to Pluralsight! ...
2020-08-24
15 reads
New Pluralsight Course – Configuring and Managing Kubernetes Security
My new course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to Pluralsight! This course...
2020-08-24
30 reads
Persist Sample Percent in SQL Server IS NOT PERSISTED!
Update: Sept 14, 2021 Persist sample percent is fixed. The fix is now rolled into SQL 2016 SP2 CU17, SQL 2019 CU10, and the future SQL 2017 CU26. When a bug...
2020-08-24
36 reads
Unconscious Bias
This article helps to unearth a cultural issue that each individual needs to address on a personal level. Bias is an enemy to productive conversation.
Related Posts:
Note to Self June...
2020-08-24 (first published: 2020-08-11)
442 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