Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies [NOOK Book]

Overview

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; ...
See more details below
Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$22.99
BN.com price
(Save 42%)$39.99 List Price
Note: This NOOK Book can be purchased in bulk. Please email us for more information.

Overview

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 Show Less

Product Details

  • ISBN-13: 9781118051948
  • Publisher: Wiley
  • Publication date: 2/9/2011
  • Series: For Dummies Series
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 768
  • Sales rank: 584,334
  • File size: 39 MB
  • Note: This product may take a few minutes to download.

Meet the Author

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 More Show Less

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

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)