FREE Delivery in the UK.
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Inside Microsoft® SQL Ser... has been added to your Basket
FREE Delivery on orders over £10.
Used: Very Good | Details
Sold by the book house
Condition: Used: Very Good
Comment: This item will be picked, packed and shipped by Amazon and is eligible for free delivery within the UK
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Inside Microsoft® SQL ServerTM 2005: T-SQL Programming (Solid Quality Learning) Paperback – 27 May 2006

5.0 out of 5 stars 3 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
"Please retry"
£7.11 £0.01
Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more
£27.99 FREE Delivery in the UK. Only 1 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.
click to open popover

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

To get the free app, enter your mobile phone number.

Product details

  • Paperback: 536 pages
  • Publisher: Microsoft Press; 1 edition (27 May 2006)
  • Language: English
  • ISBN-10: 0735621977
  • ISBN-13: 978-0735621978
  • Product Dimensions: 18.7 x 3.4 x 22.8 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: 707,481 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

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.

Itzik Ben-Gan is a mentor and cofounder of Solid Quality Mentors. A Microsoft MVP for SQL Server since 1999, Ben-Gan teaches and consults internationally on T-SQL querying, programming, and query tuning. He is the coauthor of Inside Microsoft SQL Server: T-SQL Querying and Inside Microsoft SQL Server:T-SQL Programming. He has written numerous articles for SQL Server Magazine and MSDN®, and speaks at industry events such as Microsoft Tech*Ed, DevWeek, PASS, and SQL Server Connections.

Lubor Kollar is group program manager with the SQL Server Customer Advisory Team at Microsoft, working on the most challenging SQL Server deployments worldwide. He has 13+ years of experience with SQL Server development.

Customer Reviews

5.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See all 3 customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
Not only is this an excellent technical reference, it's also an excellent read - offering plenty of food for thought around subjects such as design and application of User Defined Data Types, and the age old discussions of cursor usage. This is a book I will be coming back to repeatidly and is a very good compliment to the T-Sql Tuning book. Each subject area is covered to a good depth, and generally includes the history surrounding the feature and techniques in which it might be applied, resulting in a resource that is valuable both for experienced and new Sql Programmers.
Comment 11 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
Itzik is an internationally renown lecturer, trainer and writer who anyone familiar with SQL Server will immediately recognise.

"Inside SQL Server: T-SQL Programming" is an excellent book, invaluable to both SQL Server DBA or Developer and has something for even the most experienced programmer. This book will help you take full advantage of all the new T-SQL features in SQL 2005.
Comment 11 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
Exactly what I expected.
Comment 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 Helpful Customer Reviews on (beta) 4.3 out of 5 stars 18 reviews
6 of 7 people found the following review helpful
5.0 out of 5 stars Excellent book 3 Jan. 2007
By Amazon Customer - Published on
Format: Paperback Verified Purchase
I've been a SQL Server DBA for each version since 6.5, so with the release of 2005, it was time to make sure that I was up with the new stuff. It's difficult to find a book that has enough technical meat to it without just being a dump of BOL. This book is a winner for me. I really enjoy the pace and depth of the material. For those needing to just refresh their basic knowledge and those that need a good overview of the new features in 2005 (t-SQL related), this is the book for you. It's companion book, t-SQL Querying, make two great additions to anyone's library!
0 of 2 people found the following review helpful
5.0 out of 5 stars Excelent 6 May 2007
By Christiano C. Moraes - Published on
Format: Paperback Verified Purchase
This book is a must-have, even for those who uses other SQL Databases... Totally Amazing!
2 of 5 people found the following review helpful
5.0 out of 5 stars Phd in SQL 17 Jan. 2007
By park alot - Published on
Format: Paperback Verified Purchase
If there were a PHD given for SQL proficiency, Itzik would deserve it.

