Great article. Thanks for all the work. While I was aware that avoiding implicit converts resulted in better query plans, I didn't know about the data precedence. That's a great...

All darn good reasons to switch to 2005, but none of them really offer actual productivity gains (maybe the templates, but that's pretty slight). Thanks for the feedback.

That's very much in keeping with my experiences and research, but I was hoping I'd missed something. I've got two reasons for switching over, one good, one not so. The...

You are the #1 resource on this stuff. I send anyone who'll listen over to your web site.

It's an add-on to Visual Studio. It's specifically targeted at database development. It manages all your database objects locally through scripts that can be checked into source control. It has...

I have to agree. The database development team that I belong to has been trying to work out these kinds of methods, but the nature of databases and the dirth...

Woo Hoo! Scott Ambler!

Thanks for the response. I've read both your database books (Agile Database Techniques & Refactoring Databases) and have forced a few people in the organization to read the first one...

Hello,

Sorry I didn't get back to you sooner, but I didn't get any alerts that there were posts on this article. I thought no one was reading it.

Several of us...

Absolutely helpful. Those are some really important details that I didn't include in the article.

Funny thing about writing this kind of article, you keep thinking of other details that should...

While I do understand and agree that of course an OLAP db will have a date table, we are missing the point here. This is clearly a transactional system and...

Not that the data needs are huge, but Tennis has pretty extensive database needs. About 9 years ago I helped build the USTA database which they distribute around the country...

Thanks for sharing this one. We're trying to institute a number of security policies on laptops within our organization and we've been meeting resistance, especially from development. Having stories like...

It's on the Properties tab of the OLE DB Source in Custom Properties section.

We found that loading data to Oracle from SSIS only worked well when we used the...

Second question first. How did Oracle process the query correctly? I haven't a clue. It's optimizer must work in a different way, logically, than SQL Servers. As to the first quest,...

Hmmm... Interesting.

A couple of problems though. I wanted to get a list of values that exist in one table and not the other. I also tried running it with the...