Pro T-SQL 2008 Programmer's Guide

1. Front Matter

   Pages i-xxviii

   PDF

2. Foundations of T-SQL

   Pages 1-21

3. T-SQL 2008 New Features

   Pages 23-60

4. Tools of the Trade

   Pages 61-79

5. Procedural Code and CASE Expressions

   Pages 81-115

6. User-Defined Functions

   Pages 117-150

7. Stored Procedures

   Pages 151-185

8. Triggers

   Pages 187-218

9. Encryption

   Pages 219-246

10. Common Table Expressions and Windowing Functions

    Pages 247-272

11. Integrated Full-Text Search

    Pages 273-298

12. XML

    Pages 299-339

13. XQuery and XPath

    Pages 341-386

14. Catalog Views and Dynamic Management Views

    Pages 387-405

15. SQL CLR Programming

    Pages 407-449

16. .NET Client Programming

    Pages 451-494

17. Data Services

    Pages 495-523

18. New T-SQL Features

    Pages 525-551

19. Error Handling and Dynamic SQL

    Pages 553-571

20. Performance Tuning

    Pages 573-602

Discussing new and existing features, SQL Server designer and administrator Michael Coles takes you on an expert guided tour of Transact–SQL functionality in SQL Server 2008 in his book, Pro T–SQL 2008 Programmer's Guide. Fully functioning examples and downloadable source code bring Coles' technically accurate and engaging treatment of Transact–SQL into your own hands. Step–by–step explanations ensure clarity, and an advocacy of best–practices will steer you down the road to success.

Pro T–SQL 2008 Programmer's Guide is every developer's key to making full use of SQL Server 2008's powerful, built–in Transact–SQL language. Transact–SQL is the language developers and DBAs use to interact with SQL Server. It's used for everything from querying data, to writing stored procedures, to managing the database. New features in SQL Server 2008 include a spatial data type, SQLCLR integration, the MERGE statement, a dramatically improved and market–leading XML feature set, and support for encryption—all of which are covered in this book

• .NET
• Microsoft SQL Server
• SQL
• SQL Server 2000
• SQL Server 2008
• Transact-SQL
• database
• performance

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.

Policies and ethics