Excellent reference on programming SQL Server. Very broad coverage.

View Review Details

Book:		Programming SQL Server 2005
Subject:		Excellent reference on programming SQL Server. Very broad coverage.
Date:		2007-11-13 11:42:15
From:		jdruin

Rating: This book covers nearly all topics on SQL Server programming. It begins with the differences between the SQL Server 2000 and 2005. 2005 has new tools (SSMS, Profiler, BIDS, command line), data types, xml support, and .NET integration. Chapters 1-4 go over these topics in turn. The next series shows the reader how to program using the Visual Studio IDE, deal with XML programming, and web services (Chaptes 5-8). Chapters 9-14 are on programming SQL Server management and reporting tools plus interfacing with the objects exposed by SQL Server through .NET. The remaining chapters are on programming services: SS agent, intergrations services, broker, notification services, and analysis services. The book is quite thourough and has a large number of examples, code, and pictures for each topic. The book is generally easy to read and well indexed. Programmers will feel right at home with all the extra help provided by the book. Folks who have no programming experience of any kind will likely struggle with the information in the book. Basic SQL is shown but not explained. It is clear the book is meant for people programming and/or automating SQL Server topics rather than just running basic queries. That being said, the chapter on XML was very helpful even from just a querying point of view. Using XML as a bulk load technique was particuarly useful and turned out to be very fast when loading text based data to the server. Querying XML data was covered by using both FOR XML statements and using XQuery type statements. The chapter sovering SSIS was also very useful as there is not much material on SSIS yet. This book is a must have for SQL Server DBAs, programmers, and professionals.