Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies
Home > Computing and Information Technology > Databases > Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies
Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies

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

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

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!

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


Best Sellers


Product Details
  • ISBN-13: 9781118051948
  • Publisher: John Wiley & Sons Inc
  • Binding: Digital (delivered electronically)
  • No of Pages: 768
  • ISBN-10: 1118051947
  • Publisher Date: 09 Feb 2011
  • Language: English


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies
John Wiley & Sons Inc -
Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

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

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!