Written by industry professionals who have been working with SQL Server 2008 since the earliest code, this reference expertly covers the programming fundamentals for SQL Server 2008 with crucial real-world context and extensive code samples.
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:
Program views, stored applications, triggers, and functions using T-SQL
Work with the new data types, LINQ, and the ADO.NET Entity Framework
Automate common administration and maintenance tasks
Debug databases, reports, and objects using Microsoft Visual Studio® 2008
Write transactional code and implement local and distributed transactions
Use business intelligence tools, such as SQL Server Reporting Services, SQL Server Analysis Services, and SQL Server Integration Services
Many of the books examples, exercises, and code samples are available for download from the companion Web site.