SQL DBA Metrials

Question

SQL DBA Metrials

marees.inspire

Ten Centuries

Points: 1324
More actions
March 5, 2009 at 12:14 am

#135258

Hi ALl,
I am newbie to SQL DBA. Please provide me some useful
e books/artciles/mateirlas/links to learn it in efficient manner.
Thanks in Advance.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Dugi SSCoach Points: 17998 More actions · Answer 1

v-makath (3/5/2009)
Hi ALl,
I am newbie to SQL DBA. Please provide me some useful
e books/artciles/mateirlas/links to learn it in efficient manner.
Thanks in Advance.

Do some search inside this forum and you will find many things what you are interested!

As you can see on the left you have some links such Training, Books, Scripts and Blogs, sure that you will find good stuff there!

Have a nice learning!

Dugi

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Sakthivel Chidambaram SSCertifiable Points: 5531 More actions · Answer 2

Hi,

Some of my references.

1. E-Books --> http://www2.mygoogle.co.in/search/?q=filetype%3Apdf+SQL+Server

2. Free Video Tutorials --> http://wtv.watchtechvideos.com

3. SQL Server Quiz SQL Server Quiz --> http://www2.mygoogle.co.in/search/?q=SQL+Server+Quiz

Happy Learning!

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 3

Don't forget to check Books online(installed with sql server installation).

MJ

Dugi SSCoach Points: 17998 More actions · Answer 4

MANU (3/5/2009)
Don't forget to check Books online(installed with sql server installation).
MJ

Yep that's right MJ even that BOL has toooo much information about every detail, better to start from here in SSC, then something from tutorials and finally from BOL ( Books OnLine )!

Have nice learning!

😛

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

ravikanth. Hall of Fame Points: 3472 More actions · Answer 5

SQL SERVER 2005 - Administrator`s Companion

very good book to begin with.

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 6

Sakthivel Chidambaram (3/5/2009)
Hi,
Some of my references.
1. E-Books --> http://www2.mygoogle.co.in/search/?q=filetype%3Apdf+SQL+Server
2. Free Video Tutorials --> http://wtv.watchtechvideos.com
3. SQL Server Quiz SQL Server Quiz --> http://www2.mygoogle.co.in/search/?q=SQL+Server+Quiz
Happy Learning!

teh middle one is nice, but i can't imagine why all the videos are integrated into a forum. why no RSS or podcast ability?

Sakthivel Chidambaram SSCertifiable Points: 5531 More actions · Answer 7

Hi,

RSS is there in that site but only for Active Topics. Anyways so many videos at one place is nice and quick to refer. Like "Apple a day..." we can follow "Video a day..."

Since it is a forum, we can expect lot of contributors like you sharing the videos they know there so that everyone will get benefits...

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc

Elizabeth.Block Hall of Fame Points: 3516 More actions · Answer 8

When I became a DBA overnight because the main DBA was fired, the book I read that was really helpful was SQL Server 2000 for Experienced DBAs by Brian Knight. The books I'm reading now about SS 2005 are Inside MS SQL Server 2005: The Storage Engine by Kalen Delaney and Professional SQL Server 2005 Performance Tuning by Wrox Press. There's a lot to learn and you just have to dig in and start!

A few good websites (besides this one, of course! ):

http://www.sql-server-performance.com/articles/dba/main.aspx

http://vyaskn.tripod.com/scripting_permissions_in_sql_server_2005.htm

http://www.mssqltips.com/webcastlist.asp

http://www.databasejournal.com/features/mssql/article.php/3447711/SQL-Server-2005-Part-4---High-Availability-and-Scalability-Enhancements---Online-Indexing-Fast-Recovery-Database-Snapshots-and-Snapshot-Isolation.htm

Videos that are really helpful

http://www.jumpstarttv.com/channels/SQL.aspx

Good luck!

Elizabeth

marees.inspire Ten Centuries Points: 1324 More actions · Answer 9

Thanks for everyone for your valuable inputs...

these r really helpful.............:)

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 10

Another suggestion is to look at the DBA cert books. Not to study for an exam, but because some of the better cert books give you detail by detail how to do certain things and why (or why not) you should do them.

Sybex has the best "beginner" cert books, IMHO.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.