SQL Server 2005 Integration Services Guided Tours

Good resource in SSIS

http://www.microsoft.com/sql/technologies/integration/tours.mspx

SQL Server 2005 Performance Dashboard Reports

This is a wonderful resource to have with SSMS. With SP2 giving you an window to build custom reports use these for your help to diagonize problems. Download from here
http://www.microsoft.com/downloads/details.aspx?FamilyId=1D3A4A0D-7E0C-4730-8204-E419218C1EFC&displaylang=en

SQL Server 2005 Deployment Guidance for Web Hosting Environments - Best Practices

a wonderful article which explain almost all issues in SQL Server 2005

SQL Server 2005 Deployment Guidance for Web Hosting Environments - by Alex DeNeui http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/SQL2005DGWHE.mspx

How to unlock the user with out password reset

there is no direct way... this is a workaround

Alter login [test1] with CHECK_POLICY = OFF
go
Alter login [test1] with CHECK_POLICY = ON
go

Tools for SQL Server

Object Comparison:
AdeptSQL Diff
AlfaAlfa Software - SQL Server Comparison Tool
ApexSQL – SQL Diff
Best SoftTool – SQL DBCompare
e-Dule - DB SynchroComp
PrimeLogics - DataVision 2007
Quest – SchemaCompare
RAC4SQL's QALite (Free)
Red Gate – SQL Compare
SQL Effects Clarity
TASC - SQL Delta
Teratrax Database Compare
TulsaSoft - SQL Examiner
Voltex Data Systems - SQLDBcontrol
XpressApps - sqlXpress Diff
xSQL Software - xSQL Object


Data Comparison
ApexSQL – SQL Diff
Best SoftTool – SQL DBCompare
Quest - DataCompare
Red Gate – Data Compare
TASC - SQL Delta
TulsaSoft - SQL Data Examiner
xSQL Software - xSQL DataCompare

DTS Comparison
Red Gate – DTS Package Compare

Server Comparison
Quest - ServerCompare

Free Tools
RAC4SQL's QALite (Free)
SQL Effects Clarity CE Edition

courtesy to Arnie -- thanks Arnie