Microsoft SQL Server 2008 Bible
Home > Computing and Information Technology > Databases > Database software > Microsoft SQL Server 2008 Bible: (Bible)
Microsoft SQL Server 2008 Bible: (Bible)

Microsoft SQL Server 2008 Bible: (Bible)


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Harness the power of SQL Server, Microsoft’s high-performance database and data analysis software package, by accesing everything you need to know in Microsoft SQL Server 2008 Bible. Learn the best practices, tips, and tricks from this comprehensive tutorial and reference, which includes specific examples and sample code, with nearly every task demonstrated in both a graphical and SQL code method. Understand how to develop SQL Server databases and data connections, how to administer the SQL Server and keep databases performing optimally, and how to navigate all the new features of the 2008 release.

Table of Contents:
Foreword. Introduction. Part I Laying the Foundation. Chapter 1: The World of SQL Server. Chapter 2: Data Architecture. Chapter 3: Relational Database Design. Chapter 4: Installing SQL Server 2008. Chapter 5: Client Connectivity. Chapter 6: Using Management Studio. Chapter 7: Scripting with PowerShell. Part II Manipulating Data with Select. Chapter 8: Introducing Basic Query Flow. Chapter 9: Data Types, Expressions, and Scalar Functions. Chapter 10: Merging Data with Joins and Unions. Chapter 11: Including Data with Subqueries and CTEs. Chapter 12: Aggregating Data. Chapter 13: Windowing and Ranking. Chapter 14: Projecting Data Through Views. Chapter 15: Modifying Data. Chapter 16: Modification Obstacles. Part III Beyond Relational. Chapter 17: Traversing Hierarchies. Chapter 18: Manipulating XML Data. Chapter 19: Using Integrated Full-Text Search. Part IV Developing with SQL Server. Chapter 20: Creating the Physical Database Schema. Chapter 21: Programming with T-SQL. Chapter 22: Kill the Cursor! Chapter 23: T-SQL Error Handling. Chapter 24: Developing Stored Procedures. Chapter 25: Building User-Defined Functions. Chapter 26: Creating DML Triggers. Chapter 27: DDL Triggers. Chapter 28: Building Out the Data Abstraction Layer. Chapter 29: Dynamic SQL and Code Generation. Part V Data Connectivity. Chapter 30: Bulk Operations. Chapter 31: Executing Distributed Queries. Chapter 32: Programming with ADO.NET 3.5. Chapter 33: Sync Framework. Chapter 34: LINQ. Chapter 35: Asynchronous Messaging with Service Broker. Chapter 36: Replicating Data. Chapter 37: Performing ETL with Integration Services. Chapter 38: Access as a Front End to SQL Server. Part VI Enterprise Data Management. Chapter 39: Configuring SQL Server. Chapter 40: Policy-Based Management. Chapter 41: Recovery Planning. Chapter 42: Maintaining the Database. Chapter 43: Automating Database Maintenance with SQL Server Agent. Chapter 44: Transferring Databases. Chapter 45: Database Snapshots. Chapter 46: Log Shipping. Chapter 47: Database Mirroring. Chapter 48: Clustering. Part VII Security. Chapter 49: Authenticating Principals. Chapter 50: Authorizing Securables. Chapter 51: Data Cryptography. Chapter 52: Row-Level Security. Part VIII Monitoring and Auditing. Chapter 53: Data Audit Triggers. Chapter 54: Schema Audit Triggers. Chapter 55: Performance Monitor. Chapter 56: Tracing and Profiling. Chapter 57: Wait States. Chapter 58: Extended Events. Chapter 59: Change Tracking. Chapter 60: Change Data Capture. Chapter 61: SQL Audit. Chapter 62: Management Data Warehouse. Part IX Performance Tuning and Optimization. Chapter 63: Interpreting Query Execution Plans. Chapter 64: Indexing Strategies. Chapter 65: Query Plan Reuse. Chapter 66: Managing Transactions, Locking, and Blocking. Chapter 67: Data Compression. Chapter 68: Partitioning. Chapter 69: Resource Governor. Part X Business Intelligence. Chapter 70: BI Design. Chapter 71: Building Multidimensional Cubes with Analysis Services. Chapter 72: Programming MDX Queries. Chapter 73: Authoring Reports with Reporting Services. Chapter 74: Administering Reporting Services. Chapter 75: Analyzing Data with Excel. Chapter 76: Data Mining with Analysis Services. Appendix A: SQL Server 2008 Specifications. Appendix B: Using the Sample Databases. Index.

About the Author :
Paul Nielsen, SQL Server MVP, organizes the annual Colorado PASSCamp and serves on the PASS Board of Directors. He's the author of the SQL Server Bible series (Wiley), and presenter of the Total Training SQL Server Development video. Paul's speaking schedule for 2007 includes:?PASS (Summit and chapters), SQL Server Open World (Denmark), SQL Teach (Montreal and Vancouver), and his Smart Database Design Seminar. He offers free screencasts at www.SQLServerBible.com. Mike White is a data analysis and SQL BI expert. He was the principle BI architect for a major Wall Street analysis firm and was a founding member of a BI consulting firm. Mike is a popular speaker on the BI circuit and a member of the prestigious PASS Speaker's Bureau. He also serves as President of the Boulder Colorado PASS Chapter. Uttam Parui is currently a Senior Premier Field Engineer at Microsoft. In this role, he delivers Microsoft SQL Server consulting and support for designated strategic customers. He acts as a resource for ongoing SQL planning and deployment, analysis of current issues, migration to new SQL environments. He is also responsible for SQL workshops and training for customer's existing support staff. He has worked with SQL Server more than 10 years.


Best Sellers


Product Details
  • ISBN-13: 9780470257043
  • Publisher: John Wiley & Sons Inc
  • Publisher Imprint: John Wiley & Sons Inc
  • Height: 236 mm
  • No of Pages: 1680
  • Spine Width: 51 mm
  • Width: 188 mm
  • ISBN-10: 0470257040
  • Publisher Date: 01 Sep 2009
  • Binding: Paperback
  • Language: English
  • Series Title: Bible
  • Weight: 2268 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Microsoft SQL Server 2008 Bible: (Bible)
John Wiley & Sons Inc -
Microsoft SQL Server 2008 Bible: (Bible)
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 Bible: (Bible)

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!