Pro SQL Server Internals

This second edition of Pro SQL Server Internals provides the detailed knowledge that database professionals need in order to advance and be successful in their careers. Readers gain deep understanding that frees them from checklist-based approaches and allows fluid and creative approaches to configuring databases to meet business needs, and to maintaining those systems over the long haul. Database administrators are able to act from a depth of knowledge and respond and adapt quickly to changing business needs. Developers are able to engineer highly-performing systems with appropriate hooks for troubleshooting and diagnosis of abnormal events. Readers are able to go beyond the manuals and create database applications able to handle the intense query workloads that characterize an age of Big Data, Cloud Computing, and the Internet.

Provides detailed knowledge of Query Store and other new features Includes revamped coverage of columnstore indexes Covers indexing and transaction strategies

Autorentext
Dmitri Korotkevitch is Microsoft SQL Server MVP and Microsoft Certified Master. He brings years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. He specializes in design, development, and performance tuning of OLTP Systems working under heavy load. Dmitri regularly speaks at various Microsoft and SQL PASS events, and he provides SQL Server training to clients around the world.

Inhalt

Part 1: Tables and Indexes.- 1. Data Storage Internals.- 2. Tables and Indexes.- 3. Statistics.- 4. Special Indexing and Storage Features.- 5. SQL Server 2016 Enhancements.- 6. Index Fragmentation.- 7. Designing and Tuning the Indexes.- Part 2: Other Things That Matter.- 8. Constraints.- 9. Triggers.- 10. Views.- 11. Functions.- 12. XML and JSON.- 13. Temporary Tables and TempDB.- 14. CLR.- 15. CLR Types.- 16. Data Partitioning.- Part 3: Locking, Blocking and Concurrency.- 17. Lock Types and Transaction Isolation Levels.- 18. Troubleshooting Blocking Issues.- 19. Deadlocks.- 20. Lock Escalations.- 21. Optimistic Isolation Levels.- 22. Application Locks.- 23. Schema Locks.- 24. Designing Transaction Strategies.- Part 4: Query Life Cycle.- 25. Query Optimization and Execution.- 26. Plan Caching.- Part 5: Practical Troubleshooting.- 27. System Troubleshooting.- 28. Extended events.- 29. Query Store.- Part 6: Inside the Transaction Log.- 30. Transaction Log Internals.- 31. Backup and Restore.- 32. High Availability Technologies.- Part 7: In-Memory OLTP Engine.- 33. Column-Based Storage and Batch Mode Execution.- 34. Columnstore Indexes.- Part 8: In-Memory OLTP Engine .- 35. In-Memory OLTP Internals.- 36. Transaction Processing in In-Memory OLTP.- 37. In-Memory OLTP Programmability.