SharePoint Dragons

When you call the ContentDatabase property of an SPSite instance, it actually uses a composite key consisting of the web application id and the path of the site collection. Execute this SQL query in the SharePoint config db to see it:

select * from sitemapvisible

In the object hierarchy of the config db, things are a little different though, and it looks like this:

content db [child of] sharepoint database service instance [child of] spserver [child of] config database.

When will you be using this info? Uhm, probably never, that’s the esoteric part about it.