Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

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

4.6 out of 5 stars 20 customer reviews
ISBN-13: 978-1590595701
ISBN-10: 159059570X
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$4.60 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$59.99 On clicking this link, a new layer will be open
More Buying Choices
26 New from $18.02 35 Used from $0.01
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Get a FREE Amazon Echo with The Princeton Review
Subscribe to Homework Help. Connect to an expert tutor and get the help you need. Learn more
$59.99 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Frequently Bought Together

  • SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach (Expert's Voice)
  • +
  • Inside Microsoft SQL Server 2005: T-SQL Querying (Developer Reference)
Total price: $104.98
Buy the selected items together

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.
NO_CONTENT_IN_FEATURE

The latest book club pick from Oprah
"The Underground Railroad" by Colson Whitehead is a magnificent novel chronicling a young slave's adventures as she makes a desperate bid for freedom in the antebellum South. See more

Product Details

  • Series: Expert's Voice
  • Paperback: 768 pages
  • Publisher: Apress; 1st ed. edition (December 12, 2005)
  • Language: English
  • ISBN-10: 159059570X
  • ISBN-13: 978-1590595701
  • Product Dimensions: 7.5 x 1.7 x 9.2 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: #2,246,227 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

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 68 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 9 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 13 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 9 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach (Expert's Voice)
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway
This item: SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach (Expert's Voice)
Pages with Related Products. See and discover other items: computer programs