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-SQLWork with the new XML data type and XQuery methodAutomate common administration and maintenance tasksDebug databases, reports, and objects using Microsoft Visual Studio 2005Write transactional code and implement local and distributed transactionsDevelop mobile data applications using SQL Server 2005 Everywhere EditionUse 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 componentsPLUS—Get C# code samples on the Web