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.