Thank you. Math mistake 🙂

Put your resume on Monster.ca or workoplis.com. They will find you. Use your judgement to filter out.

But MS recommends applying service pack. It supposed to be SP5 then. I rememeber (maybe wrong) there is no service pack after SP4.

I strong agree with Charles about internal controls. 

DBA is more than an IT professional considering the nature of DBA's work.  Having technical skills/people skills/business understanding is not enough for being a DBA. ...

Thank you Jwalant.  Another new todo item is added.  Of couse, it should be on the top of my todo list. 

Very good article and have a lot of good suggestions.

I have my own to-do/to-learn list.  I keep adding it up whenever I find any good idea worth a try.  Once I...

Check the job script whether contains source server name, you may have to replace it with the target server name.

There is a fix for Dashboard setup script.  Otherwise, you will get an error message after 24 days.  Check here:

http://blogs.msdn.com/sqlrem/archive/2007/03/07/Performance-Dashboard-Reports-Now-Available.aspx

Personally, I would like to learn from SSC site, other DBA sites, and whitepapers.  There are a lot of good resources from very good DBAs and they are much better...

Any blocking process?  use sp_who2 to check.

Try to back up a very small database and see whether backup itself works or not.

What kind of database?  OLTP or datawarehouse?   How is it being used and going to be used?  Any replication?

I found a debate about "Identity and Primary Keys" so you can hear...

I agree with Brandie.  You should have dev/qa/production the same version.

If you run production on SQL 2000, make the database work and verified on a SQL 2000 environment first before promoting...

Good comments.  Thank you all for your input.  I used Sybase before and think it is a good product.  Just want to hear more people's different opinions. 

My platform is IBM XSERIES_3550 Windows 2003 EE SP1 then SP2 applied with SQL 2005 (3054) X86.

I have contacted MS White Paper Feedback.  They did not give out helpful info. ...

Check out this link.  There are a lot of specific and detailed questions with answers.  http://www.replicationanswers.com/