Resources

Articles
Click here to see all of the articles Allan has written for SQL Server Magazine.

 

Books Written, Reviewed, or Contributed To (Newest to Oldest)

• SQL Server MVP Deep Dives Volume 2 (Manning, 2011) – It can be found in a paperback print edition or eBook in PDF format.
• Pro SQL Server 2008 Failover Clustering (Apress, 2009) – It can be found in a paperback print edition, Kindle book, or an eBook in PDF format.
• Microsoft SQL Server 2008 Bible (Wiley, 2009) – It can be found in a paperback print edition, Kindle book, or eBook in PDF format
• Pro SQL Server 2005 High Availability (Apress, 2007) – It can be found in a hardback print edition, Kindle book, or an eBook in PDF format.
• Microsoft SQL Server 2000 Operations (Patterns & Practices) (Microsoft Press, 2002)
• Microsoft SQL Server 2000 High Availability (Microsoft Press, 2003) – It can be found in a paperback print edition, Kindle book, or as a NOOKbook.
• SQL Server 2000 Resource Kit – This can be found for free online at TechNet.
• Microsoft SQL Server 2000 Operations (Patterns & Practices) (Microsoft Press, 2002)

 

Recommended Reading

• Microsoft SQL Server 2008 Internals (Microsoft Press, 2009) – Written by Kalen Delaney, et al. Great reference book. It can be found in a paperback print edition or Kindle book.
• Professional SQL Server 2008 Internals and Troubleshooting (Wrox, 2010) – Excellent book by a bunch of SQL Server folks including SQL luminaries Brent Ozar, Cindy Gross, and Jonathan Kehayias (and more). It can be found in a paperback print edition or Kindle book.

 

Presentation Decks

• PASS Database Administration Virtual Chapter 2/9/11 Webcast – Windows Failover Clustering for the DBA

 

Scripts

• Pro SQL Server 2005 High Availability – This is a ZIP file containing all of the scripts from the book Pro SQL Server 2005 High Availability.

 

SQL Server Links

• Brent Ozar PLF – This is the home base of Brent Ozar, Jeremiah Peschka, Kendra Little, and Tim Ford.
• Confio – Confio makes tools for SQL Server, and is home to SQL Server MVP Tom LeRock.
• Data Education – SQL Server MVP Adam Machanic’s training company offering courses in the Boston, MA area from many of the top SQL experts in the world.
• Idera – Idera makes tools for SQL Server.
• Inside SQL Server- This is Kalen Delaney’s page for her Inside SQL Server books, and it contains a lot of good information as well as errata for the books.
• SolidQ – Allan sometimes does work with the folks over at SolidQ.
• Quest – Quest makes tools for SQL Server and is home to SQL Server MVP extrodinaire Kevin Kline.
• Redgate – Redgate makes tools for SQL Server, and is home to such SQL Server MVPs as Steve Jones and Grant Fritchey.
• SQLPeople – SQL Server MVP Andy Leonard‘s new community focused page for SQL Server.
• SQL Sentry – SQL Sentry makes tools for SQL Server, including the ever-useful Plan Explorer. SQL Server MVP Aaron Bertrand works for SQL Sentry.
• SQL Skills – This is the home base of Kimberly Tripp, Paul Randal, Jonathan Kehayias, and Joe Sack.

 

Webcasts (Newest to Oldest)

• SQL Server Foundations
• Quest Pain of the Week – Mission Critical SQL: High Availability Part One and Part Two
• PASS DBA Virtual Chapter – Windows Failover Clustering Basics for the DBA
• SQL Server Consolidation
• Deploying Dassault Systèmes ENOVIA Using SQL Server 2008
• Deploying Siemens PLM Teamcenter Using SQL Server 2008
• Deploying PTC Windchill Using Microsoft SQL Server
• Deploying Kronos Workforce Management Solutions Using SQL Server 2008
• Clustering Microsoft SQL Server 2008 with Windows Server 2008
• Planning a Windows Deployment for SQL Server 2008 Failover Clustering
• RunAs Radio #106
• Leveraging SQL Server Technologies to Build a Solid High-Availability Strategy – This was a webcast done during TechEd 2008 with other SQL Server folks like Kimberly Tripp, Paul Randall, and Microsoft’s own Kevin Farlee.
• RunAs Radio #60 – I chat with the guys about virtualization.
• .NET Rocks #212 – I chat with the guys about SQL Server high availability and applications.
• The Growing World of SQL Server: Surviving the Data Avalanche – This was a panel that happened during PASS 2006 in Seattle.
• Podcast for Polyserve
• TechNet chat April 24, 2002 – SQL Server High Availability
• TechNet chat May 28, 2003 – Log Shipping
• TechNet webcast from 2005 – SQL Server 2005 Failover Clustering for SQL Server 2000 Users

 

Whitepapers Written or Contributed To (Newest to Oldest)

• Applying Updates to a Clustered Instance of SQL Server 2008 or SQL Server 2008 R2
• SQL Server 2008 R2 Upgrade Technical Reference Guide
• Testing and Developing Supportability Roadmaps for Independent Software Vendor Applications
• Consolidation Using SQL Server 2008
• SQL Server 2008 Upgrade Technical Reference Guide
• Failover Clustering for SQL Server 2005 and SQL Server 2005 Analysis Services
• Microsoft SQL Server 2000 High Availability Patterns & Practices
• Microsoft SQL Server 2000 Failover Clustering
• Microsoft SQL Server 2005 Database Mirroring Best Practices and Performance Considerations
• Chapter 5 of the Microsoft Systems Architecture: Reference Architecture Guide
• Planning for Consolidation with Microsoft SQL Server 2000
• SQL Server Operations Guide
• Team Development with Visual Studio .NET and Visual SourceSafe

SQLHA Experts Tip #5