Programming Books C Java PHP Python Learn more Browse Programming Books
SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach and over one million other books are available for Amazon Kindle. Learn more
Qty:1
  • List Price: $59.99
  • Save: $19.55 (33%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
FREE Shipping on orders over $35.
Condition: Used: Like New
Comment: Used, but looks brand new. Only very slight signs of use. Cover and binding are undamaged, and pages are crisp and unmarked. Unbeatable customer service, and we usually ship the same or next day. Over one million satisfied customers!
Access codes and supplements are not guaranteed with used items.
Add to Cart
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach (Expert's Voice) Paperback – December 12, 2005

ISBN-13: 978-1590595701 ISBN-10: 159059570X Edition: 1st

Buy New
Price: $40.44
31 New from $12.80 30 Used from $0.49
Amazon Price New from Used from
eTextbook
"Please retry"
Paperback
"Please retry"
$40.44
$12.80 $0.49

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student



Frequently Bought Together

SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach (Expert's Voice) + Inside Microsoft SQL Server 2005: T-SQL Programming (Developer Reference) + Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)
Price for all three: $106.06

Some of these items ship sooner than the others.

Buy the selected items together

NO_CONTENT_IN_FEATURE

Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now

Product Details

  • Series: Expert's Voice
  • Paperback: 768 pages
  • Publisher: Apress; 1 edition (December 12, 2005)
  • Language: English
  • ISBN-10: 159059570X
  • ISBN-13: 978-1590595701
  • Product Dimensions: 1.5 x 7 x 9.1 inches
  • Shipping Weight: 2.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (20 customer reviews)
  • Amazon Best Sellers Rank: #1,383,556 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Joseph Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail, and the real estate industry. Prior to joining SQLskills, he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting, and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development, and high-availability. In 2006 Joe earned the �Microsoft Certified Master: SQL Server 2005� certification; and in 2008, he earned the �Microsoft Certified Master: SQL Server 2008� certification. In 2009 he took over responsibility for the SQL Server Microsoft Certified Master program and held that post until 2011. He is the author of a few books and white papers, including most recently, �SQL Server 2008 Transact-SQL Recipes� (Apress, 2008). Joe's blog is at www.SQLskills.com/blogs/joe, and he can be reached at joe@SQLskills.com.

More About the Author

Joe Sack is the owner of Sack Consulting LLC (www.SackHQ.com). With over 16 years of experience in the industry, Joe is a consultant, author, speaker, SQL MVP, and SQL Server Microsoft Certified Master specializing in performance tuning, scalability, high availability and disaster recovery.

Customer Reviews

4.6 out of 5 stars
5 star
13
4 star
6
3 star
1
2 star
0
1 star
0
See all 20 customer reviews
Very good job.
Vort3xxX
This is the book that I consult most often, when there is something I want to accomplish quickly and easily.
Glenn Berry
Joseph Sack goes provides numerous useful examples of how to use the new features of SQL Server 2005.
William Addington

Most Helpful Customer Reviews

68 of 69 people found the following review helpful By William Addington on January 20, 2006
Format: Paperback
Sometimes we see books on a new version of software that haven't soaked in the new technology -- you can tell the book was written with a mindset stuck in the old version. Not true here. Joseph Sack goes provides numerous useful examples of how to use the new features of SQL Server 2005. If he missed one I have yet to find it.

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 ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 9 people found the following review helpful By Adam Machanic on January 23, 2006
Format: Paperback
This book's "recipe" format makes it great for quickly figuring out how to do something. The examples are straight to the point--so don't expect really deep insights. Rather, this is the kind of book you'll want to keep on your desk for those times you might get stuck on a task. Flip to the right page and there you have it.

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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
13 of 15 people found the following review helpful By Craig Bolon on August 19, 2006
Format: Paperback Verified Purchase
Sack's book is of unusually high quality for its publisher, Apress, in providing plainspoken and consistently organized descriptions of its topic. Despite limited coverage of SQL Server 2005, it has proven very handy. As of summer, 2006, it really has no competition in providing practical advice about using SQL Server 2005 other than the Books Online documents from Microsoft.

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.
2 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 10 people found the following review helpful By T. Anderson TOP 1000 REVIEWERVINE VOICE on February 26, 2006
Format: Paperback
See the other review to see what is covered in this book. It is an excellent book and thoroughly covers everything it includes. It covers everything you need to know about the Data Manipulation Language (DML)

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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 6 people found the following review helpful By .Net learner on May 5, 2006
Format: Paperback
This book is a very good book for updating skills from sql server 2000 to 2005. There is a lot of information in this book
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 4 people found the following review helpful By Vort3xxX on March 14, 2007
Format: Paperback
This book has a lot of useful stuff in it for beginning t-sql authors. I paid full price for it when it came out, and I feel like I got my money's worth, which is pretty rare. I tend to hit this book more than my other tsql books at work, even though its billed as a recipie book instead of a reference book. Very good job.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
4 of 6 people found the following review helpful By RVSSUG on July 1, 2006
Format: Paperback
This book review was submitted by a Roanoke Valley SQL Server Users Group member as part of the Book Review Program.

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!

Paul Glassbrenner
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews

Search

What Other Items Do Customers Buy After Viewing This Item?