T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting this month. This month we are building a Time Capsule. I decided to make mine...
2020-08-11
6 reads
Blog Posts
T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting this month. This month we are building a Time Capsule. I decided to make mine...
2020-08-11
6 reads
T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting this month. This month we are building a Time Capsule. I decided to make mine...
2020-08-11
11 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-11
17 reads
What goes around comes around : T-SQL Tuesday #129
I almost died. I’m sure a lot of you already know this but just to be clear, I should have. ... Continue reading
2020-08-11
33 reads
Why a 60GB Database Backup Grew to 1TB in Size
Recently, I was alerted to a network file share that was running low on disk space. This interesting as there was only one process that used this particular location...
2020-08-11
3,963 reads
Azure SQL Database – Maxdop Updated
About 1.5 years I wrote about MAXDOP setting within Azure SQL DB, more specifically the fact that the default setting being 0. (https://blobeater.blog/2018/09/12/maxdop-and-azure-sql-db/) Now, you should be aware that...
2020-08-10
299 reads
Daily Coping 10 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-10
25 reads
Fixing Broken Pip
I’ve got Python 3.8 on my machine, and recently I got a note that my pip version was old. I tried to upgrade PIP recently with this command: c:python38python.exe...
2020-08-10
480 reads
How to Iterate Through A List of Objects with Terraform's for_each function
What I want to do
# create file local.users.yml
user:
- name: foobar1
email: foobar1@foobar.com
- name: foobar2
email: foobar2@foobar.com
- name: foobar3
email: foobar3@foobar.com
locals {
users_file = "local.users.yml"
users_file_content =...
2020-08-10 (first published: 2020-07-29)
6,264 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