Browse by Tags

Hello all, I admit I’m not a big fan of Maintenance Plans (the feature that goes by that name) mainly because of its “do or die” approach. So, it was not by chance that I wrote and keep updating the AdaptiveIndexDefrag procedure. Good maintenance (or lack thereof) may be the difference...

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...

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...

Hello all, One question that arises often is how can we correctly configure SQL Server to work with MOSS?. Although the majority of best practices for SQL does apply, there are some diferences that it is important to be aware of. 1 - Architecture recommendation 1.1 - Limit content database size...