Book Review: Beginning Sql Server 2005 Programming

SQL Books dont get better than this for ASP.NET companies such as ourselves!

As our company expands, I needed a good reference for old and new developers alike. This book ensures it can handle experienced programmers and at the same time appeal to first timers aswell.

As you may know, one of my main gripes from new staff is the lack of training colleges and universities give. SQL is a prime example of this. Say T-Enterprise employ 3 graduates, I can gurantee two of them would not even know how to login to an SQL server never mind building complex ASP.NET applications using it!

Couple in the fact that we do not have the time to train staff in the most basic of operations and then this book is a godsend!

No IT firm should be without this!

On a lighter note - the author, Robert Viera, is extremely casual in his teachings however most of all, his smug face on the cover gives the impression that you are learning from the best!

Book Description
* After a quick primer on database design basics and the SQL query language (for those programmers who may be building their first database application), this book provides an overview of SQL Server itself, which has been dramatically redesigned with the 2005 release
* Once readers have grasped the fundamentals of database design and SQL concepts, they will then learn how to implement those concepts with Microsoft SQL Server 2005
* Addresses creating and changing tables, managing keys, database normalization, writing scripts, working with stored procedures, programming with XML, and using SQL Server reporting and data transformation services
* The companion Web site provides all of the code found in the book

Synopsis
After a quick primer on database design basics and the SQL query language (for those programmers who may be building their first database application), this book provides an overview of SQL Server itself, which has been dramatically redesigned with the 2005 release. Once readers have grasped the fundamentals of database design and SQL concepts, they will then learn how to implement those concepts with Microsoft SQL Server 2005. Addresses creating and changing tables, managing keys, database normalization, writing scripts, working with stored procedures, programming with XML, and using SQL Server reporting and data transformation services. The companion Web site provides all of the code found in the book.