Book description
This is no ordinary SQL Server book. In SQL Server MVP Deep Dives, the world's leading experts and practitioners offer a masterful collection of techniques and best practices for SQL Server development and administration. 53 MVPs each pick an area of passionate interest to them and then share their insights and practical know-how with you.
About the Technology
About the Book
SQL Server MVP Deep Dives is organized into five parts: Design and Architecture, Development, Administration, Performance Tuning and Optimization, and Business Intelligence. In each, you'll find concise, brilliantly clear chapters that take on key topics like mobile data strategies, Dynamic Management Views, or query performance.
What's Inside
- Topics important for SQL Server pros
- Accessible to readers of all levels
- New features of SQL Server 2008
About the Reader
Whether you're just getting started with SQL Server or you're an old master looking for new tricks, this book belongs on your bookshelf.
About the Authors
The authors of this book have generously donated 100% of their royalties to support War Child International.
Quotes
Table of contents
- Copyright
- Dedication
- 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
- Part 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
- Part 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
- Part 3. Database Administration
- Chapter 24. What does it mean to be a DBA?
- Chapter 25. Working with maintenance plans
- Chapter 26. PowerShell in SQL Server
- Chapter 27. Automating SQL Server Management using SMO
- Chapter 28. Practical auditing in SQL Server 2008
- Chapter 29. My favorite DMVs, and why
- Chapter 30. Reusing space in a table
- Chapter 31. Some practical issues in table partitioning
- Chapter 32. Partitioning for manageability (and maybe performance)
- Chapter 33. Efficient backups without indexes
- Chapter 34. Using database mirroring to become a superhero!
- Chapter 35. The poor man’s SQL Server log shipping
- Chapter 36. Understated changes in SQL Server 2005 replication
- Chapter 37. High-performance transactional replication
- Chapter 38. Successfully implementing Kerberos delegation
- Chapter 39. Running SQL Server on Hyper-V
- Part 4. Performance Tuning and Optimization
- Chapter 40. When is an unused index not an unused index?
- Chapter 41. Speeding up your queries with index covering
- Chapter 42. Tracing the deadlock
- Chapter 43. How to optimize tempdb performance
- Chapter 44. Does the order of columns in an index matter?
- Chapter 45. Correlating SQL Profiler with PerfMon
- Chapter 46. Using correlation to improve query performance
- Chapter 47. How to use Dynamic Management Views
- Chapter 48. Query performance and disk I/O counters
- Chapter 49. XEVENT: the next event infrastructure
- Part 5. Business intelligence
- Chapter 50. BI for the relational guy
- Chapter 51. Unlocking the secrets of SQL Server 2008 Reporting Services
- Chapter 52. Reporting Services tips and tricks
- Chapter 53. SQL Server Audit, change tracking, and change data capture
- Chapter 54. Introduction to SSAS 2008 data mining
- Chapter 55. To aggregate or not to aggregate—is there really a question?
- Chapter 56. Incorporating data profiling in the ETL process
- Chapter 57. Expressions in SQL Server Integration Services
- Chapter 58. SSIS performance tips
- Chapter 59. Incremental loads using T-SQL and SSIS
- Index
Product information
- Title: SQL Server MVP Deep Dives
- Author(s):
- Release date: November 2009
- Publisher(s): Manning Publications
- ISBN: 9781935182047
You might also like
book
SQL Server MVP Deep Dives, Volume 2
SQL Server MVP Deep Dives, Volume 2 lets you learn from the best in the business—64 …
book
SQL Server AlwaysOn Revealed
Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. …
book
SQL Server DMVs in Action
SQL Server DMVs in Action is a practical guide that shows you how to obtain, interpret, …
book
Mastering SQL Server 2017
Leverage the power of SQL Server 2017 Integration Services to build data integration solutions with ease …