Just a guess, but when I used the configuration wizard, it stored the Oracle password as "******" instead of the actual value. When I edited that to an actual password...

Despite having had the ability to cascade delete for years, I haven't set it up, not one single time. It is too scary and completely out of control. At the...

Cascading deletes are a different requirement than that if a parent is deleted, so must the children. The question is one of automated actions vs. intentional actions. With DRI in...

There's a nice little task that was created for just this purpose at SQLIS.com (http://www.sqlis.com/default.aspx?23). I've used, not in production yet, and it works very well.

There are also some decent little samples out at SQLIS.com

Not an Integration Services question, but... You get a new error log each time SQL Server is restarted. However, in order to keep the size of the logs smaller, you...

I'd report this one to Microsoft.

I tried, but I can't replicate the behavior. Any other clues?

And so, your code is flawless, always. And the next guy who writes some code against your system, he too doesn't need data integrity checks because his code is perfect....

This is a pretty amazing thread. What I haven't heard anyone mention or emphasize are the business requirements that the data is modeling. Surely the database design has to meet...

I sure can't tell you how to measure quality. We do try to add quality as a requirement in the code we right. We're following the test driven development methodology...

Well written article, but a couple of points.

It doesn't really get into Best Practices much at all. With the exception of some SQL 2000 best practices that will prevent...

When I see words like "heavily indexed" red flags go up. How heavily indexed, and are all those indexes being used (selectivity needs to be as high as possible in...

Nice article.

On the topic of looking to see if they have a blog. I've developed the habit of doing a google search on people's names we're thinking of hiring, even consultants....

What? No one is posting scores?

Assuming either full positive, full  negative or zero, I got an 82.

Fun article. Thanks for putting it up.

As to those who don't like the developers...

Nice to see someone else including Keynes, since his economic models practically ran the planet for 50 years. I'm just surprised you didn't include his polar opposite Hayek, whose theories,...