We have just realeased a whitepaper that describes the recommended maintenance strategies for the databases that host content and configuration settings for SharePoint Products and Technologies. You can get it here. It covers: · Checking database integrity. · Defragmenting indexes by either reorganizing them or rebuilding them. · Setting the fill factor for a server….
For his first post he has provided a bunch of examples of dispose patterns for SharePoint that will be really helpful for anyone trying to write custom web parts for SharePoint and wanting to avoid all the myriad ways you can leak objects: SharePoint 2007 and WSS 3.0 Dispose Patterns by Example