To get the free app, enter your mobile phone number.
SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach (Expert's Voice) 1st ed. Edition
Use the Amazon App to scan ISBNs and compare prices.
Frequently Bought Together
Customers Who Bought This Item Also Bought
Top Customer Reviews
Lost in the hoopla of CLR integration for example, is the new feature likely to fundamentally change how we approach SQL application architecture: the Service Broker. Joseph provides 15 separate "how it works" examples of using the service broker including "Enabling Transport Security", "Enabling Dialog Security", "Creating Routes and Remote Service Bindings" and "Event Notifications.Read more ›
There's also a "how it works" section for every recipe that briefly describes what's going on. If you're in more of a cover-to-cover reading mode, that should help enhance the book's readability.
Sack's book has three practical limitations. It covers mainly data manipulation with less attention to data definition. In particular, it does not explain how to use the SQL Server Management Studio or the similar services imbedded in Visual Studio 2005, which have become the primary tools for data definition in many shops.
The book does not provide concise but full descriptions of many elements of T-SQL syntax. Instead it concentrates on "basic" or "simplified" syntax. For full descriptions one must often wade into Microsoft's Books Online documents.
Sack's book does not explain how to use ADO.NET classes to execute SQL Server commands. Today they have become the primary interface for many software applications, and they can present complex issues of their own.
The only downside I found was that it doesn't cover the Data Definition Language (DDL) much at all, which was somewhat disappointing.
It's a great book to have by your side.
and it is incredible that the author makes it so easy to go through unlike some of the other books. This should be
everyones first sql server 2005 since it tackles alot of
new features with working examples. There is very little
bad I can say about this and probably a while before another good book like this will come out.
This book covers not only tsql but new features as well as
the major sql server 2005administrative techniques.
It also coveres some reporting.
You still need a book for ssis, sql assembiles ,udf, reporting, olap.
Reviewed by Paul Glassbrenner
I found the book to be an easy read - containing insightful solutions to practical everyday problems that DBA or Developer may encounter. The solutions or recipes, as the author calls them, are well written. He explains, for example, what each SQL Server function will do and how and why it works. The author also goes into detail on Indexing, Triggers, and Stored Procedures, and frankly after reading this book, it has improved my usage of them. This is a book that will make a great reference book for anyone just beginning or with advanced experience in Microsoft SQL Server 2005. I would give this book two thumbs up!
Most Recent Customer Reviews
This book packs a lot of information, from beginning to advanced topics. I learned a lot from this book esp. Read morePublished on August 11, 2008 by Gray
Background: Professional developer with 20 years experience of application programming and embedded development who is recently learning SQL / SQL Server. Read morePublished on April 28, 2008 by Kent Harris
This is a great book to keep at arms length. It has many great examples of the T-SQL commands and syntax. Read morePublished on February 10, 2008 by Daniel C. Kline
I think this book is a good addition to your bookshelf but I was hoping for a little more. The price is right and the breadth of topic coverage is fine. Read morePublished on December 12, 2007 by Amazon Customer
This is the book that I consult most often, when there is something I want to accomplish quickly and easily. Read morePublished on October 16, 2007 by Glenn Berry
I picked this book to refresh my T-SQL after spending a year on an Oracle project. It is incredibly annoying at how little differences in PL\SQL and T-SQL can mess up a script! Read morePublished on July 4, 2007 by S. Martin
This book has a lot of tips and tricks to write your queries, I have not read it yet but bunch of my colleagues are using it and benefitting from itPublished on October 29, 2006 by Rahul Agrawal
I'm an original fan of a previous book written by Joe and afterwards began a dialogue with him that I'm happy to say has continued, in part, due to the ability of me as a reader to... Read morePublished on August 15, 2006 by Adam P. Cassidy