Michael Coles has more than a decade's experience designing and administering SQL Server databases. A prolific writer of articles on all aspects of SQL Server, particularly on the expert use of T-SQL, he holds MCDBA and MCP certifications. He graduated magna cum laude with a bachelor of science degree in information technology from American Intercontinental University in Georgia. A member of the United States Army Reserve, he was activated for two years following 9/11.

• The Role of T-SQL.- Tools of the Trade.- T-SQL for SQL Server 2000 Programmers.- Expand coverage, add new statements like MERGE.- New data types: Spatial data, vardecimal, etc.- Control-of-Flow and CASE Expressions.- User-Defined Functions.- Expand coverage, table parameters, etc.- Stored Procedures.- Expand coverage, table parameters, etc.- Parameter sniffing.- Triggers.- Expand coverage.- T-SQL Encryption.- Expand coverage, include new encryption functions.- Expand discussion of SQLCLR encryption.- Error Handling and Debugging.- Dynamic SQL.- XML.- XQuery and XPath.- Expanded discussion of XQuery and XPath.- SQL Metadata.- Additional catalog view information.- Additional coverage of system functions.- SQLCLR Programming.- .NET Client Programming.- HTTP Endpoints.- Cursors * new *.- Full-Text Search * new *.- Query Optimization and Performance Enhancement * new *.- SQL Keywords.- XQuery Data Types.- XQuery Terms.- Selected T-SQL Source Code Listings.- .NET Source Code Listings.