Update: As Omer points out in the comments to this entry, the recommendations made in the DBA Checklist mentioned below are in places at odds with the official BizTalk/SQL Server best practices. When reviewing the checklist, please refer to the Microsoft BizTalk SQL Server Best Practices KB article.
SimpleTalk has a helpful DBA checklist for all those BizTalkers who double-hat and manage a SQL Server as-well-as a BizTalk environment. It covers a number of useful topics, including:
- General best practices
- High-availability
- Performance tuning
- Application coding and design
- SSIS, Analysis Services, Reporting Services & Service Broker
Plenty of content for both new and experienced DBA’s – well worth a look.