- 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
Inside Microsoft® SQL ServerTM 2005: T-SQL Programming (Solid Quality Learning) Paperback – 27 May 2006
- Choose from over 13,000 locations across the UK
- Prime members get unlimited deliveries at no additional cost
- Find your preferred location and add it to your address book
- Dispatch to this address when you check out
There is a newer edition of this item:
Customers Who Bought This Item Also Bought
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.
To get the free app, enter your mobile phone number.
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.
Top Customer Reviews
"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.
Most Helpful Customer Reviews on Amazon.com (beta)
This is a great book. Provides some good insight and ideas on solving some tough problems. Highly recommend it.
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.
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.
Look for similar items by category
- Books > Computing & Internet > Computer Science > Information Systems
- Books > Computing & Internet > Databases > Applications
- Books > Computing & Internet > Databases > Beginners & Introduction
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Computing & Internet > Databases > SQL
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Introduction
- Books > Computing & Internet > Programming > Introduction to Programming
- Books > Computing & Internet > Programming > Microsoft Windows
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft