Books I Have Written

Staring in SQL Server 2000, I have published a series books on database design for Apress. 

• Pro SQL Server Relational Database Design and Implementation (2021)
• Pro SQL Server Relational Database Design and Implementation (2016)
• Pro SQL Server 2012 Relational Database Design and Implementation
• Pro SQL Server 2008 Relational Database Design and Implementation
• Pro SQL Server 2005 Database Design and Optimization
• Pro SQL Server 2000 Database Design

In 2023, I published a new programming focused books on use the graph features of SQL Server for Apress. 

• Practical Graph Structures in SQL Server and Azure SQL

Reference books that packs hundreds of solutions, tips, and workarounds–all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. Cowritten with Randolph West, William Assaf, and many others.

• SQL Server 2022 Administration Inside and Out
• SQL Server 2019 Administration Inside and Out

My first work for Microsoft Press, I co-wrote this study book on the 70-762 Microsoft Exam. I wrote the first two chapters, and Stacia Varga wrote the last two.

Information Link 

One of my most and least (it was a grueling project!) favorite projects is this book that Tim Ford and I wrote on the Dynamic Management Views for Red-Gate. While it has been out for nearly 8 years, it is still a great reference for the base DMV objects. The e-book is available for FREE from Red-Gate, or you can purchase a dead tree version from Amazon.

Information Link

Introductory book on how and why to implement SQL Server on Azure VMs. I wrote the first chapters overviewing the Azure SQL Offerings. Cowritten with Joey D'Antoni, Allan Hirt,  John Martin, Anthony Nocentino, Tim Radney and Randolf West 

Information Link