Learn to Use Books Online

, 2012-08-06

On ReadingOne of the first questions I hear from folks wanting to grow in their Microsoft SQL Server DBA or database developer careers is, "What tools/books do you recommend?" I've noticed my first answer catches quite a few folks off guard:

"Learn to use Books Online."

To the old hat SQL Server DBAs, this is one of those obvious answers. Yes, there are a few bugs here and there in the documentation. However, Books Online (BOL) contains a ton of information. Whether you're working in the GUI or typing in T-SQL, the steps are there. Examples are given. You'd be hard pressed to find a better example of documentation for a product. Yet it seems like most folks completely ignore it. That leaves me scratching my head.

When I was more active in the various forums, one of the things I noted was how many times a SQL Server question could have been answered by a quick look in Books Online. A lot of times BOL had an example which adequately answered their question. This told me one of three things were true:

  • The person had never looked in Books Online.
  • The person didn't know how to use Books Online.
  • The person could find the information but it didn't "click" that he or she had found the answer.

I can help with the first issue. Books Online comes on the install DVD or .iso for SQL Server. However, you don't have to have the media to get to it. Here are two other ways:

As for the second, my advice is to get into Books Online and use it. Go through the topical hierarchy and read up on something you want to learn about. Understand how it's organized. Then click the Index tab and learn to search for what you're wanting to find. Learn how to use filters. If you're looking for a T-SQL answer, you likely only want to have Books Online pull from the Database Engine.

And when you've done #1 and #2, that's what the forums are for. That's what #sqlhelp is for on Twitter. By doing the research yourself before you ask others for help, you are more likely to understand the solution that someone else might present. You also might have ruled out certain potential solutions because of your given environment. The key, though, is to try and find the answer yourself with the excellent document provided. It's the starting point.





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.


1,567 reads

Networking - Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let...


1,530 reads

Speaking at Community Events - More Thoughts

Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I've got a few more thoughts on the topic this week, and I look forward to your comments.


360 reads