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 software development or searching for database solutions for your company; Microsoft SQL Server 2008 All-In-One Desk Reference 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 Design a database and communicate with it Recover; analyze and report data Create solid and solid database applications Use the SQL Server Optimizer and the Query Designer Browse SQL Server with Visual Studio Develop reports useful with the Report Builder and Report Designer Create Business 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 Design and use databases Interact with your data base Programming Reporting Services 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 problems and even answer your questions along the way!

View more
  • 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
  • Citation

Leave us a comment

No Comments

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