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

Full Product Details

Author:   Andrew Brust ,  Stephen Forte
Publisher:   Microsoft Press,U.S.
Imprint:   Microsoft Press,U.S.
Dimensions:   Width: 18.70cm , Height: 3.80cm , Length: 22.90cm
Weight:   1.000kg
ISBN:  

9780735619234

ISBN 10:   0735619239
Pages:   928
Publication Date:   21 June 2006
Audience:   General/trade ,  General
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   In Print  
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

Table of Contents

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

Reviews

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions