PASS Summit 2017 is Coming

The yearly PASS Summit is just around the corner, a little less than six weeks away. For those not familiar...

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

SQL Server: The danger of large data types

Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data...

Uniquifier is a rather unique word isn’t it?

tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique.
Uniquifier is a rather funny name,...

Database Fundamentals #11: Why Learn T-SQL

If you’ve been following along with the previous 10 Database Fundamentals blog posts, you have a SQL Server installed and...

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

Running for the PASS Board of Directors #PASSelections

This year I decided to take “someday” to heart and do something that has been on my mind for awhile...

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

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

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