Dataset for Cochran-Mantel-Hanzel Test

Below is the script to create the table and dataset I used. This is just test data and not copied...

What’s an “Index” and how do they work?

What is an Index?
We often hear indexes explained using the analogy of an index in the back of a book....

GroupBy Conference – SQL Server & Containers

Morning all, busy week last week as I was lucky enough to have my session on SQL Server & Containers in...

Windows Azure random FAQs

1. What are IaaS, PaaS and SaaS?
Basically these are cloud service models for cloud offerings. These are categorized on the...

SQL Server 2017 – DMF – sys.dm_db_log_info

The release of Microsoft SQL Server 2017 brought a lot of very interesting new features. One of them is the...

Don't Forget the Network

A few weeks ago I was looking at a query and got tripped up by the network and my own forgetfulness. It was a pretty simple query with a...

Redis cache implementation using C#

Redis cache implementation using C#

Access to SQL Server is finally coming

Imagine a world where one of the software giants releases their brand new operating system and a new application architecture...

Friday Reading 2017-06-09

Exciting day today as I’m presenting my first webinar on SQL Server & Containers in the GroupBy June conference! There’s a...

SQL Azure Databases - Active Secondary - Failover - Part 3

Continuing on the series on SQL Azure Databases - Active Secondary, this post will explore the task of failing over to secondary.

Fairly straightforward task, just one needs to take...