I wish there was a definitive answer here to the question "user file or dbproj file?". I use DBPro A LOT but I don't use configurations...after reading this article I'm...

Good article Grant, I have one question though.

You say "you have to browse to the .user file and add it to your project and check it into source control"

I was...

No argument there. But its your setup.

2 options.

1. Set BIDS to 'Work Offline' (its on the SSIS menu)

2. Set up your package to use...

It seems...

tinyint, smallint, int, bigint

smalldatetime, datetime, bigdatetime

The simplicity of your suggestion is so elegant it hurts.

Silly...

Good summary. I still want to know what happens if I request the number of nanoseconds between Year 0001 and 9999 using datediff. Cos as far as I know datediff...

Thanks all for the comments thus far. Certainly nothing there that I can (or would) disagree with.

Dave, I have an article here that discusses one possible use of event handlers:...

aw shucks. Thanks Ed! 

SSIS isn't a comprehensive ETL tool? You've got to be kidding right? I'm curious, what is it missing that means it isn't an ETL tool? SSIS is far far superior...

Hi Mike,

Great post. Its good to have some real-world experiences on here. It kind of confirms what I was already thinking as well.

Do you have any stats about this "dramatic...

Phil Factor? You're kidding right?

If you are, its too subtle for me!!

Is it a good idea to say on a public forum (owned by your employers) that you don't want to go and meet them?

"I'm still convinced that a Doom-like first person viewpoint technology could make it easier to browse databases at some point in the future."

Personally I can't wait until an online store offers...

Agreed. I'd like to see lots of comments from conference attendees coming out this week.

-Jamie

Hiya Steve,

I know you're not a fan of Analysis Services and that's absolutely fine - in a lot of ways I'm right there with you. What irks me is that...