Microsoft® SQL Server® 2008 Step by Step Mike Hotek PDF

Your hands-on, step-by-step guide to learning the fundamentals of SQL Server 2008 programming. 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