Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

What things should every SQL Server database administrator know?

Books, blogs, tools, you name it.

share

locked by Michael Hampton Jun 4 '13 at 6:45

This question exists because it has historical significance, but it is not considered a good, on-topic question for this site, so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. More info: help center.

2  
This should be a community wiki. –  scheibk May 2 '09 at 18:06

11 Answers 11

Sites

Most of these are multiple purpose. For instance, articles + forums + blogs. This is by no means exhaustive. It's a starting point as you'll find a lot of other blogs and resources from these sites.

Books

This really depends on your role. If you're an operational DBA, you'll want the Wrox book on Administration. If you're dealing with Integration Services, look for the books and resources by SQL Server MVP Brian Knight as a start. If you're doing development, look for SQL Server MVP Louis Davidson's Design book from Apress and SQL Server MVP Grant Fritchey's book on Query Tuning, also from Apress. I'm not very strong on Analysis Services, so I'll leave that for others to recommend. SSRS there are a ton of good books. Also look for the free ebooks at SQL Server Central.

Tools

A lot of good vendors. Start by knowing what comes with SQL Server. Profiler, SSMS, and Configuration Manager you should know cold. BIDS if you do SSIS or SSRS. Otherwise, 3rd parties to look at (in alphabetical order, as people's preferences vary):

Social Networks

There's a group of us fairly active on Twitter. You can find the list of us at SQLServerPedia. Most of us are connected via LinkedIn and FaceBook as well.

share

Don't forget about basic tools

enter image description here

share
1  
+1 for being visual! –  esabine May 12 '09 at 10:59

Also check out sqlpass.org as it has a list of most of the SQL DBA Blogs out there.

share

Don't forget http://twitter.com

Follow SQL guys. SQL Gurus like K. Brian Kelley, mrdenny, Brent Ozar - among others, are all in twitter. Kimberly Tripp & Paul Randal are in twitter too! Follow their tweets. They usually talk a lot about their activities around SQL Server.

share
    
Twitter is outstanding for the SQL Server community. –  ScottStonehouse May 13 '09 at 18:18
    
Agreed, +1 on that one –  SQLMenace May 18 '09 at 21:05

Getting to know the DMV's well is on the top of my list. You'd be surprised by how many people overlook those when looking for answers to questions about their servers.

share

http://www.simple-talk.com is good for the occasional read as well.

share

This site contains countless tips that have a proven track record:

SSW Rules to Better SQL Server Databases

share

How to read a query optimization plan and tune queries by re-writing them and/or creating the correct indexes.

share

Read Kalen Delaney's book on SQL Server Internals.

Itzik Ben-Gan's books and site have also been a big help.

share

sqlreleaseservices blog for updates.

http://blogs.msdn.com/b/sqlreleaseservices/

Many have no clue where they get an overview of what the current cumulative update is - and it shows in the versions they run.

share

protected by Michael Hampton Jun 4 '13 at 6:44

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.