Comparing two SQL instances
Last week I was working on a couple of SQL instances that contained databases which were part of an Always...
2018-01-10
494 reads
Summiting that Technical Challenge
The challenge at hand - conquering that technical problem and getting that high associated with the metaphorical high of summiting a tough task.
Related Posts:
Summiting that Technical Challenge Part II...
2018-01-10
6 reads
Summiting that Technical Challenge
Conquering Challenges
I really like the topic of the TSQLTuesday party today. Today we have been instructed in no uncertain terms...
2018-01-19 (first published: 2018-01-10)
1,082 reads
salt Release 1.1.2562 – With Bug Fix!
Hello!
Very recently a user of salt got in touch with me about a bug when setting the job schedules up...
2018-01-09
253 reads
SQL Server on TLS 1.2: XEvent session to catch TLS in use
How can you tell what version of TLS is currently used for client connections? Unfortunately there isn't a handy queryable column...
2018-01-09
2,486 reads
SQL Server on TLS 1.2: Checklist to disabling TLS 1.1 and 1.0
A common finding in security audits these days is the failure to conduct all communications via TLS 1.2. (Correspondingly, a...
2018-01-16 (first published: 2018-01-09)
31,395 reads
How to fix the database consistency and integrity issues using DBCC CHECKDB and Third Party Tool
Overview
The database protection and recovery is a vital role of database administrators. While working on SQL Server, sometimes users get...
2018-01-09
1,481 reads
Multi-Server Queries (Day 9)
Have you ever had to run a query on multiple servers? You could connect to each server one by one...
2018-01-09
455 reads
T-SQL Tuesday #098–Technical Challenges
It’s the first T-SQL Tuesday of 2018, being brought to you by Arun Sirpal. His invitation this month asks for...
2018-01-09
1,277 reads
T-SQL Tuesday #98 – Take Small Bites!
https://media.makeameme.org/created/mega-bytes-well.jpgIt's T-SQL Tuesday time again - the monthly blog party was started by Adam Machanic (blog/@AdamMachanic) and each month someone different...
2018-01-09
550 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