This is a great book. Provides some good insight and ideas on solving some tough problems. Highly recommend it.
9 of 10 people found the following review helpful
3.0 out of 5 stars Useful but COULD be much better. Needs major editorial intervention. 26 July 2007
By Malleus Maleficarum - Published on
Format: Paperback
You should think of this book as of the second volume of the two-volume set on the 2005-Server SQL. If you get this one, you'll get the other one too; neither tome is self-sufficient; in fact there's a lot of explicit interdependence. This book, Programming, deals with slightly more esoteric features than the first tome, Querying -- although I can't say you must read the first entire volume before touching this one. Both books can be read at the same time (but see what I say about the target reader below).

So, real quick:

1. Target reader: someone with a good grasp of the 2000 Server wishing to learn the new stuff that came with the 2005 server (there's a lot: the 2005 product is _much_ better than the previous: covering new features is probably the only thing that's unequivocally good about this book). This is NOT your first, nor second, nor third book on SQL in general or MS SQL Server in particular. You must have a good grasp of the basics to be able to overcome this book. I say 'overcome' advisedly; more on it below.

2. Content: Data-type subtleties (datetime, xml, CLR user-defined types -- a lot of CLR in this volume); temporary tables, cursors, dynamic SQL, views, user-defined funcs, stored procs, triggers, a bit on transactions, exception handling, a bit on service broker.

3. Very clean technically: no technical errors (and while we're here: I found no typos either).

4. Depth vs breadth: the book is more extensive than deep, although on average it's (inevitably) more in-depth than the first volume. Some reviewers here say it's very deep or difficult -- and difficult is true, although not because of PhD anything. This, unfortunately, brings me to the next point:

5. Writing: ABHORRENT. (Both volumes, Querying, and Programming, in about the same degree). That's why it seems difficult, PhD and so on -- except this difficulty isn't due to, say, conceptual complexity of the subject matter. It's the authors' extreme inability to use the English language to explain things that makes reading this book such a chore. There is also conceptual muddle (unsurprisingly: people write as they think).

Now, experience taught me to forgive literary incapacity to a _technical_ author (to a degree; and I do take notice and, if possible, avoid him in the future). In cases like that I put the blame squarely on the publisher, especially if otherwise I know the publisher to be solid. I have a pile of books from Microsoft Press and I consider them a good publisher, so what's the matter?

Although (strangely) a bit better than the first volume, this book (Programming) is also strewn with unimaginable, fantastic garbage of every possible kind, from grating usage errors to a pervasive lack of unity, coherence, and logical connectedness on the page/paragraph level, to a frequent lack of the overall unity. When I bought this book and read it a bit I was so p-off I almost sent it back (I got as far as getting an RMA from Amazon). I did keep it though. Both of them, actually.

Do I recommend this book? It has been useful to me (especially the UDF section: there's a lot of new stuff, all very handy), so -- with great reservation, and only to the right reader -- yes, kinda. And please check out what else is available (there's tons of books on the 2005 server these days). The Programming book is part of the three-volume update and extension of the server-2000 version by Delaney. Delaney's server-2000 book was extremely useful and quite decently written. I wish they let her write the new version, even though it's now three books instead of one, and I suppose it's difficult for one person to do it all.
37 of 39 people found the following review helpful
5.0 out of 5 stars Serious SQL Programmers need this book 30 Jun. 2006
By Colin Brown - Published on
Format: Paperback
Firstly, this is not a book for beginners or those new to T-SQL, this is targetted more towards intermediate/advanced programmers. If you're new then look at T-SQL Querying.

The level of knowledge and detail that Itzik, Dejan and Roger have and portray in this book is awesome. Do you want to know how SQL Server 2005 internally stores date/time values and what the pitfalls are that you might run into when programming against date/time values (one of the most common problems facing SQL programmers), this book has the answer.

With chapters on Stores Procedures, Transactions, temporary tables, views, the service broker and more.

Each chapter has excellent advice and knowledge and filled with sample code (available online). The book is targetted specifically at SQL Server 2005 and the new ways it handles things, new functions and commands.

My only concern and a slight one at that is that with the amount of information the authors are trying to portray in 500 pages, sometimes the reading is heavy.

An invaluable book for SQL Server 2005 programmers.
Were these reviews helpful? Let us know