If you have any responsibility for planning or maintaining BizTalk Server databases, I highly encourage you to check out the brand new Microsoft Knowledge Base article entitled How to maintain and troubleshoot BizTalk Server databases.
The article contains details on SQL Server instance settings, the SQL Server Agent jobs, handling deadlocks, how to delete data from BizTalk databases, and how to troubleshoot database-related issues.
Much of this data is floating around elsewhere, but it’s a useful bookmark for a consolidated view.
On a completely unrelated note, I’ve enjoyed poking around the newly opened up Stack Overflow site and learning a few new C# language things and seeing some nice tool recommendations. I suspect that this site will be added to my daily web browsing cycle.
Technorati Tags: BizTalk