Sample Chapter: The Guru's Guide to SQL Server Architecture

By Bill Graziano on 30 October 2003 | Tags: Application Design , Books


Ken Henderson's latest book is out. We have a sample chapter on XML available (PDF, ~1MB). You can buy The Guru's Guide to SQL Server Architecture and Internals from Amazon. From the book: "The Guru's Guide to SQL Server Architecture is all about the internal pieces of SQL Server, the architecture of how they fit together, and the effect those have on performance and tuning issues. The book covers issues such as the new Notification Services which have not been covered in any other book, and also goes into more detail than any other book on the core SQL Server technologies. This new book will take its place next to his two previous books on the shelves of SQL Server developers and administrators everywhere."


Related Articles

Application Locks (or Mutexes) in SQL Server 2005 (7 January 2008)

What I Wish Developers Knew About SQL Server (Presentation) (11 October 2007)

Multiple Active Result Sets (MARS) – Transactions and Debugging (17 June 2007)

Multiple Active Result Sets (MARS) (3 April 2007)

How SQL Server 2005 Enables Service-Oriented Database Architectures (8 September 2006)

Presentation: What I Wish Developers Knew About SQL Server (17 November 2005)

GeoCoding with SQL Server and Google (8 August 2005)

How to Asynchronously Execute a DTS package from ASP or ASP.NET (27 March 2005)

Other Recent Forum Posts

SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xaaaaaaaa; actual signature: 0xfffffffe). It occurred during a read of page (1:908) in database ID 99 at offset (77m)

Case stmt in SSIS (19h)

Upgrading from MSSQL 2016 to 2017 (1d)

Why does CASE WHEN NULL IN (SELECT A FROM B) THEN 'Y' ELSE '' AS [NULL] does not work? (1d)

Tensorflow package installation on SQL 2019 ML Services (1d)

How can I reference the table (T1 JOIN T2 ON A=B JOIN T3 ON C=D)? (1d)

Is there an easy way to populate a column with an INDEX/MATCH statement? (2d)

Is joining table completely deceiving? (2d)

- Advertisement -