SQL Server 2011 “Denali”: Four new useful DMV

SQL Server 2011 “Denali” CTP3 introduced couple of new Dynamic Management Views (DMV). However, documentation says that some of them...

Speaking at SQL Saturday 89

With a late cancellation with one of our speakers a hole was opened on our speaker lineup.  I reached out...

SQL Saturday #92 Lunch: Bend Area Gathering

There's nothing more I love than free food and SQL Server, no joke.  I take my free food and SQL...

T-SQL Tuesday #22 – Data Presentation

Data Presentation is not just about the look of a report.  Data Presentation involves performance, accuracy, display and the business requirements.  By giving proper attention to each of these...

T-SQL Tuesday #22 – Data Presentation

Tuesday is upon us.  It also happens to be the second Tuesday of the month and you know what that...

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

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

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