Microsoft SQL Server 2008 Bible

( 2 )

Overview

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 ...

See more details below
Paperback (New Edition)
$36.74
BN.com price
(Save 26%)$49.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (20) from $19.00   
  • New (13) from $21.95   
  • Used (7) from $19.00   

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9780470257043
  • Publisher: Wiley
  • Publication date: 8/31/2009
  • Series: Bible Series , #607
  • Edition description: New Edition
  • Edition number: 1
  • Pages: 1680
  • Sales rank: 765,731
  • Product dimensions: 7.40 (w) x 9.20 (h) x 2.40 (d)

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.

Read More Show Less

Customer Reviews

Average Rating 3
( 2 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(1)

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
Sort by: Showing all of 2 Customer Reviews
  • Posted June 24, 2010

    The book content was OK

    The support for the book sucks. All the scripts are from the previous book ssq server 2005. He missed several chapters completely and never updated the script in the book.

    2 out of 2 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted October 27, 2011

    Great

    Coolest book

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

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