Database developers & administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language solving comp... » 

Database developers & 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 & 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 & secure manner; Treat date- and time related data in a robust manner; Develop CLR user defined types & learn about temporal support in the relational model; Use XML & XQuery and implement a dynamic schema solution; Work with spatial data using the new geometry & geography types and spatial indexes; Track access & 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. «