Wednesday, April 30, 2008

Where is what in the database?

Ever wondered where things are being stored in the database? Or do you need to check that your web part contains the right information?
I've been struggling to get a good overview of the different databases and their tables. Now I've finally found it. And this it's Microsoft themselves who comes to the rescue!

Check out the Databases reference here:

This reference contains information on all tables (both content database tables and configuration database tables) and stored procedures.

Also check out Ethan Bertsch's blog post on the content database: Inspecting The SharePoint Content Database. It contains information on the most common used tables, as well as some SQL scripts on common queries. But the best part is the excellent database diagram of the content database. Thanks, Ethan.

Finally, to repeat what cannot be said often enough:
Direct editing in the SharePoint databases is NOT supported by Microsoft, and should therefore never be done. If you however need to, make sure you BACKUP your databases or farm before doing so.

Monday, April 14, 2008

Forefront Security for SharePoint with Service Pack 2

Mostly for those wanting to upgrade to Windows Server 2008, but also for those of you wanting to get the latest fixes in Forefront for SharePoint.
More information here...