Welcome!

Java Authors: Frank Huerta, Adrian Bridgwater, Pieter Van Heck, Esmeralda Swartz, Gary Kaiser

Related Topics: .NET, Java

.NET: Article

.NET Book Review: Murach's SQL Server 2005 for Developers

If you're new to SQL Server 2005 you'll gain a lot from this book

This book is an update of an earlier version that was written for SQL Server 2000. It employs the Murach approach of dual pages that repeat and enhance the concepts being presented on each page. If you're new to SQL Server 2005 you'll gain a lot from this book. It has three goals: to teach T-SQL (Transact SQL), introduce you to the new .NET CLR integration, and introduce you to the new graphical user interface called SQL Server Management Studio that replaces the enterprise manager and query analyzer that were part of the SQL Server 2000 package of software tools. The authors do a really good job of covering the basics of this new interface. They also provide handy appendices to show you how to install the software required by this book as well as how to install the sample databases and files.

If you've worked with T-SQL in SQL Server 2000, you'll see that few new features have been added to T-SQL. The new things are, however, very helpful. They include ranking functions and common table expressions. The common table expression is a powerful tool that provides a user with the ability to create a temporary view within his or her T-SQL query. In fact, the combination of the row number function and a common table expression can allow the developer to delete duplicate records in a database table, which was quite difficult to do in earlier versions of SQL Server.

More Stories By Steven Mandel

Steven Mandel has worked in the IT industry for over 15 years designing databases using Microsoft Access and SQL Server. He has developed Web and Windows applications using VB.NET and has written numerous articles and reviews about ASP.NET and VB.NET.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.