Daily Coping 14 Jul 2020
I’ve 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-07-14
13 reads
Blog Posts
Disappearing Data Files
This article has just shared the power of XEvents and yet another use in helping to audit the database environment for changes. Not only do we have this powerful...
2020-07-14
19 reads
Ethics in Modern Data at the Houston SQL Server and BI User Groups, July 2020
On July 14, Christine and I presented at the Houston SQL Server and BI User Groups' virtual meeting. Our joint presentation is one of our favorites to present, Ethics in Modern Data.
Thanks...
2020-07-14
8 reads
Full Architecture for SQL Backup to Blob Storage in Cloud
One of the tasks that any DBA should know How to take backup to URL or restore a backup from URL and this’s the easiest part very simple steps...
2020-07-14
15 reads
2020-07-14
14 reads
2020-07-14
16 reads
Laptop to Build Hyper-V Test Lab - Part 1
This is the first Video of the series, will show you how to configure Hyper-V and then create several VM’s to configure AlwaysOn
2020-07-14
27 reads
More ADLS Gen2 enhancements
On the heels of More Azure Blob Storage enhancements come more enhancements for Azure Data Lake Store Gen2 (ADLS Gen2): Archive tier is now GA: The archive tier provides...
2020-07-14 (first published: 2020-07-06)
270 reads
Recovery Unit InitPersistentVersionStore Failed
As usual, I was working on my weekend on-call and I have had an alert. Our monitoring system has reported a message printed from the error log. I was...
2020-07-14
48 reads
sp_Blitz for All Servers
Are you a Microsoft SQL Server DBA managing one or more servers? Then you should know about the First Responder Kit from Brent Ozar Unlimited. This is a free...
2020-07-14
347 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