Programming Microsoft SQL Server 2005
Published on 21. June 2006
Book
Paperback/Softback
928 pages
978-0-7356-1923-4 (ISBN)
Description
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
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
More details
Language
English
Place of publication
Redmond
United States
Dimensions
Height: 229 mm
Width: 187 mm
Weight
1000 gr
ISBN-13
978-0-7356-1923-4 (9780735619234)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
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.
Content
Part 1 - Design Fundamentals and Core Technologies 1 - Overview 2 - Exploring the T-SQL Enhancements in SQL Server 2005 3 - An Overview of SQL CLR 4 - XML and the Relational Database 5 - Introducing SQL Server Management Studio 6 - Using SQL Server Management Objects (SMO) 7 - SQL Server 2005 Security Part 2 - Applications Development and Reach Technologies 8 - ADO.NET 2.0, Typed DataSet Objects and .NET Data Binding 9 - Debugging 10 - SQL Server 2005 Native XML Web Services 11 - Transactions 12 - SQL Server Service Broker: The New Middleware 13 - Using SQL Server 2005 Notification Services 14 - Developing Desktop Applications with SQL Server Express Edition 15 - Developing Applications with SQL Server 2005 Everywhere Edition and SQL Server Merge Replication Part 3 - Reporting and Business Intelligence 16 - Using SQL Server 2005 Integration Services 17 - Basic OLAP 18 - Advanced OLAP 19 - OLAP Application Development 20 - Extending your Database System with Data Mining 21 - Reporting Services Index