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

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

    by Robert D. Schneider, Darril Gibson


    eBook

    $22.99
    $22.99
     $39.99 | Save 43%

    Customer Reviews

      ISBN-13: 9781118051948
    • Publisher: Wiley
    • Publication date: 02/09/2011
    • Series: For Dummies Books
    • Sold by: Barnes & Noble
    • Format: eBook
    • Pages: 768
    • Sales rank: 399,364
    • File size: 40 MB
    • Note: This product may take a few minutes to download.

    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.

    Read an Excerpt

    Click to read or download

    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

    Available on NOOK devices and apps

    • NOOK eReaders
    • NOOK GlowLight 4 Plus
    • NOOK GlowLight 4e
    • NOOK GlowLight 4
    • NOOK GlowLight Plus 7.8"
    • NOOK GlowLight 3
    • NOOK GlowLight Plus 6"
    • NOOK Tablets
    • NOOK 9" Lenovo Tablet (Arctic Grey and Frost Blue)
    • NOOK 10" HD Lenovo Tablet
    • NOOK Tablet 7" & 10.1"
    • NOOK by Samsung Galaxy Tab 7.0 [Tab A and Tab 4]
    • NOOK by Samsung [Tab 4 10.1, S2 & E]
    • Free NOOK Reading Apps
    • NOOK for iOS
    • NOOK for Android

    Want a NOOK? Explore Now

    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!

    Read More

    Customers Who Bought This Item Also Bought

    Recently Viewed 

    Sign In Create an Account
    Search Engine Error - Endeca File Not Found