Programming Books C Java PHP Python Learn more Browse Programming Books
Inside Microsoft SQL Server 2008 T-SQL Programming and over one million other books are available for Amazon Kindle. Learn more
  • List Price: $49.99
  • Save: $28.49 (57%)
Rented from apex_media
To Rent, select Shipping State from options above
Due Date: Dec 19, 2014
FREE return shipping at the end of the semester. Access codes and supplements are not guaranteed with rentals.
FREE Shipping on orders over $35.
Used: Good | Details
Sold by apex_media
Condition: Used: Good
Comment: Ships direct from Amazon! Qualifies for Prime Shipping and FREE standard shipping for orders over $25. Overnight and 2 day shipping available!
Access codes and supplements are not guaranteed with used items.
Add to Cart
Qty:1
  • List Price: $49.99
  • Save: $17.46 (35%)
FREE Shipping on orders over $35.
Only 4 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $13.14
Gift Card.
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

Inside Microsoft SQL Server 2008 T-SQL Programming (Developer Reference) Paperback – October 3, 2009

ISBN-13: 978-0735626027 ISBN-10: 0735626022 Edition: 1st

Buy New
Price: $32.53
Rent
Price: $21.50
8 New from $32.53 12 Used from $24.65
Rent from Amazon Price New from Used from
eTextbook
"Please retry"
Paperback
"Please retry"
$21.50
$32.53
$32.53 $24.65

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



Frequently Bought Together

Inside Microsoft SQL Server 2008 T-SQL Programming (Developer Reference) + Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference)
Price for both: $62.90

Buy the selected items together

NO_CONTENT_IN_FEATURE

Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

  • Series: Developer Reference
  • Paperback: 832 pages
  • Publisher: Microsoft Press; 1 edition (October 3, 2009)
  • Language: English
  • ISBN-10: 0735626022
  • ISBN-13: 978-0735626027
  • Product Dimensions: 1.9 x 7.5 x 9.2 inches
  • Shipping Weight: 3.5 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (13 customer reviews)
  • Amazon Best Sellers Rank: #401,738 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Dejan Sarka is MCT and MCDBA certified and a Microsoft MVP for SQL Server. He teaches and consults for Solid Quality Mentors, speaks at TechEd and PASS, and develops OLTP, OLAP, and data mining solutions.


More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.2 out of 5 stars
5 star
9
4 star
2
3 star
0
2 star
0
1 star
2
See all 13 customer reviews
I would recommend this book to anyone looking for a great reference book on SQL programming.
Sudheer K. Maharana
The book shows provides guidance on where each of these new technologies is best used, and then goes on to show how to implement each technology.
Cecil T. Champenois Jr.
I recommend this book along with Kalen Delaney's SQL Server 2008 Internals because they complement each other amazingly.
Andre Guerreiro

Most Helpful Customer Reviews

14 of 16 people found the following review helpful By Dan McKinnon VINE VOICE on April 9, 2010
Format: Paperback
Being primarily a database and web developer, I feel more than experienced enough to review 'Inside Microsoft SQL Server 2008: T-SQL Programming' by Itzik Ben-Gan and others and I feel more and easily able to give this ***** and highly recommend this text. All the basics are covered in this 800 page book. It's not a teaching book that will give you all the ins and outs of database design and use, but it will show you what the major points of using SQL Server 2008 are, and how to get the most out of them.

Major topics covered are Views, User-Defined Functions, Stored Procedures, Triggers, Transactions & Concurrency, Error Handling, Temporary Tables/Table Variables, Cursors, Dynamic SQL, Date/Time usage, CLR User-Defined Types, Temporal Support, XML & XQuery usage, Spatial Data, Tracking Access and Changes, and finally Service Broker discussion.

The parts of the book that I enjoyed most were the last 6 chapters, as discussion on CLR usage, Spatial Data, and the like are limited in most other SQL Server books. I especially loved the chapter on Spatial data, a very important subject that has much, much greater support than years in the past.

If you are a SQL Server developer or admin, you owe it to yourself to take a hard look at this great book. It is written fantastic and is a great resource that I found useful from the moment I picked it up.

