Yes, Foreign Keys Help Performance

I created this example several years ago that illustrates how foreign key constraints can help performance. It’s a contrived example....

Zombie AD Groups

I spent something like 2 hours today trying to figure out how a particular user had access to one of...

Clustered Index and related Interview Questions

Since the day I wrote my first blog. My friends are eagerly waiting for just one topic. The Indexing. I...

Clustered Index and related Interview Questions

Since the day I wrote my first blog. My friends are eagerly waiting for just one topic. The Indexing. I...

Free SQL Azure eBook

As this blog post is being published David will be delivering his “Putting his Head in the Cloud – Working with...

5 Enhancements to SQL Runbooks in the Azure Preview Portal

5 Enhancements to SQL Runbooks in the Azure Preview Portal
SEPTEMBER 18, 2015

IntroductionRunbooks are your SQL Server Agent for Azure SQL Database. Lately, Microsoft have been making quite a few...

5 Enhancements to SQL Runbooks in the Azure Preview Portal

5 Enhancements to SQL Runbooks in the Azure Preview PortalSEPTEMBER 18, 2015
Introduction
Runbooks are your SQL Server Agent for Azure SQL...

Custom Column in SQL Data Generator

One of the interesting things with Redgate’s SQL Data Generator (SDG) is that it allows the user of custom data...

Map Data Types in Extended Events

Maps are like a way of overloading the data type to expose more meaningful values that relate to the payload data in question. The standard data types can also...

Map Data Types in Extended Events

In the last segment, I wrote about the data types for the payload of an event in Extended Events. In that...