Programming Microsoft SQL Server 2008

Description

Extend your programming skills with a comprehensive study of the key features of SQL Server 2008. Delve into the new core capabilities, get practical guidance from expert developers, and put their code samples to work. This is a must-read for Microsoft .NET and SQL Server developers who work with data access—at the database, business logic, or presentation levels.

Discover how to:

• Query complex data with powerful Transact-SQL enhancements
• Use new, non-relational features: hierarchical tables, native file streaming, and geospatial capabilities
• Exploit XML inside the database to design XML-aware applications
• Consume and deliver your data using Microsoft LINQ, Entity Framework, and data binding
• Implement database-level encryption and server auditing
• Build and maintain data warehouses
• Use Microsoft Excel to build front ends for OLAP cubes, and MDX to query them
• Integrate data mining into applications quickly and effectively.

Get code samples on the Web.

Sample Content

Sample Pages

Download the sample content

Table of Contents

• Acknowledgments
• Introduction
• Part I: Core Fundamentals
  • Chapter 1: Overview
  • Chapter 2: T-SQL Enhancements
  • Chapter 3: Exploring SQL CLR
  • Chapter 4: Server Management
  • Chapter 5: Security in SQL Server 2008
• Part II: Beyond Relational
  • Chapter 6: XML and the Relational Database
  • Chapter 7: Hierarchical Data and the Relational Database
  • Chapter 8: Using FILESTREAM for Unstructured Data Storage
  • Chapter 9: Geospatial Data Types
• Part III: Reach Technologies
  • Chapter 10: The Microsoft Data Access Machine
  • Chapter 11: The Many Facets of .NET Data Binding
  • Chapter 12: Transactions
  • Chapter 13: Developing Occasionally Connected Systems
• Part IV: Business Intelligence
  • Chapter 14: Data Warehousing
  • Chapter 15: Basic OLAP
  • Chapter 16: Advanced OLAP
  • Chapter 17: OLAP Queries, Tools, and Application Development
  • Chapter 18: Expanding Your Business Intelligence with Data Mining
  • Chapter 19: Reporting Services
• About the Authors
• Additional Resources for Developers from Microsoft Press
• More Great Developer Resources

Updates

Errata

We've made every effort to ensure the accuracy of this book and its companion content. Any errors that have been confirmed since this book was published can be downloaded below.

Download the errata

Submit Errata