Indexing Strategy

What do I care about when I’m playing with indexes? That’s easy. I want as few indexes as possible efficiently referenced...

Thank You for More Than You Realize

Blogging and presenting have changed me for the better, and in ways I didn’t see coming.  However, I know I wouldn’t have had them if it wasn’t for three things.  Getting...

Thank You for More Than You Realize

Blogging and presenting have changed me for the better, and in ways I didn’t see coming.  However, I know I wouldn’t...

What does that N in nvarchar really mean?

In any study of Data Types in SQL Server you are going to have to look at the various string...

What is an execution plan? When would you use it? How would you view the execution plan?

An execution plan is basically a road map that graphically or textually shows the data retrieval methods chosen by the...

When Should You Use Identity as a Clustered Index Key?

A few days ago, while delivering my session, The Data-Loading Performance Presentation, I was asked when, performance-wise, Identity should be...

Presentations & Blogging of 2015 in Review

Another year is coming to an end and I am doing a review of which goals I have managed to...

Top 10 Enhancements to Azure SQL Database in 2015

Top 10 Enhancements to Azure SQL Database in 2015
DECEMBER 27, 2015

Introduction2015 has been a massive year for Azure SQL Database. This year has seen the product mature from "an...

Top 10 Enhancements to Azure SQL Database in 2015

Top 10 Enhancements to Azure SQL Database in 2015DECEMBER 27, 2015
Introduction
2015 has been a massive year for Azure SQL Database....

Type 6 or Hybrid Type 2 Slowly Changing Dimension with Biml

In my previous post, I provided the design pattern and Biml for a pure Type 2 Slowly Changing Dimension (SCD). When...