Table of Contents

1. Foundations of T-SQL 2. Tools of the Trade 3. Procedural Code and CASE Expressions 4. User Defined Functions 5. Stored Procedures 6. In-memory Database Programming 7. Triggers 8. Encryption 9. Common Table Expressions 10. Advanced Features 11. Integrated Full-Text Search 12. XML 13. XQuery and XPath 14. Catalog Views and Dynamic Management Views 15. SQL CLR Programming 16. .NET Client Programming 17. Data Services 18. Error Handling and Dynamic SQL 19. Performance Monitoring and Tuning 20. Appendix A 21. Appendix B 22. Appendix C 23. Appendix D

About the Author

Jay Natarajan has more than 15 years of experience in the SQL Server space. Her skills range in both the design and the implementation arenas, having architected and deployed complex solutions for enterprise customers. She joined Microsoft Consulting Services in 2008. She holds a bachelor's degree in mechanical engineering from the University of Madras. Jay currently lives in Atlanta with her husband, Chad, and their son Satya.