Detach all the db's and see who/what complains! 😀

I was going to suggest profiler, but Steve beat me to it.

Also, if you can look through the databases and tables, you...

MySQL is a seperate process all together. For this, you'll need to create use SSIS to move the data between MySQL and SQL Server.

I didn't actually look for any about the actual changes made to 2000 databases. I found out the hard way - luckily on a test box!

To be safe, I'd...

You can house the 2000 databases in 2005, no problem. Just not the other way around.

Also, once you restore/attach the 2000 database in 2005, the internals of the database...

Nice write up. I started at a new place a few months back and yeah, that is a good start point of things to get to understand in the...

One of the simplest bits of advice I could give to anyone going for an interview.

If you don't know the answer to a question, tell the interviewer. There is...

I know that feeling all too well. Infra and Dev can be worlds apart in some aspects. At a previous company, I suppose I was lucky that I...

The answer is "it depends".

I've worked in companies where I have had full domain admin permissions and could do whatever I wanted. I've also worked in environments where my...

I agree with Jo. You do need to consider the growth patterns of your instance in relation to differing performance counters.

As well as disk queue length and CPU, I'd...

You're correct.

If you use UPDATE STATISTICS WITH FULLSCAN ALL you will update all statistics (column & index) for that particular table. Every row will be used for...

You can take transaction log backups as frequently as you want. Every minute if you really want to.

But, not knowing your system, you have to strike the balance between...

SQL replication was my first choice and I had replication all working but it was also required to see if there was any 3rd party alternatives out there.

That said, the...

Oh, and as a fresher - I assume you mean just out of college or university?

If I was looking to hire someone just out of university, I'd want to get...

Tough question 🙂

Taking classes in SQL Server really only teaches you the fundamentals of administration and design. And yes, you could jump straight from these classes into a job.

That...

Yes, you can. I can't recall the software a previous company used, but its perfectly possibly to do this.

Personally, I was never quite comfortable with ghosting. I guess...