Print this page Share

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

ISBN: 978-1-118-05194-8
768 pages
February 2011
Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies (1118051947) cover image


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!

See More

Table of Contents

Introduction 1

Book I: Essential Concepts 7

Chapter 1: Introducing SQL Server 2008 9

Chapter 2: SQL Server Architecture and Key Concepts 15

Chapter 3: Getting Started, Getting Around 23

Chapter 4: Setting Up SQL Server 2008 35

Chapter 5: Using SQL Server Management Studio 59

Book II: Designing and Using Databases 73

Chapter 1: Setting Up a Database 75

Chapter 2: Care and Feeding of Your Database 89

Chapter 3: Data Types and How to Use Them 99

Chapter 4: Constructing New Tables 121

Chapter 5: Looking After Your Tables 141

Chapter 6: Understanding Relationships 155

Book III: Interacting with Your Data 175

Chapter 1: Using Proper Normalization Techniques 177

Chapter 2: The SQL Server Optimizer 187

Chapter 3: Using the Query Designer 201

Chapter 4: Setting Query Options 213

Chapter 5: Searching for Information 231

Chapter 6: Organizing Query Results 257

Chapter 7: Modifying Your Data 265

Chapter 8: Taking Advantage of Views 273

Chapter 9: Advanced Query Topics 291

Book IV: Database Programming 313

Chapter 1: Understanding Transact-SQL 315

Chapter 2: Stored Procedures and Functions 331

Chapter 3: Triggers 349

Chapter 4: Working with Visual Studio 361

Chapter 5: Web Services 375

Chapter 6: Developing Remote Applications 385

Chapter 7: Advanced Development Topics 401

Book V: Reporting Services 419

Chapter 1: Introduction to SQL Server Reporting Services 421

Chapter 2: Creating Reports with Report Builder 435

Chapter 3: Creating Reports with Report Designer 449

Chapter 4: Integrating Reports 469

Book VI: Analysis Services 477

Chapter 1: Introduction to SQL Server Analysis Services 479

Chapter 2: Creating Business Intelligence Solutions with BIDS 493

Chapter 3: Data Mining and Maintaining Analysis Services Objects 517

Book VII: Performance Tips and Tricks 529

Chapter 1: Working with the SQL Server Optimizer 531

Chapter 2: Using Performance Monitoring Tools 541

Chapter 3: Data Access Strategies 569

Chapter 4: Tuning SQL Server 587

Book VIII: Database Administration 601

Chapter 1: Configuring SQL Server 603

Chapter 2: Performing Major Administrative Tasks 619

Chapter 3: Security: Keeping SQL Server Safe 647

Chapter 4: Integration and Your Database 661

Chapter 5: Replication 677

Chapter 6: Spreading the Load with Partitioning 693

Book IX: Appendixes 701

Appendix A: Ten Sources of Information on SQL Server 2008 703

Appendix B: Troubleshooting SQL Server 2008 707

Appendix C: Glossary 715

Index 725

See More

Author Information

Robert D. Schneider is a database optimization consultant who has been delivering software solutions for 15 years. Darril Gibson is a professional trainer specializing in certification and Microsoft technologies.

See More
Back to Top