Article Options
Premium Sponsor
Premium Sponsor

 »  Home  »  Data Programming  »  SQL Server  »  Book Review: Murach's SQL Server 2005 For Developers
 »  Home  »  Reviews  »  Book Reviews  »  Book Review: Murach's SQL Server 2005 For Developers
Book Review: Murach's SQL Server 2005 For Developers
by Scott Waletzko | Published  03/11/2007 | SQL Server Book Reviews | Rating:
Scott Waletzko

Scott Waletzko has been an Information Technology professional and Windows / Web programmer since 1995, with experience in software development and architecture, network design and administration, and project and team management. Currently he is the the Senior Vice President of Technology at Intellisponse, as well as the President of Skystone Software / Echosoft Design Studios, LLC.

At Intellisponse, Scott is responsible for architecture and implementation of the company flagship software called Synapse, the first full-featured Web survey authoring tool for market research, enabling researchers to design, publish, and manage full-featured and logically complex questionnaires to the Internet without programmer interaction.

As president of Skystone Software / Echosoft Design Studios, LLC, Scott is developing a unique Web site content management system named Tempest, which will drive myBard.com and provide comprehensive Web site hosting and content management to anyone with a Web browser.

 

View all articles by Scott Waletzko...
Overview

SQL Server 2005 for Developers, written by Bryan Syverson and Joel Murach, is a comprehensive tutorial designed for developers that provides a comprehensive window into the world of the SQL Server 2005 database. This book is not intended for consumption by database administrators and no assumption is made by the authors as to what sort of developers are reading the book (although C# and VB.NET code is used in examples) ; the topics covered are simply those that would be useful to a developer rather than to a DBA. This is an especially useful resource to today's developers because of the expectations that developers be skilled in many more areas of development than previously required.

The first part of the book introduces SQL syntax and functions to the reader, the second part covers database design (including best practices and DDL), and the third portion gets into advanced SQL features and features specific to SQL Server 2005 (like Xml data types and CLR integration). Topics are covered in a very logical order, leaving the reader with little doubt that they have the necessary information required to move on to the next topic.

In classic Murach style, every two pages in the book repeats the contents twice; the left-hand page is a detailed description of the concept being covered written in a conversational tone, and the right-hand page contains a recap of this discussion in bulleted-form, with screenshots and / or code samples. This layout is ideal for both novice and expert readers alike; beginners learn faster when a concept is restated / repeated, and experts can skim through the right-hand pages looking for content that is new to them.

Because the book is designed for developers and not DBAs, there are many topics intentionally not covered. In these cases, the authors usually mention the concept briefly and then explain that it is most commonly used by DBAs and therefore will not be discussed further. Conspicuously absent, however, was any mention of the cryptographics functions in SQL Server 2005, which would seem to be important enough for at least a mention, especially for developers.

Sponsored Links