Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies

If you re in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies can help you get a handle on this extremely popular relational database management system. Here you ll find what s new in the latest version; how to choose and install the right variation for your needs; how to monitor, maintain, and protect your data; and what it takes to keep your database healthy. You ll discover how to: Build and maintain tables Design a database and communicate with it Retrieve, analyze, and report data Build solid, robust database applications Use the SQL Server Optimizer and Query Designer Navigate SQL Server with Visual Studio Develop useful reports with the Report Builder and Report Designer Create Business Intelligence solutions with Business Intelligence Development Studio Configure your server and perform major administrative tasks To help you quickly find what you need, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies is divided into nine minibooks: Essential Concepts Designing and Using Databases Interacting With Your Data Database Programming Reporting Services Analysis Services Performance Tips and Tricks Database Administration Appendixes Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies gets you started, helps you solve problems, and will even answer your questions down the road!

If you're in charge of database administration, developingdatabase software, or looking for database solutions for yourcompany, Microsoft SQL Server 2008 All-In-One Desk Reference ForDummies can help you get a handle on this extremely popularrelational database management system. Here you'll findwhat's new in the latest version; how to choose and installthe right variation for your needs; how to monitor, maintain, andprotect your data; and what it takes to keep your database healthy.You'll discover how to:* Build and maintain tables* Design a database and communicate with it* Retrieve, analyze, and report data* Build solid, robust database applications* Use the SQL Server Optimizer and Query Designer* Navigate SQL Server with Visual Studio* Develop useful reports with the Report Builder and ReportDesigner* Create Business Intelligence solutions with BusinessIntelligence Development Studio* Configure your server and perform major administrativetasksTo help you quickly find what you need, Microsoft SQL Server2008 All-In-One Desk Reference For Dummies is divided into nineminibooks:* Essential Concepts* Designing and Using Databases* Interacting With Your Data* Database Programming* Reporting Services* Analysis Services* Performance Tips and Tricks* Database Administration* AppendixesMicrosoft SQL Server 2008 All-In-One Desk Reference ForDummies gets you started, helps you solve problems, and willeven answer your questions down the road!

Introduction 1Book I: Essential Concepts 7Chapter 1: Introducing SQL Server 2008 9Chapter 2: SQL Server Architecture and Key Concepts 15Chapter 3: Getting Started, Getting Around 23Chapter 4: Setting Up SQL Server 2008 35Chapter 5: Using SQL Server Management Studio 59Book II: Designing and Using Databases 73Chapter 1: Setting Up a Database 75Chapter 2: Care and Feeding of Your Database 89Chapter 3: Data Types and How to Use Them 99Chapter 4: Constructing New Tables 121Chapter 5: Looking After Your Tables 141Chapter 6: Understanding Relationships 155Book III: Interacting with Your Data 175Chapter 1: Using Proper Normalization Techniques 177Chapter 2: The SQL Server Optimizer 187Chapter 3: Using the Query Designer 201Chapter 4: Setting Query Options 213Chapter 5: Searching for Information 231Chapter 6: Organizing Query Results 257Chapter 7: Modifying Your Data 265Chapter 8: Taking Advantage of Views 273Chapter 9: Advanced Query Topics 291Book IV: Database Programming 313Chapter 1: Understanding Transact-SQL 315Chapter 2: Stored Procedures and Functions 331Chapter 3: Triggers 349Chapter 4: Working with Visual Studio 361Chapter 5: Web Services 375Chapter 6: Developing Remote Applications 385Chapter 7: Advanced Development Topics 401Book V: Reporting Services 419Chapter 1: Introduction to SQL Server Reporting Services 421Chapter 2: Creating Reports with Report Builder 435Chapter 3: Creating Reports with Report Designer 449Chapter 4: Integrating Reports 469Book VI: Analysis Services 477Chapter 1: Introduction to SQL Server Analysis Services 479Chapter 2: Creating Business Intelligence Solutions with BIDS 493Chapter 3: Data Mining and Maintaining Analysis Services Objects 517Book VII: Performance Tips and Tricks 529Chapter 1: Working with the SQL Server Optimizer 531Chapter 2: Using Performance Monitoring Tools 541Chapter 3: Data Access Strategies 569Chapter 4: Tuning SQL Server 587Book VIII: Database Administration 601Chapter 1: Configuring SQL Server 603Chapter 2: Performing Major Administrative Tasks 619Chapter 3: Security: Keeping SQL Server Safe 647Chapter 4: Integration and Your Database 661Chapter 5: Replication 677Chapter 6: Spreading the Load with Partitioning 693Book IX: Appendixes 701Appendix A: Ten Sources of Information on SQL Server 2008 703Appendix B: Troubleshooting SQL Server 2008 707Appendix C: Glossary 715Index 725