Upcoming October Events

During October I’ll be presenting at several online and in-person events
LocationDateSessionSQL Saturday #49 Orlando 2010Oct 16th ETL with PowerShellPASS PowerShell...

Return of Index Analysis Part 2

Let’s Anaylze An Index!Time for part two of my continued Index Analysis query.  The previous posts in this series are:
Analyze...

Speaking Ideas - Plan to End

Over the years I’ve seen probably hundreds of technical presentations. I’ve seen good ones, bad ones, on all sorts of...

Closing Fast – SQLSaturday #49 – Orlando

Well, the event is closing in fast, less than 2 weeks away!  We have over 300 registered, a great schedule,...

An Organizer's Recap of SQL Saturday #48 - Columbia, SC

This past Saturday, October 2nd, we hosted Columbia, SC's first ever SQL Saturday. By the feedback we've received, both during...

A Surprising Result from Ident_Current

If you haven’t used it (and I rarely do myself), Ident_Current (‘tablename’) returns the last identity value generated across all...

5-Weeks to PASS Summit 2010 Countdown

With 5-weeks until the PASS Summit it’s time to start getting ready for the event.  As I’ve discussed a couple...

Determine if Directory Exists using xp_cmdshell

Recently, I came across a forum post from a user trying to determine if a directory existed in the file...

PASSMN Board of Directors Nominations

It’s that time of the year again.  Time to get in some nominations for the 2011 PASSMN Board of Directors. ...

Tip: OVER and PARTITION BY

Here’s a quick summary of OVER and PARTITION BY (new in SQL 2005), for the uninitiated or forgetful…

OVER
OVER allows you...