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....

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...

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...

Looking Back at Build–CosmosDB

Part of a series looking back at Build 2017, going over the 20+ pages of notes I took.
One of the...

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...

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...

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...

Understanding Keys and Certificates with Always Encrypted

Always Encrypted on SQL 2016 is pretty easy to set up. There’s even a single wizard to guide you through...