Programming Microsoft SQL Server 2005 - Softcover

Brust, Andrew; Forte, Stephen

Softcover

ISBN 10: 0735619239 ISBN 13: 9780735619234

Publisher: Microsoft Press, 2006

Synopsis

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

About this title

About the Author

Andrew J. Brust is the Chief, New Technology at twentysix New York, a Microsoft Gold Certified Partner specializing in business intelligence, enterprise integration and Microsoft .NET application development. Andrew is a Microsoft Regional Director for New York/New Jersey and a member of Microsoft’s Business Intelligence Partner Advisory Council.

Stephen Forte is the cofounder and CTO of Corzen, Inc. He is also a Microsoft Regional Director for New York and a Microsoft MVP.

Edition details

• Publisher: Microsoft Press
• Publication date: 2006
• Language: English
• ISBN 10: 0735619239
• ISBN 13: 9780735619234
• Binding: Paperback
• Number of pages: 950