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
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
Ben DeBow
Partner
Follow:
Always design the database environment top down even if the environment consists of only a couple servers or several hundred. By approaching the design top down, many efficiencies can be gained on every level.