Personally, I don't really like 3rd party addons too much. The only ones I have used a lot is LiteSpeed and SQLCompare.

I've never been too interested in all of...

When I first saw this question, I thought Steve was going to throw a spanner in the works and say Oracle or MySQL 😀

You may also want to backup all other databases on the box aswell.....just in case :unsure:

Never actually uninstalled an instance before, but I would imagine that when you uninstall, you will be asked which Instance it is that you want to remove.

Also, as obvious as...

You can't make a step a SQL Job.

What Zaheer is saying is to rather than have 2 scheduled jobs, create one job and have two steps so you go from...

Ahhh yes, the good old days when I thought 1) Access was powerfull and 2) I knew database design! :hehe:

Hey Brandie,

I realised after I sent the post that "real world experience" was not want I meant - it was purely meant that you had no experience of being a...

Check out the microsoft sites for the content. Also check Amazon for the study guides.

Also, I disagree that you need certification...Its a nice to have and yes, I agree,...

Nice - Must admit, I've only been using 2005 in anger for 3 months, so I didn't look for any new certifications.

Suppose I should do it. Maybe I should...

MCITP?!! I didn't even realise MS had introduced a new cert!

Cheers

I'd just take the route of isolating tempdb onto seperate spindles. Maybe even split tempdb into multiple data files and place those on seperate spindles too.

All of London is expensive to live in. Even the places I'd not advise you to live are expensive. To be honest, if you live inside the M25...

Nice article. I have a few friends who are interested in IT and would like to try and get into it. I'll pass this article on.

As for the...

Hey,

In short, there is no compatibility issue with restoring an enterprise database to standard.

What you lack, as Ahmed pointed out is a lot of functionality. So you just need...

When you say you can't do bulk insert nightly, is this because you need to keep their test box us up to date as possible?

Replication?

Log shipping?

Two good methods which are...