Microsoft® SQL Server® 2008 Step by Step (Step by Step (Microsoft))

✍ Scribed by Mike Hotek

• Publisher: Microsoft Press
• Year: 2008
• Tongue: English
• Leaves: 533
• Edition: Pap/Cdr
• Category: Library

✦ Synopsis

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 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, d. Read more...

Content: Cover; Copyright Page; Dedication; Contents at a Glance; Table of Contents; Acknowledgments; Introduction; Who This Book Is For; How This Book Is Organized; Finding Your Best Starting Point in This Book; Conventions and Features in This Book; Conventions; Other Features; System Requirements; Sample Databases; Code Samples; Installing the Code Samples; Using the Code Samples; Uninstalling the Code Samples; Find Additional Content Online; Support for This Book; Questions and Comments; Part I: Getting Started with Microsoft SQL Server 2008; Chapter 1: Overview of Microsoft SQL Server. Database EngineStorage Engine; Security Subsystem; Programming Interfaces; Service Broker; SQL Server Agent; Replication; High Availability; The Relational Engine in SQL Server 2008; Business Intelligence; Integration Services; Reporting Services; Analysis Services; Chapter 1 Quick Reference; Chapter 2: Installing and Confi guring SQL Server 2008; Editions of SQL Server 2008; Infrastructure Requirements; Service Accounts; Collation Sequences; Authentication Modes; SQL Server Instances; Upgrading to SQL Server 2008; In-Place Upgrade; Side-by-Side Upgrade; Installing SQL Server 2008. Install Sample DatabasesChapter 2 Quick Reference; Chapter 3: Using the Tools in SQL Server 2008; SQL Server Documentation; Management Tools in SQL Server 2008; SQL Server Configuration Manager; SQL Server Management Studio; Database Mail; Performance Management Tools; Profiler; Database Engine Tuning Advisor; Performance Studio; Business Intelligence Tools; Business Intelligence Development Studio; Chapter 3 Quick Reference; Part II: Designing Databases; Chapter 4: Creating Databases; SQL Server System Databases; SQL Server Database Structure; Database Files; Filegroups; Creating a Database. Moving DatabasesDetaching a Database; Attaching a Database; Chapter 4 Quick Reference; Chapter 5: Designing Tables; Naming Objects; Schemas; Data Types; Numeric Data; Character Data; Date and Time Data; Binary Data; XML; FILESTREAM Data; Spatial Data Type; HierarchyID Data Type; Column Properties; Creating Tables; Computed Columns; Sparse Columns; Constraints; Primary Keys; Unique Constraints; Check Constraints; Default Constraints; Foreign Keys; Database Diagrams; Chapter 5 Quick Reference; Chapter 6: Indexes; Index Structure; Balanced Trees (B-trees); Index levels; Clustered Indexes. Nonclustered IndexesIndex Maintenance; Included Columns; Covering Indexes; Filtered Indexes; Online Index Creation; Index Management and Maintenance; Index Fragmentation; Fill Factor; Defragmenting an Index; Disabling an index; XML Indexes; Spatial Indexes; Chapter 6 Quick Reference; Chapter 7: Partitioning; Partition Functions; Partition Schemes; Filegroups; Partitioning Tables and Indexes; Partial Backup and Restore; Creating a Partitioned Index; Managing Partitions; SPLIT and MERGE Operators; Altering a Partition Scheme; Index Alignment; SWITCH Operator; Chapter 7 Quick Reference.
Abstract: 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 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, d