Inside Microsoft® SQL Server® 2008: T-SQL Programming (Pro-Developer)

Itzik Ben-Gan

ISBN 10: 0735626022 / ISBN 13: 9780735626027

Published by Microsoft Press, 2009

About this Item

Gut/Very good: Buch bzw. Schutzumschlag mit wenigen Gebrauchsspuren an Einband, Schutzumschlag oder Seiten. / Describes a book or dust jacket that does show some signs of wear on either the binding, dust jacket or pages. Seller Inventory # M00735626022-V

Bibliographic Details

Title: Inside Microsoft® SQL Server® 2008: T-SQL ...

Publisher: Microsoft Press

Publication Date: 2009

Binding: Soft cover

Condition: very good

About this title

Synopsis:

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.

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.