Why does my SSIS package run slower in BIDS than DTEXEC?

If you have been creating SSIS packages in Business Intelligence Development Studio (BIDS) for any length of time, you have...

My Playbook For Putting On a SQLSaturday Part 2: Venue

Finding Your Venue
Sounds simple right?
It can be one of the most difficult things to do for something the size of...

SQL University: Advanced Indexing – Filtered Indexes

Welcome back to day 2 of Advanced Indexing. Today we’re going to look at a feature that was added in...

Physical Servers What are They?

Today I'm in the process of installing some physical servers.  To put this into perspective due to the companies I...

Book Review: Moneyball

With the movie coming out I realized somehow I’d missed reading Moneyball by Michael Lewis. It’s the story of how...

SQL Inspiration 3-days away! Last Chance! Registration CLOSING TODAY!!

Happy, Wednesday folks!  We're 3-days away from SQLInspiration, and that is the event we've been reading about for some months...

T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs

T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs

This blog entry is participating in T-SQL Tuesday #024, hosted...

SQL Saturday #99 Minnesota on Friday 11/11/11

SQL Saturday 99 on Friday is upon us.  I look forward to seeing you at the event.  For details check...

PASS Board Of Directors Interview

I had my telephone interview for the PASS Board of Directors this afternoon and I'm cautiously optimistic that I did...

T-SQL Tuesday #024: Prox ‘n’ Funx

Functions are very handy.  They can also prove to be the cause of poor performance (such as was the case with that string splitter).  When used appropriately, you can...