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...

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...

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...

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...

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....

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...

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...

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...

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...

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...