If you restored the database to a DIFFERENT server:  After the restore, you will need to synchronize the logins/users data.  To do this, login to the...

At minimum, the user that starts SQL Server needs local admin rights on the machine that is running SQL Server.  Note:  It is not necessary to have domain admin rights, just...

Yes, I find that it is very good practice to name tables that have similiar functions together so that they are sorted together.  It's a great visual tool when you want...

I assume that you mean setting up user/perms for the Access database.  Here are the steps:

1) Logged in as Admin, choose Tools -> Security -> Workgroup Administrator.

2) On the...

If you are just talking about making two seperate logical partitions, I don't think it will make a difference since in the end - the two logical drives are on...

You can backup a SQL database while it is in use.   For best results and to check how much of a performance degradation you see, you probably want to try...

Although I know that it is becoming a mortal sin to do a SELECT on sys tables ... Is this what you are...

Why don't you use the "Generate Script" feature in EM to create a script that drops/creates all indexes?

I leave them on our development server since it gives something for our developers to play around in.  However, I have dumped them from our production database server.

If your budget allows, you might want to consider purchasing something like RedGate's SQLCompare (they have a 14 day trial for download on their website).  It will allow you to...

This was a great article that was chock full of good advice!

Another idea for an article:  Best techniques for a CV/Resume.   I always struggle with (1)  How many pages should...

As Steven pointed out, after the restore it is important to run the following command to set the compatibility mode to SQL Server 2005:

sp_dbcmptlevel 'DBNAME', 90

replace DBNAME with the name...

Install 2000 first, then 2005.

I haven't used the "tablediff utility" in SQL 2005. However, I do have to compare the data in tables quite often.  I have found Red Gate's SQL Data Compare to...

You will be happy to know that SQL Server 2005 was released on 11/7/2005.