To all children traumatized by the horrors of war and War Child’s efforts to help children be children again
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