Microsoft SQL Server 2008: Step by Step

by Mike Hotek

Teach yourself SQL Server 2008OCoone 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 toolsCreate tables and index structuresManipulate and retrieve dataSecure, manage, back up, and recover databasesApply tuning plus optimization techniques to generate high-performing database applicationsOptimize availability through clustering, database mirroring, and log shippingTap business intelligence toolsOCoReporting, Analysis, and Integration ServicesCD features: Practice exercises and code samplesFully searchable eBookA Note Regarding the CD or DVDThe 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, Kindle Edition

First published November 12, 2008

Reviews

[Thomas]

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]

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