SQLAuthority News – Book Review – Programming SQL Server 2005 [ILLUSTRATED]

Programming SQL Server 2005 [ILLUSTRATED] (Paperback)
by Bill Hamilton (Author)

Link to Amazon

User does not have to be experience SQL Server 2005 programmer to use this book; as it is designed for users of all levels. This book also suggests that user does not have to be experienced with SQL Server 2000. However, I disagree with that. This book only covers new features of SQL Server 2005. Understanding of fundamental relational database concepts is helpful to digest and accept the concepts introduced in this book.

This book covers following perspective of SQL Server 2005 new features.

• Tools and utilities
• Data types
• T-SQL enhancements
• Programmability enhancements
• XML support
• Native XML web services
• SQL Management Objects
• SQL Server Integration Services
• SQL Server Reporting Services
• SQL Server Notification Services
• SQL Server Service Broker
• Replication Management Objects
• SQL Server Agent
• SQL Server Mobile Edition

The code used in the book is available for download on O’Reilly web site. I always like this as I really do not like to retype examples from the book. Most of the examples of this book use C# code and Visual Studio 2005. One good thing about this book is it uses AdventureWorks sample database, I always prefer book which uses samples database which comes along the SQL Server, this makes it easily useable by developer. This book is also Safari enabled.

Appendix of this book has in depth explanation of the ADO.NET 2.0, which can be quite useful to users interested in the topic. There are very few good books which covers this topic such in depth.

Rating: 4 stars

Summary: This book is quite good for new learning; I enjoy reading it and learning new concepts from this book.

Reference : Pinal Dave (https://blog.sqlauthority.com)