Dedication

To all children traumatized by the horrors of war and War Child’s efforts to help children be children again

Brief Table of Contents

Copyright

Brief Table of Contents

Table of Contents

List of Figures

List of Tables

List of Listings

MVP contributors and their chapters

Preface

Acknowledgments

About War Child

About this Book

About SQL Server MVPs

1. Database design and architecture

Chapter 1. Louis and Paul’s 10 key relational database design ideas

Chapter 2. SQL Server tools for maintaining data integrity

Chapter 3. Finding functional dependencies

2. Database Development

Chapter 4. Set-based iteration, the third alternative

Chapter 5. Gaps and islands

Chapter 6. Error handling in SQL Server and applications

Chapter 7. Pulling apart the FROM clause

Chapter 8. What makes a bulk insert a minimally logged operation?

Chapter 9. Avoiding three common query mistakes

Chapter 10. Introduction to XQuery on SQL Server

Chapter 11. SQL Server XML frequently asked questions

Chapter 12. Using XML to transport relational data

Chapter 13. Full-text searching

Chapter 14. Simil: an algorithm to look for similar strings

Chapter 15. LINQ to SQL and ADO.NET Entity Framework

Chapter 16. Table-valued parameters

Chapter 17. Build your own index

Chapter 18. Getting and staying connected—or not

Chapter 19. Extending your productivity in SSMS and Query Analyzer

Chapter 20. Why every SQL developer needs a tools database

Chapter 21. Deprecation feature

Chapter 22. Placing SQL Server in your pocket

Chapter 23. Mobile data strategies

Table of Contents