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 PortalSEPTEMBER 18, 2015
Introduction
Runbooks are your SQL Server Agent for Azure SQL...

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

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

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

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

SQL Saturday San Diego tomorrow! (September 18)

This weekend we’re going to hit SQL Saturday San Diego for the first time ever! We are the excited. Come and...

SQL Server 2014: parallel execution of SELECT INTO statements

In Microsoft SQL Server 2014 new in-memory options are presented. One of them is online transaction processing (OLTP) that complementing...