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

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

8 Weeks In

I’m about eight weeks into my current project and while I’m certain I don’t know it all, I’m finally at...

Analytic Functions – LAG / LEAD

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

Analytic Functions in SQL...

Analytic Functions – Overview

?This post is the first post in a series discussing the new Analytic functions in SQL Server “Denali”, CTP3, and...

Powershell , Excel charts and data presentation

The topic for T-SQL Tuesday is Data Presentation. Powershell to Excel is a a good way to presenting data, and...

SQL Saturday in Kalamazoo This Weekend

If you are going to be in Kalamazoo this weekend and don’t have anything planned.  Because, yeah, that happens.  Or...

SQL Server Quiz – the last time a stored procedure was executed

A developer rushes up to you and asks "can you tell me the last time this stored procedure was executed?"....

T-SQL Function: EOMONTH

We have all been in a situation where we had to get the last day of the month with T-SQL....