SQL Server MVP Deep Dives
eBook - ePub

SQL Server MVP Deep Dives

  1. 848 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

SQL Server MVP Deep Dives

About this book

This is not an ordinary SQL Server Book. SQL Server MVP Deep Dives brings together the world's most highly-regarded SQL Server experts to create a masterful collection of tips, techniques, and experience-driven best practices for SQL Server development and administration. These SQL Server MVPs-53 in all-each selected a topic of great interest to them, and in this unique book, they share their knowledge and passion with you. SQL Server MVP Deep Dives is organized into five parts: Design and Architecture, Development, Administration, Performance Tuning and Optimization, and Business Intelligence. Within each part, you'll find a collection of brilliantly concise and focused chapters that take on key topics like mobile data strategies, Dynamic Management Views, or query performance. The range of subjects covered is comprehensive, from database design tips to data profiling strategies for BI.Additionally, the authors of this book have generously donated 100% of their royalties to support War Child International. War Child International is a network of independent organizations, working across the world to help children affected by war. War Child was founded upon a fundamental goal: to advance the cause of peace through investing hope in the lives of children caught up in the horrors of war. War Child works in many different conflict areas around the world, helping hundreds of thousands of children every year. Visit www.warchild.org for more information. Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book.

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn more here.
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, weā€™ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere ā€” even offline. Perfect for commutes or when youā€™re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access SQL Server MVP Deep Dives by Paul S. Randal,Kimberly Tripp,Adam Machanic,Paul Nielsen in PDF and/or ePUB format, as well as other popular books in Computer Science & Business Intelligence. We have over one million books available in our catalogue for you to explore.

Information

Publisher
Manning
Year
2009
Print ISBN
9781935182047
eBook ISBN
9781638352204
Topic
Computer Science
Subtopic
Business Intelligence
Index
Computer Science

Table of contents

  1. Copyright
  2. Dedication
  3. Brief Table of Contents
  4. Table of Contents
  5. List of Figures
  6. List of Tables
  7. List of Listings
  8. MVP contributors and their chapters
  9. Preface
  10. Acknowledgments
  11. About War Child
  12. About this Book
  13. About SQL Server MVPs
  14. Part 1. Database design and architecture
  15. Chapter 1. Louis and Paulā€™s 10 key relational database design ideas
  16. Chapter 2. SQL Server tools for maintaining data integrity
  17. Chapter 3. Finding functional dependencies
  18. Part 2. Database Development
  19. Chapter 4. Set-based iteration, the third alternative
  20. Chapter 5. Gaps and islands
  21. Chapter 6. Error handling in SQL Server and applications
  22. Chapter 7. Pulling apart the FROM clause
  23. Chapter 8. What makes a bulk insert a minimally logged operation?
  24. Chapter 9. Avoiding three common query mistakes
  25. Chapter 10. Introduction to XQuery on SQL Server
  26. Chapter 11. SQL Server XML frequently asked questions
  27. Chapter 12. Using XML to transport relational data
  28. Chapter 13. Full-text searching
  29. Chapter 14. Simil: an algorithm to look for similar strings
  30. Chapter 15. LINQ to SQL and ADO.NET Entity Framework
  31. Chapter 16. Table-valued parameters
  32. Chapter 17. Build your own index
  33. Chapter 18. Getting and staying connectedā€”or not
  34. Chapter 19. Extending your productivity in SSMS and Query Analyzer
  35. Chapter 20. Why every SQL developer needs a tools database
  36. Chapter 21. Deprecation feature
  37. Chapter 22. Placing SQL Server in your pocket
  38. Chapter 23. Mobile data strategies
  39. Part 3. Database Administration
  40. Chapter 24. What does it mean to be a DBA?
  41. Chapter 25. Working with maintenance plans
  42. Chapter 26. PowerShell in SQL Server
  43. Chapter 27. Automating SQL Server Management using SMO
  44. Chapter 28. Practical auditing in SQL Server 2008
  45. Chapter 29. My favorite DMVs, and why
  46. Chapter 30. Reusing space in a table
  47. Chapter 31. Some practical issues in table partitioning
  48. Chapter 32. Partitioning for manageability (and maybe performance)
  49. Chapter 33. Efficient backups without indexes
  50. Chapter 34. Using database mirroring to become a superhero!
  51. Chapter 35. The poor manā€™s SQL Server log shipping
  52. Chapter 36. Understated changes in SQL Server 2005 replication
  53. Chapter 37. High-performance transactional replication
  54. Chapter 38. Successfully implementing Kerberos delegation
  55. Chapter 39. Running SQL Server on Hyper-V
  56. Part 4. Performance Tuning and Optimization
  57. Chapter 40. When is an unused index not an unused index?
  58. Chapter 41. Speeding up your queries with index covering
  59. Chapter 42. Tracing the deadlock
  60. Chapter 43. How to optimize tempdb performance
  61. Chapter 44. Does the order of columns in an index matter?
  62. Chapter 45. Correlating SQL Profiler with PerfMon
  63. Chapter 46. Using correlation to improve query performance
  64. Chapter 47. How to use Dynamic Management Views
  65. Chapter 48. Query performance and disk I/O counters
  66. Chapter 49. XEVENT: the next event infrastructure
  67. Part 5. Business intelligence
  68. Chapter 50. BI for the relational guy
  69. Chapter 51. Unlocking the secrets of SQL Server 2008 Reporting Services
  70. Chapter 52. Reporting Services tips and tricks
  71. Chapter 53. SQL Server Audit, change tracking, and change data capture
  72. Chapter 54. Introduction to SSAS 2008 data mining
  73. Chapter 55. To aggregate or not to aggregateā€”is there really a question?
  74. Chapter 56. Incorporating data profiling in the ETL process
  75. Chapter 57. Expressions in SQL Server Integration Services
  76. Chapter 58. SSIS performance tips
  77. Chapter 59. Incremental loads using T-SQL and SSIS
  78. Index