SQLSaturday – Its a Mad Mad World

I just got back from SQL Saturday in Richmond this past weekend (Thanks for the great event guys!) and on the way home this got stuck in my head. To learn more about SQL Saturdays visit the official website, join PASS, and register for one near you. You won’t regret it!

Optimizing Protected Indexes (was Indexing Encrypted Data)

Why bother encrypting? As a SQL Server DBA I am primarily responsible for making sure my client’s data is protected and available amongst other things. In many cases I have gone to clients and projects to find that sensitive data is not protected as well as it could be. Most times development is still underway and the security is a …

SQL Server version table

** Updated on 10/13/2014 with latest SQL Server 2014 release information ** To ensure my clients and I are running on the proper version of SQL Server I have created a reference table that contains all the SQL Server versions since 7.0. The script to create the table is too large to include here, but I have added an option …

Type 2 SCD with SQL Merge

Checklist

I was going through some notes I had from previous projects and came across a sample script for created a Type 2 Slow Changing Dimension (SCD) in a database or data warehouse. A Type 2 SCD is one where new records are added, but old ones are marked as archived and then a new row with the change is inserted. …