Inside Microsoft SQL Server 2008: T-SQL Programming (Pro-Developer) |  | Authors: Itzik Ben-Gan, Dejan Sarka, Roger Wolter, Greg Low, Ed Katibah, Isaac Kunen
Publisher: Microsoft Press
Category: Book
List Price: $49.99
Buy New: $26.13
as of 7/30/2010 03:42 CDT details
You Save: $23.86 (48%)
New (26) Used (10) from $26.13
Seller: us-saver
Rating:  2 reviews
Sales Rank: 14809
Media: Paperback
Edition: 1
Pages: 832
Number Of Items: 1
Shipping Weight (lbs): 3.5
Dimensions (in): 8.9 x 7.4 x 2.1
ISBN: 0735626022
Dewey Decimal Number: 005.2768
EAN: 9780735626027
ASIN: 0735626022
Publication Date: September 23, 2009
Availability: Usually ships in 1-2 business days
| |
| Features:
| • | ISBN13: 9780735626027 | | • | Condition: New | | • | Notes: BUY WITH CONFIDENCE, Over one million books sold! 98% Positive feedback. Compare our books, prices and service to the competition. 100% Satisfaction Guaranteed |
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language—solving complex problems with real-world solutions. Discover how to: - Work with T-SQL and CLR user-defined functions, stored procedures, and triggers.
- Handle transactions, concurrency, and error handling.
- Efficiently use temporary objects, including temporary tables, table variables, and table expressions.
- Evaluate when to use set-based programming techniques and when to use cursors.
- Work with dynamic SQL in an efficient and secure manner.
- Treat date- and time-related data in a robust manner.
- Develop CLR user-defined types and learn about temporal support in the relational model.
- Use XML and XQuery and implement a dynamic schema solution.
- Work with spatial data using the new geometry and geography types and spatial indexes.
- Track access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture.
- Use Service Broker for controlled asynchronous processing in database applications.
All the book’s code samples will be available for download from the companion Web site.
|
| Customer Reviews:
Outstanding Book Covering T-SQL Programming w/ SQL Server 2008 April 9, 2010
Daniel McKinnon (Tewksbury, MA USA)
8 out of 8 found this review helpful
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
One of the best books ever November 11, 2009
Q. Bao
1 out of 8 found this review helpful
Just like all the other books by Itzik Ben-Gan, this book is one of the best SQL books ever published.
|
|
|
