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

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

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.

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.

Teach yourself SQL Server 2008one 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 toolsReporting, 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. 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 For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook. "Teach yourself how to design and create SQL Server 2008 databases - one step at a time. Work at your own pace through the book's practical, skill-building lessons and the hands-on practice files on CD. You'll begin by learning to install and configure SQL Server 2008, design a model database, and work with tables and indexes. Next, you'll learn techniques to manipulate, maintain, and retrieve data. Finally, you'll learn more-advanced techniques, such as using views, functions, and triggers. As you complete each lesson, you can hone your skills using the practice exercises on the companion CD. Plus, you can review and download code samples illustrating the author's own, professional techniques - direct from the companion Web site"--Publisher's description Overview of Microsoft SQL Server Installing and configuring SQL Server 2008 Using the tools in SQL Server 2008 Creating databases Designing tables Indexes Partitioning Data retrieval Advanced data retrieval Data manipulation Views Stored procedures Functions Triggers Database snapshots Service broker Full-text indexing Security Policy-based management Data recovery SQL server agent Dynamic management views High availability SQL server integration services SQL server reporting services SQL server analysis services.