SQL in the City US tour begins tomorrow #sqlcity

 
 
 
 
The Red Gate SQL in the City US tour begins tomorrow in New York City. If you have not registered...

Nested Partitioned Views

A few weeks ago I had a customer engagement, where the customer wanted to implement Nested Partitioned Views. Before we...

Nested Partitioned Views

A few weeks ago I had a customer engagement, where the customer wanted to implement
Nested Partitioned Views. Before we go...

SQL Server 2012 AlwaysOn now officially supported by VMware

I read yesterday that VMware has updated the “Microsoft Clustering on VMware vSphere: Guidelines for Supported Configurations” KB article linked...

An Introduction to SQL Server

There are still seats left on the Learning Tree course – An Introduction to SQL Server event that I will be...

No more NebraSQL

After having too many people ask me what NebraSQL meant (its a play on words - Nebraska+SQL - get it?)  I have...

How BETWEEN is inclusive

This is a old and simple one, but an important subtlety that TSQL developers must be aware of.

Using the BETWEEN...

OVER() clause two simple ways on two different days

I’ve been aware of this clause in TSQL for a long time, but I’ve never really used it. Mainly because...

SQL Server: Part 4 : Approaching Database Server Performance Issue

In the last three parts, we have discussed about different queries that can be used to list the current state...

DBMail on a cluster

I’ve always found clusters a pain in the neck.  For my latest pain I just spent the last 2 days...