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

SSIS Variables and Expressions Webinar Recording

Thank you to everyone who attended my free webinar hosted by Pragmatic Works yesterday (September 20, 2011) on SSIS Variables...

MicroTraining: Performance Tuning Checklist

I’ve been playing a lot with Google+ and the Hangouts there. I love them. I think they’re opening up a...