A hands-on reference for developers and database administrators, this book covers the basics of developing customized database applications with Microsoft SQL Server 2005. Includes code samples and real-world, expert insight.

Get the straightforward information you need to learn the core programmability features in SQL Server 2005. This guide offers hands-on programming instruction, practical examples, and code samples to help you design and develop robust database applications and business intelligence solutions.

Discover how to:

• Program views, stored procedures, triggers, and functions using T-SQL
• Work with the new XML data type and XQuery method
• Automate common administration and maintenance tasks
• Debug databases, reports, and objects using Microsoft Visual Studio 2005
• Write transactional code and implement local and distributed transactions
• Develop mobile data applications using SQL Server 2005 Everywhere Edition
• Use SQL Server Notification Services to develop applications that deliver event-driven notifications to users
• Use business intelligence tools, such as SQL Server Reporting Services and OLAP and data mining components

PLUS—Get C# code samples on the Web