Most helpful positive review
7 of 8 people found the following review helpful
Helpful but needs improvement
on April 12, 2007
In SQL Server 2005 Stored Procedure Programming, Dejan underic describes practical uses of T-SQL stored procedures well beyond the level of coverage reached by most other books dealing with SQL Server 2005, including the book on T_SQL programming by Itzik Ben-Gan, et al. Microsoft's documentation, while thorough, is useful mainly to provide reminders when one already knows the the structure.
underic describes some of the interactions between SQL Server 2005 and Visual Studio languages, including of course the SQL Server 2005 techniques for using these languages to write stored procedures, but also showing how to use Visual Studio 2005 as a debugger for stored procedures written in T-SQL.
It would probably have been helpful for many readers had underic described the main access classes that the Visual Studio languages provide to reach SQL Server, that is, the SqlConnection, SqlCommand, SqlParameter and SqlDataReader classes. This topic is missing or barely mentioned in every current book on SQL Server and the .NET and Visual Studio technologies.
It would also been of use to many readers had underic shown examples utilizing some of the key improvements in SQL Server 2005, for example generating lightweight cursors on table variables and implementing messaging. Both are likely to involve stored procedures. A messaging discussion almost starts in the final chapter, where underic seems to be running out of steam.
Overall, underic has written an informative and helpful book that substantially augments information available from other books and from Microsoft documentation.