Resources
Recommended Resources
This page is intended to be a dynamic resource and will be updated regularly with new information. We would appreciate your suggestions on additional resource topics and improvements that would make this page more useful to you.
Please Contact Us with questions or comments.
Articles
Click here to see all of the articles Allan has written for SQL Server Magazine.
Book Written, Reviewed, or Contributed To
(Newest to Oldest)
- SQL Server MVP Deep Dives Volume 2 (Manning, 2011) – paperback print edition or eBook in PDF format.
- Pro SQL Server 2008 Failover Clustering (Apress, 2009) – paperback print edition,Kindle book, or an eBook in PDF format.
- Microsoft SQL Server 2008 Bible (Wiley, 2009) – paperback print edition, Kindle book, or eBook in PDF format
- Pro SQL Server 2005 High Availability (Apress, 2007) – 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) – paperback print edition, Kindle book, or as a NOOKbook.
- SQL Server 2000 Resource Kit – 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: 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.
Presentation Decks
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.
- 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
- Redgate – Redgate makes tools for SQL Server, and is home to such SQL Server MVPs as Steve Jones andGrant Fritchey.
- SQLPeople – SQL Server MVP Andy Leonard‘s new community focused page for SQL Server.
- Sentry One – Sentry One makes tools for SQL Server, including the ever-useful Plan Explorer.
- 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
- 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