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

Description

If you are in charge of database administration; database software development or searching for database solutions for your company; Microsoft 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 a database and communicate with it Recover; analyze and report data Create solid and solid database applications Use the 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 and use databases Interact with your data base Programming Reporting Services Services Performance tips and tricks Database appendices Microsoft Server 2008 All-in-One The desktop reference for Dummies it helps you get started; it helps you solve See and even answer your 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 commentNo Comments


guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x