We’re pleased to announce that Inside Microsoft SQL Server 2008: T-SQL Programming, by Itzik Ben-Gan, Dejan Sarka, Roger Wolter, Greg Low, Ed Katibah, and Isaac Kunen (Kalen Delaney Series Editor; Solid Quality Mentors) shipped to the printer today (Microsoft Press, 2010; ISBN: 9780735626027; 832 pages)!
This book provides 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. Some of the tasks you’ll learn include:
- 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.
All the book’s code samples will be available for download from the companion Web site.
We’ll post excerpts from the book soon, in the middle of September, when the book is available.