Miss 24 Hours of PASS ? No problem, all videos are online

All the videos for the sessions at 24 Hours of PASS are available for free.  Check the session schedule for...

Replacing a SQL Cursor with SSIS

On a forum post recently the questions was asked how to replace a cursor with an SSIS package. This can...

SQLSaturday #85 - Orlando, Florida - September 24, 2011

Fortunately, SQLSaturday#85 stands in a class by itself - it's the only SQLSaturday scheduled this upcoming weekend in sunny Orlando, Florida.
Home...

Analytic Functions – PERCENTILE_CONT / PERCENTILE_DISC

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

Analytic Functions in SQL...

SQL Server Execution Plans

I writequitefrequently about SQL ServerExecution Plans. I started in that area just because that’s how you figure out what a...

MVP Deep Dives 2 – Pre-Order

 
Every couple days, I’ve been checking for it and finally tonight I saw that the upcoming edition of SQL Server...

MVP Deep Dives 2… Pre-Order

Every couple days, I’ve been checking for it and finally tonight I saw that the upcoming edition of SQL Server...

SSRS – Dealing with truncating spaces

I apologize ahead of time on this post today because it will require lots of pre explanation and screenshots to...

Rows or Range, What’s the difference ?

With the release of Denali CTP3 came an extension of the over clause to allow for a sliding window of...

SQL Server DBA Quiz on BeyondRelational

Friend of my mine and fellow MVP Jecob Sebastian is running SQL Server DBA Quiz 2011 on his community web...