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

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 Tuesday #22 - Data Presentation - My Example with CTE

Hey, everybody!  Welcome to T-SQL Tuesday #22!  Today's topic is Data Presentation, and the importance of formatting data to the...

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

September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals

September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
Subject:Architecture Career Paths for SQL Server ProfessionalsLevel:200 (Intermediate)Start...

How to prevent blocking in your SQL Server database

As a SQL Server DBA, usually the largest databases in size and in number of users that I had to manage was an ERP...