In-Depth

Books: SQL Server for Gurus

The Guru's Guide to SQL Server Architecture and Internals helps SQL Server power users manage their complex enterprise systems. This valuable reference manual goes far beyond the product's base documentation.

SQL Server has proven itself to be an enterprise-ready database system. Enterprise systems, however, can be extremely complex, especially when it comes to effective physical architecture designs, scalable resource management, and problem solving. Serious SQL Server users must have access to the best sources of knowledge and experience available. Without a doubt, Ken Henderson's The Guru's Guide to SQL Server Architecture and Internals is one of those sources.

Henderson breaks the book down into four sections. The first section provides a necessary explanation of the platform that SQL Server runs on. It discusses essential Windows concepts such as processor modes, processes and threads, COM, XML, and fundamentals of memory, I/O, and networking. The second part of the book begins to dissect the core of SQL Server, providing you insight into SQL memory management, transactional support, cursors, and query processors. Henderson covers data services, such as SQLXML, notification services, DTS, and replication, in the third section. Finally, the fourth section takes you where few can—into the undocumented features of SQL Server. The 45 exercises and detailed technical explanations enhanced with more than 900 code examples (written in C++ and T-SQL and included on the accompanying CD) also add to this more than 1,000-page reference guide.

This book's strength is in its detail and quality of its explanations. This book is not well suited for those in the beginning stages of learning SQL Server, but it is an extremely valuable reference manual for those who need information far beyond the product's base documentation.

The Guru's Guide to SQL Server Architecture and Internals
by Ken Henderson
Addison-Wesley
ISBN: 0201700476
Price: $54.99
Quick Facts: An in-depth look into SQL Server, including the technologies behind SQL Server, notification services, full text search, SQLXML, replication, and DTS.
Pros: In-depth content includes lengthy material on undocumented SQL Server features.
Cons: Isn't for beginner programmers or average SQL Server administrators.

About the Author

Joel Semeniuk is a founder of Imaginet Resources Corp., a Canada-based Microsoft Gold Partner. Currently, Joel is also serving as an Executive VP of Agile Project Management Tools at Telerik. He is also a Microsoft Regional Director and MVP Microsoft ALM, with a degree in Computer Science. With more than 18 years of experience, Joel specializes in helping organizations around the world realize their potential through maturing their software development and information technology practices. Joel is passionate about Application Lifecycle Management tooling, techniques and mindsets, and regularly speaks at conferences around the world on a wide range of ALM topics.

Featured

  • How To Use .CSV Files with PowerShell, Part 1

    When it comes to bulk administration, few things are handier than .CSV files. In this two-part series, Brien demos his top techniques for working with .CSV files in PowerShell. First up: How to create a .CSV file.

  • SameSite Cookie Changes Rolled Back Until Summer

    The Chromium Project announced on Friday that it's delaying enforcement of SameSite cookie changes, and is temporarily rolling back those changes, because of the COVID-19 turmoil.

  • Basic Authentication Extended to 2H 2021 for Exchange Online Users

    Microsoft is now planning to disable Basic Authentication use with its Exchange Online service sometime in the "second half of 2021," according to a Friday announcement.

  • Microsoft Offers Endpoint Configuration Manager Advice for Keeping Remote Clients Patched

    Microsoft this week offered advice for organizations using Microsoft Endpoint Configuration Manager with remote Windows systems that need to get patched, and it also announced Update 2002.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.