Publications

Article(s):

 Book(s):

 

 

 

 

 

 

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

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>