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 Cruise day 2 – First sessions
Learning the ropes SQL Cruise day 2 started earlier than I wanted, I believe the old naval term was ‘at sparrow’s fart‘.
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
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. …
WILTW – Mind the details
This past week has been crazy with getting ready for family arriving and then all of us heading down to Miami for SQL Cruise! I did not make good notes of this week’s lessons, but here are main highlights of what I recall: