Need some Tips & Tricks..

Hi all...
I am sai..I am a ORACLE DBA for the last 3 years ...now suppose to work on SQL Server...so all the people out there...please throw some light on Critical issues in sql server, Features, Tips, Tricks and also some sitre links through which i can get some white papers/ Pdf's kinda stuff...

Thanks and Regards
SAI SREENIVAS :)Look at the 'Information_Schema.<Object>' tables. These are very useful when writing dynamic TRANSACT scripts ;)

i.e

Select Table_name from information_schema.tables

or

Select column_name from information_schema.columns