Microsoft® SQL Server® 2008 Step by Step (Step by Step (Microsoft)) [Paperback]

Mike Hotek (Author)

Book Description

ISBN-10: 0735626049 | ISBN-13: 978-0735626041 | Publication Date: November 12, 2008 | Edition: Pap/Cdr

Teach yourself SQL Server 2008—one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications, write queries, develop reports, and employ powerful business intelligence systems.

Discover how to:

• Install and work with core components and tools
• Create tables and index structures
• Manipulate and retrieve data
• Secure, manage, back up, and recover databases
• Apply tuning plus optimization techniques to generate high-performing database applications
• Optimize availability through clustering, database mirroring, and log shipping
• Tap business intelligence tools—Reporting, Analysis, and Integration Services

CD features:

• Practice exercises and code samples
• Fully searchable eBook

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [e-mail].

Editorial Reviews

About the Author

Mike Hotek is a SQL Server expert with three decades' experience as a consultant and solution developer. He has written several books, including Microsoft SQL Server 2008 Step by Step.

Product Details

• Paperback: 544 pages
• Publisher: Microsoft Press; Pap/Cdr edition (November 12, 2008)
• Language: English
• ISBN-10: 0735626049
• ISBN-13: 978-0735626041
• Product Dimensions: 9 x 7.3 x 1.4 inches
• Shipping Weight: 2.2 pounds (View shipping rates and policies)
• Average Customer Review: 3.6 out of 5 stars  See all reviews (13 customer reviews)
• Amazon Best Sellers Rank: #90,961 in Books (See Top 100 in Books)
  • #33 in Books > Computers & Technology > Microsoft > Development > SQL Server
  • #46 in Books > Computers & Technology > Databases > SQL

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

30 of 31 people found the following review helpful:

5.0 out of 5 stars A Great Help in Understanding MS SQL Server, January 14, 2009

By 

default_character (Reno, NV USA) - See all my reviews

This review is from: Microsoft® SQL Server® 2008 Step by Step (Step by Step (Microsoft)) (Paperback)

I just completed a different MS SQL Server 2008 book, and am now wishing that I would have read this first, basically because the author, Hotek, is so much more concise and is defining terms as he goes, and is clearer when describing database concepts. So now I am forced to read this book too, just to clear up what was confusing in the first book!

What this book has that the *other* didn't is a really organized approach to MS SQL Server, including a description of all the tools that come with it and a meaty section on Business Intelligence with chapters on SQL Server Integration, Reporting and Analysis Services, which is the reason I bought this book originally.

As a side note, Mr. Hotek also obviously has a lot of experience and is sane... in Chapter 5, he gives an opinion on database design that I have secretly thought for years and I can't believe he said this:
"...Lost in all of this material is the simple fact that tables have to be created to support an application and the people creating the tables have more important things to worry about than which normal form a database is in or if they remembered to build a logical model and render a physical model from the logical model."

That totally floored me and impressed me. I have read many books where the author is so freaked out about 1st, 2nd and 3rd normal form, that it made me completely cross-eyed. It is the application and the basic design of the database, and what the users need that is what's important... not worrying about conforming to some theoretical utopia. I'm not saying we should build tables full of redundant data - obviously not - but let's stay focused on the task at hand.

Anyway, I would say this is not a book for beginning programmers, but it is a great book for beginning MS SQL server developers.

I recommended in my review of the *other* MS SQL Server 2008 book that you should get more than one book on any technical subject to help fill in the gaps, and hopefully one book can explain concepts that the other can't... I still stand by that.

17 of 17 people found the following review helpful:

5.0 out of 5 stars A Good Introduction to SQL Server 2008, January 1, 2009

By 

Stephen Vaillancourt (MA) - See all my reviews
(REAL NAME)   

This review is from: Microsoft® SQL Server® 2008 Step by Step (Step by Step (Microsoft)) (Paperback)

This book was a pleasant surprise, I was looking for an introduction to SQL Server and this book was exactly that. The chapters were all in manageable sizes with the right amount of detail and exercises (%95+ worked as expected) to reinforce the topic. I don't usually write reviews, but if you are looking like I was for a book provide a basic introduction to SQL Server 2008 I would recommend this one. As a bonus there script which the author says can be used in production to perform backups.

12 of 12 people found the following review helpful:

3.0 out of 5 stars OK Overall.., June 12, 2009

By 

Hemingway (Australia) - See all my reviews

This review is from: Microsoft® SQL Server® 2008 Step by Step (Step by Step (Microsoft)) (Paperback)

..but let down by some poor editing, and the fact that content, pointed out as being 'online' in the book, doesnt actually exist. Not sure why they couldnt just put the articles on the CD.

Also some of the 'steps' are incomplete..Google came to rescue on the odd occasion. This book needs a companion web site, with an errata list.

Also the book is 500 pages (approx.) not 800 as Amazon indicates.

I would probably supplement this with the 'Pro' book from Wrox.