DBA Part 1

Hi Friends,
 
I generally require following scripts:
 
1. To remove replication:
 
sp_removedbreplication
 
2. to read the trace into table
 
::fn_trace_gettable
 
3.
 
I like the following books very much.
 
Inside Sql Server By Kalen Delaney
The Guru’s Guide to Sql Server Architecture and internals By Ken Henderson (also some more books by ken henderson on Guru’s Guide like. T-Sql,…)

High Availability By Allan Hirt

Performance Tuning — By Brain Knight

Performance Tuning — By Ken England

Also Always use Books Online – the best.

 
 
The sites I love for sql are:
 
search engine -Google, ask and AltaVista.
www.microsoft.com/sql –latest -Yukon
www.microsoft.com/sql server – for Katmai
 
 
http://technet.microsoft.com/  — get most of the info.
 
I register my self onto "Lazydba.com" i get mails from that group its really helps you when you stuck.
 
 
other sites i mansion on my favorites list.
 
 
Hope this will help someone….
 
Thanx.
Vinay
Advertisements
This entry was posted in Computers and Internet. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s