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

Replication DDL Triggers

Because this was a problem that Google was zero help on and I did find a couple other people afflicted...