Restore BACPAC to SQL Azure
Hello!
2 posts in 1 day? When you’re hot, you’re hot!
I’m actually writing this one whilst I’m waiting for a BACPAC...
2017-09-22
364 reads
How To Update Visual Studio 2017
(AKA how I lost a morning)
Hello!
This morning I needed to update my version of SSDT, but before I could do...
2017-09-22
776 reads
SQLpassion Online Training in October 2017
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-09-21
469 reads
Distributed Writes
In SQL Server, scaling out reads (i.e. using Active secondary replicas via AlwaysOn Availability Groups) is a lot easier than scaling out...
2017-09-21
743 reads
Recover Deleted Data from SQL Table Using Transaction Log and LSNs
Introduction
At times a user may perform UPDATE operation or DELETE operation in SQL server database without applying the WHERE condition....
2017-09-28 (first published: 2017-09-21)
4,977 reads
What’s a SQL Compare Snapshot?
I saw a short video from Grant Fritchey on the Redgate channel that shows how to cerate a snapshot in...
2017-09-21
816 reads
Test Database Compatability with dbatools
I really like the dbatools project. This is a set of PowerShell cmdlets that are built by the community and...
2017-09-29 (first published: 2017-09-20)
2,200 reads
Does rebuilding my clustered index also rebuild my non-clustered indexes?
I’ve been working with SQL Server for many years now, and up until recently, I assumed that rebuilding any clustered...
2017-09-20
446 reads
An open letter to the PASS community (2017)
PASS is our community.
It may sound a little cliche, especially with the current political climate in the US and other...
2017-09-20
357 reads
Do what I say, not what I do
I told you not to use NOLOCK even though I use it sometimes.I told you not to shrink databases, even...
2017-09-20
440 reads
Blogs
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
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...
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