Microsoft SQL Server 2008: Step by Step

by Mike Hotek

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 booktech@oreilly.com.

Genres: Bisexual

544 pages, Paperback

First published November 12, 2008

Reviews

[Thomas · Rating 2 out of 5]

I had some of my webapps get upgraded from 2000 to 2008. I didn't need to rewrite much but I wanted to know what new features were available. I don't spend much time with SQL Server but I was able to get most of the info I needed to make a few optimizations to my old apps. If you aren't doing a lot of DBA type work this is a nice refresher for after a few years on ice.

[Jay · Rating 5 out of 5]

Nice overview of every aspect of SQL Server 2008 -- no stone is left unturned. There was just enough SQL to serve as a brush-up. The book explained the new inner and outer join syntax. Not new for most people; I realized I had not written serious SQL code in 10 years. Of course, this is 2014 and the book only covers 2008... There is a 2012 "Step by Step" book but the author is Patrick LeBlanc.

[Yoliz]

is interesting