Click here to see all of the articles Allan has written for SQL Server Magazine.
Books Written, Reviewed, or Contributed To

(Newest to Oldest)

Recommended Reading
  • Microsoft SQL Server 2008 Internals (Microsoft Press, 2009) – Written by Kalen Delaney: 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; paperback print edition or Kindle book.


  • 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.
  • Update Schedule Tool – This is a ZIP file containing a simple tool you can use to get a holistic look at your upgrades and create an easy to use schedule.

SQL Server Links


(Newest to Oldest)