Programming SQL Server 2005

Bill Hamilton

Publisher O'Reilly
ISBN 9780596004798
RRP £35
Reviewed by Uma Kanagaratnam MBCS
Score 9 out of 10

SQLServer This book is designed for users of all levels as SQL server 2005 is very different from SQL server 2000 because of its new features. The author introduces all aspects of programming SQL server 2005 and its new functionalities. It is therefore not a prerequisite to have programming knowledge of SQL server 2000.

The chapters are well organised and kick starts with an overview of the new and enhanced tools and command line utilities. The mid-section looks at SQL server management objects in great detail. SQL Server Management Objects (SMO) is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server it surpasses the database management functionality of SQL DMO used to manage SQL server 2000.

Following on from SMO, the author introduces Service Broker, a technology for building database-intensive applications that are scalable. There is the Notification Services which can generate and send messages to a wide variety of devices.

The examples are written in C# code and visual studio 2005; the codes are available for download from the publisher's website. The examples are explained and where possible screen shots are provided. The book layout itself is interesting with a specific convention used, ie new terms are indicated by the use of italics. Furthermore the Safari® icon indicates that the book is available online through the publisher's virtual library.

The book is easy to read and I would recommend it as a useful resource. The author has highlighted sections where he has made a suggestion or provided a general comment which is valuable.
Score: 9/10.

More information: O'Reilly