Publications

Article(s):

Books:

Pro SQL Server Internals – covers SQL Server 2005-2014.

 

 

 

 

 

 

Table of Content:

Part 1 – Tables and Indexes
•        Chapter 1: Data storage internals
•        Chapter 2: Tables and Indexes – Internal Structure and Access Methods
•        Chapter 3: Statistics
•        Chapter 4: Special Indexing and Storage Features
•        Chapter 5: Index fragmentation
•        Chapter 6: Designing and tuning the indexes

Part 2: Other things that matter
•        Chapter 7: Constraints
•        Chapter 8: Triggers
•        Chapter 9: Views
•        Chapter 10: Functions
•        Chapter 11: XML
•        Chapter 12: Temporary Tables
•        Chapter 13: CLR
•        Chapter 14: CLR types
•        Chapter 15: Data partitioning
•        Chapter 16: System design considerations

Part 3: Locking, Blocking and Concurrency
•        Chapter 17: Lock types
•        Chapter 18: Troubleshooting Blocking issues
•        Chapter 19: Deadlocks
•        Chapter 20: Lock Escalations
•        Chapter 21: Optimistic isolation levels
•        Chapter 22: Application locks
•        Chapter 23: Schema locks
•        Chapter 24: Designing transaction strategies

Part 4: Query Life Cycle
•        Chapter 25: Query Optimization and Execution
•        Chapter 26: Plan Caching

Part 5: Practical Troubleshooting
•        Chapter 27:  System Troubleshooting
•        Chapter 28: Extended events

Part 6: Inside the transaction log
•        Chapter 29: Transaction Log Internals
•        Chapter 30: Designing a Backup Strategy
•        Chapter 31: Designing a High Availability Strategy

Part 7: In-Memory OLTP Engine
•        Chapter 32: Hekaton (In Memory OLTP Engine)
•        Chapter 33: In-Memory OLTP Programmability

Part 8: Columnstore Indexes
•        Chapter 34: Introduction to Columnstore indexes
•        Chapter 35: Clustered Columnstore indexes

 

Coming Soon:

Expert SQL Server In-Memory OLTP – Deep dive into In-Memory OLTP in SQL Server 2014.

Table of Content:

• Chapter 1: Why In-Memory OLTP?
• Chapter 2: In-Memory OLTP Objects
• Chapter 3: Memory-Optimized Tables
• Chapter 4: Hash Indexes
• Chapter 5: Nonclustered Indexes
• Chapter 6: In-Memory OLTP Programmability
• Chapter 7: In-Memory OLTP Concurrency Model
• Chapter 8: Data Storage, Logging and Recovery
• Chapter 9: Garbage Collection
• Chapter 10: Deployment and Management
• Chapter 11: Utilizing In-Memory OLTP
• Appendix A: Memory-Pointers Management
• Appendix B: Page Splitting and Page Merging in Nonclustered Indexes
• Appendix C: Analyzing the States of Checkpoint File Pairs
• Appendix D: In-Memory OLTP Migration Tools

2 thoughts on “Publications

  1. Susana Beatson

    Thanks for the time and care you took in writing this book. I enjoyed it immensely and learnt a fair amount.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *