Microsoft® SQL Server®2008 All in One Desk Reference for Dummies – Robert D. Schneider, Darril Gibson – 1st Edition


If you are in charge of database administration; database development or searching for database solutions for your company; Microsoft 2008 All-In-One Desk for Dummies can help you to handle this extremely popular system of relational database management. . Here we find the news in the latest version; how to choose and install the correct variation for your needs; how to monitor; maintain and protect your data; and what it takes to keep your database healthy.
Discover how to: Create and maintain tables a database and communicate with it Recover; analyze and report data Create solid and solid database Use the Optimizer and the Query Designer Browse SQL Server with Visual Studio Develop reports useful with the Report Builder and Report Designer Create Intelligence solutions with Business Intelligence Development Studio Configure your server and perform important administrative tasks to help you quickly find what you need; Microsoft SQL Server 2008 All-In-One Desk Reference for Dummies is divided in nine minibooks: Essential concepts and use databases Interact with your data base Programming Reporting Analysis Services Performance tips and tricks Database administration appendices Microsoft SQL Server 2008 All-in-One The desktop reference for Dummies it helps you get started; it helps you solve See and even answer your questions along the way!

View 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

Leave us a commentNo Comments

Inline Feedbacks
View all comments
Would love your thoughts, please comment.x