***** HIGHLY RECOMMENDED
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 5 people found the following review helpful By Andre Guerreiro on June 18, 2011
Format: Paperback Verified Purchase
I can't praise this book enough.
This is one of those books that keeps you interested like a good best-selling novel because it's so well written, almost in a conversational way. The author seems pationate about the technologies being shown and he doesn't try to confuse the readers by using a vocabulary which is difficult to understand like many other technical books.

Each chapter is filled with real world code examples and you can download the sample database used in the book's website. I find the examples to be satisfyingly useful and a lot of them helped me to think of better ways to optimize my code.
This book also served as a wonderful reference when I was studying for my MCITP exam.

To sum it all, this is probably the best book about T-SQL I've read because it's easy to understand and presents many useful techniques and explanations. It's not for the beginner though. To those I recommend the first book in the series: "T-SQL Querying" by the same author.

I recommend this book along with Kalen Delaney's SQL Server 2008 Internals because they complement each other amazingly.
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 Cecil T. Champenois Jr. on October 27, 2010
Format: Paperback
I have used SQL Server since the 6.5/7.0 days and thought I knew enough to get by. I had various experiences with SQL Server 2000/2005, and then did not immediately use SQL Server 2008 until the Spring of 2010; I took a T-SQL CLASS using SQL Server 2008 at Mt. San Antonio College in Walnut, California. I learned a great deal that I did not previously know from Professor Shui-lien Huang, a very excellent teacher.

You can work with SQL Server, and unless you have the opportunity to have many challenges to stretch your skills, you may seemingly work in a silo and never learn all of it, which is a good reason to buy this book: "Inside Microsoft SQL Server 2008: T-SQL Programming". I am glad I had the T-SQL class before reading this book.

This book contains the typical coverage for a standard T-SQL statement, and then User-Defined Functions (UDFs), Triggers, Stored Procedures, Views, etc., but also some new things. For example, extending SQL Server by using CLR (Common Language Runtime) user defined types, the use of XML, dynamic SQL, and Service Broker for reliable, asynchronous processing, and Spatial Data (i.e. geodata).
On the subject of Spatial Data in Chapter 14, Microsoft has brought forth new data types, operators, and indexes to the database. Microsoft introduces the core spatial concepts and provides key programming constructs to successfully navigate this new feature in SQL Server 2008. There are 70 pages covering Spatial Data. Obviously, this is a heavy topic.

Because of auditing and compliance requirements, the issue of tracking access and changes to data has become much more important.
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
1 of 1 people found the following review helpful By Daniel Haro on July 11, 2013
Format: Paperback Verified Purchase
This is a verily good book. I would give it four star but this particular book kind of leaves something to be desired when it comes to theory which in this case is very important. On the other hand there is much that can be learned from this book and there are some great and challenging example problems that come with it.
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
1 of 1 people found the following review helpful By Marc Livingston on March 2, 2013
Format: Paperback Verified Purchase
I'm not expert in SQL Server or T-SQL. This book seems to have everything I need to develop the databases I'm designing.
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
2 of 3 people found the following review helpful By Mitchel J. Haas on April 6, 2011
Format: Paperback Verified Purchase
Covers pretty much everything a developer will need to know, plus some. Even if you're very good in ANSI sql, you'll probably want to start out with the author's other book 'T-SQL Fundamentals' which prepares you very good for this book.
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
Format: Paperback
I get this book from my colleague for Spring break 2012 reading. Itzik Ben-Gan and five other authors put together a very powerful learning book for any .NET developer.
This well written book helps readers learn many areas of T-SQL programming like cursors, dynamic SQL, spatial data, tracking access and changes to data, service broker. The areas that I mentioned are rarely found in any MS SQL Server books. Another topic that is very interesting and caught me in surprise is the SQL Injection on Chapter 9 page 362.
I would recommend this book to any developer at all skill levels as:
1. The book covers the most useful and common technical areas for anyone who works with MS SQL Server 2008 in daily basis,
2. The authors explain and give examples for every topics with a simple and straight-forward language.
Over all, I rate this book 5/5 stars.
Noted that my book is 2010 edition.
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

Customer Images

Search