Overview
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
Synopsis
This thorough, hands-on reference for developers and database administrators teaches the basics of programming custom database applications with Microsoft SQL Server 2005. It includes in-depth coverage of new programmability features-including integration with the Microsoft .NET Framework. In addition, this essential guide covers Transact-SQL, SQL Server Management Studio, SQL Service Broker, Notification Services, Integration Services, Reporting Services, OLAP, and Data Mining. The authors have extensive experience with SQL Server 2005, having worked with the technology since the earliest code, and share their expert insight into SQL Server programmability, including SQL Server 2005 Mobile Edition. You'll get real-world examples and see how to draw from your existing skills and knowledge to exploit new SQL Server technology, enhance your database security, and debug with Visual Studio 2005. This book includes extensive code samples.