In addition to Security (and the auditing available with DDL triggers), the main reasons I would add are SSIS, Solution Explorer, Database Mirroring and Snapshots.

DM & Snapshots are wonderful...

Are you working in 2000 or 2005?

You posted to the 2k5 forum, but EM is a 2000 tool and in 2k5 you not supposed to be able to...

First, go into your SQL Server Configuration Manager and verify that NONE of your services are running under the Built-In Administrators account. It doesn't have to be the SQL...

All, I'm glad my article is generating such positive responses. For those currently going a similar Non-IT to DBA route, I hope my experiences help you along the way.

Nadeem7971,...

Hey, Jorg, the article Steve pointed out also has info on the 446 exam. You might want to check it out.

You can also use SUM(ISNULL(Quantity,0)) to do something similar. The difference is that ISNULL simply replaces any NULL values with zero instead of looking for the first non-NULL value.

Thanks for the blog, Jorg! I appreciate it!

WANT MORE FEATURES!!!!

Sorry, couldn't resist. @=)

The Scope Creep discussion reminds me of a moment at one job where the developers worked their butts off designing a website solution (tied to...

Glad we could help. @=)

Andy Warren said:

On the contrary, Andy. You definitely rank up there with those two! Your...

Unfortunately, using the LIKE operator always affects query performance. For one, if you use the wildcard on both sides of the search syntax, then you can inadvertantly generate tablescans.

The...

What error are you getting with the Flat File Source?

And what datatype is the column you're importing this data into?

I take it you don't have any previous backups (to the one you're currently using) that might have these 8 tables on it?

There are some disk recovery services that might...

If all else fails, change the order of your tables. @=)

Sometimes with INNER JOIN table order doesn't matter, but I usually go from the table that's likely to have the...

That's a good point, John. Unfortunately, when I was studying for my cert, I didn't know of any local users groups. They don't advertise very well in my...