Programming SQL Server 2005

A Practical Introduction: ‘Programming SQL Server 2005’

Review by SQL-Server-Performance.Com

Programming SQL Server 2005
By Bill Hamilton.
586 pp. O’Reilly Media, Inc. $49.99.

Find out more about this book, or purchase it, from

If you are a SQL Server 2005 developer, you are probably looking for additional resources about SQL Server 2005 programming.

The important thing about Programming SQL Server 2005 is that you don’t have to have knowledge of SQL Server 2000. You can read this book and start learning SQL Server from the beginning. If you are developer who is looking forward to learning SQL Server, this is a good book to read.

Bill Hamilton is a software architect specializing in designing, developing, and implementing distributed applications using .Net and J2EE technologies. He is the coauthor of ADO.NET in a Nutshell and the author of ADO.NET Cookbook.

This book is geared toward newly added features in SQL Server 2005. It contains superb coverage of programming CLR routines, XML support, native Web services support, and SQL Server Management Objects (SMO). There are also sections about topics such as Notification Services, replication, Reporting Services, and Integration Services.

Full table of contents:

  • Introduction
  • Tools and Utilities
  • T-SQL Enhancements
  • Introduction to Common Language Runtime (CLR) Integration
  • Programming SQL Server CLR Routines
  • .NET Client-Side Programming
  • XML Data
  • Native XML Web Services
  • SQL Server Management Objects (SMO)
  • SQL Server Management Objects (SMO) Instance Classes, Part 1
  • SQL Server Management Objects (SMO) Instance Classes, Part 2
  • SQL Server Management Objects (SMO) Utility Classes
  • Programming Windows Management Instrumentation (WMI)
  • SQL Server Reporting Services (SSRS)
  • SQL Server Integration Services (SSIS)
  • SQL Server Agent
  • Service Broker
  • Notification Services
  • Replication
  • SQL Server Analysis Services (SSAS)
  • SQL Server Mobile Edition

Another important fact about this book is that the examples used are not from MSDN.

Most of the examples in this book are written in C# code and Visual Studio 2005. In addition, you will need Windows 2000 SP4 or later and any version of SQL Server 2005.

This book is Safari enabled, which means it is available online through the O’Reilly Network Safari Bookshelf. Safari offers a solution that’s better than e-books. You will find code samples, chapters to download, and quick answers to your questions.

Purchase the book and experience the world of SQL Server 2005.


Leave a comment

Your email address will not be published.