Programming MS SQL Server 2005

3,091 views

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.

SQL Server 2005 is a huge release, and, to be truthful, SQL Server is now formidably vast and complex. It is no longer just a phenomenal enterprise relational database management system. It is now a bona fide middleware, service-oriented, message-based programming platform; an XML document repository; a desktop and mobile device database engine; a market-leading business intelligence (BI) platform; and a real-time alerting system all rolled into one. In fact, SQL Server isn’t one product. It’s a collection of products and technologies that, although related, should each be considered separately. How can such a massive product be covered comprehensively in a single book?

Our book reflects this reality and in many ways replicates the structure of a Sunday newspaper. For one thing, a great number of authors have been involved in producing the book, drawing on their expertise in their chapters’ specific subject matter. For another, the context and style of certain chapters differ markedly from those of other chapters. Some chapters cover specific subject matter deeply. Others cover a broader range of material, and do so at a higher level. That’s an approach we didn’t anticipate when we started the book. But it’s the approach we found most effective by the time we finished. We think it makes an otherwise overwhelming set of technologies much more approachable and makes the learning process much more modular.

TABLE OF CONTENT:
Chapter 01 - Overview
Chapter 02 - Exploring the T-SQL Enhancements
Chapter 03 - An Overview of SQL CLR
Chapter 04 - XML and the Relational Database
Chapter 05 - Introducing SQL Server Management Studio
Chapter 06 - Using SQL Server Management Objects
Chapter 07 - SQL Server 2005 Security
Chapter 08 - ADO .NET 2.0, Typed DataSet Objects, and .NET Data Binding
Chapter 09 - Debugging
Chapter 10 - SQL Server 2005 Native XML Web Services
Chapter 11 - Transactions
Chapter 12 - SQL Server Service Broker: The New Middleware
Chapter 13 - Using SQL Server 2005 Notification Services
Chapter 14 - Developing Desktop Applications
Chapter 15 - Developing Applications
Chapter 16 - Using SQL Server 2005 Integration Services
Chapter 17 - Basic OLAP
Chapter 18 - Advanced OLAP
Chapter 19 - OLAP Application Development
Chapter 20 - Extending Your Database System with Data Mining
Chapter 21 - Reporting Services