Analytic Functions – FIRST_VALUE / LAST_VALUE

This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.

Analytic Functions in SQL...

SELECT COUNT(*) vs COUNT(1) vs COUNT(ColumnName)

What is the difference between COUNT(*), COUNT(1) and COUNT(ColumnName)? A mystery that will never be known… ok that was a...

How pure is your data?

It was a normal Monday. I was going over some HA designs and planning the joys of setting up log...

Normalize your Linked Server Names

This is a technique I’m sure many people are already using in their environments.  Instead of using the actual name...

What Happens in Vegas…

…Need not Stay in Vegas Coming to Las Vegas in 2012 is an event many have been waiting for.  Those that have been waiting for this event are the...

What Happens in Vegas…

…Need not Stay in Vegas
Coming to Las Vegas in 2012 is an event many have been waiting for.  Those that...

SQL Server 2012 (“Denali”): Installing on a Virtual Machine

With CTP3 for SQL Server 2012 (code name of “Denali”) available, a lot of us want to play with all the new...

SQL Server “Denali”: Installing on a Virtual Machine

With CTP3 for SQL Server Denali available, a lot of us want to play with all the new cool features, as well as...

I Don’t Know

I wanted to write this because lately I say “I don’t know” a couple times a day to my client/boss....

ColoradoSQL in September

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...