Programmatically find MS Shipped Databases

Hello, Have you ever needed to programmatically find what databases in you server are part of Microsoft products? Maybe to use that information in your own piece of code? In my case, I needed that information to exclude Sharepoint and Biztalk databases from the AdaptiveIndexDefrag cycles that are part of the maintenance operations we deploy…


MOSS, BizTalk, SCOM and SQL Server Collations

Hello all, The topic today is database and server collations. As part of pre-installation tasks for SQL Server, we should always take into account what is the collation required by the user databases. Why is that? Collation is a subject many times overlooked when installing SQL Server, and many just use the default when installing…


SQL Best Practices for Biztalk

As promised in my last post, here is the post for SQL Best practices for a Biztalk installation. Althought the majority of best practices for a SQL Server instance are still valid for a Biztalk implementation we should consider some points that are different. In a Biztalk instance: Auto create statistics must be disabled Auto…

1