Programming Microsoft SQL Server 2008

by Lobel, Leonard

• ISBN13: 9780735625990
• ISBN10: 0735625999
• Format: Paperback
• Copyright: 2008-10-15
• Publisher: Microsoft Pr

Summary

Get the hands-on programming instruction, practical examples, and best practices you need to master the core programmability features in SQL Server 2008. Led by three experts in database design and business intelligence solutions, you'll learn the essential tools and techniques for developing robust applications. Discover how to: Leverage the latest T-SQL programming enhancements, using table-valued parameters, MERGE, GROUPING SETS, and new date/time and time-zone capabilities Work with semistructured and unstructured data using XML, and the new "beyond relational" features, such as native file streaming, hierarchical tables, and spatial data types Automate common administration and maintenance tasks Work with the new data types, LINQ, the ADO.NET Entity Framework, WPF, and Silverlight Data binding Write transactional code and implement local and distributed transactions Use business intelligence tools, such as SQL Server Reporting Services and SQL Server Analysis Services. Many of the book's examples, exercises, and code samples are available for download from the companion Web site.

Table of Contents

Core Fundamentals
Overview	p. 3
T-SQL Enhancements	p. 13
Exploring SQL CLR	p. 111
Server Management	p. 161
Security in SQL Server 2008	p. 189
Beyond Relational
XML and the Relational Database	p. 231
Hierarchical Data and the Relational Database	p. 281
Using FILESTREAM for Unstructured Data Storage	p. 307
Geospatial Data Types	p. 341
Reach Technologies
The Microsoft Data Access Machine	p. 377
The Many Facets of NET Data Binding	p. 419
Transactions	p. 449
Developing Occasionally Connected Systems	p. 491
Business Intelligence
Data Warehousing	p. 563
Basic OLAP	p. 611
Advanced OLAP	p. 639
OLAP Queries, Tools, and Application Development	p. 717
Expanding Your Business Intelligence with Data Mining	p. 793
Reporting Services	p. 879
Index	p. 953
Table of Contents provided by Blackwell. All Rights Reserved.