SharePoint Dragons

Nikander & Margriet on SharePoint

Tag Archives: sharepoint

Redirect to another location after submitting an InfoPath form

Which SharePoint API to use?

We’d love to hear your thoughts on which SharePoint API you should use and when: http://social.technet.microsoft.com/wiki/contents/articles/8181.sharepoint-2010-best-practice-which-api-to-use.aspx

SharePoint list form vs Form Library Form

This blog post provides an excellent overview of the differences between the two of them:

http://blogs.msdn.com/b/infopath/archive/2010/04/22/comparing-list-and-form-library-forms.aspx

Ever had problems where the SharePoint crawl database is ridiculously high?

After time, it can contain huge amounts (literally 10s of GBs) of empty space. You need to truncate the log file, restore the crawl database or possibly rebuild the crawl database and turn on Auto Shrink: http://www.aiim.org/community/blogs/expert/Is-your-search-database-bloated

Best practice regarding copying of permissions of SharePoint site collections

Calculating the size of SPS crawl and property databases

Great capacity planning resource containing some formulas for calculating the size of both crawl and property databases: http://thebitsthatbyte.com/calculating-sharepoint-2010-search-administration-crawl-and-property-database-sizes/

Esoteric info about retrieving content database info via the SharePoint OM

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

image

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.

Popularity of SharePoint around the world

Based on our blog readers, SharePoint is popular around the world! Okay, the number of readers in Greenland are disappointing so far, and we’re not very popular in China, but we’ve got every continent represented.

image

What is the SharePoint 2010 best practice: Asset or a Picture library

If you (or your customers) were wondering whether you should use an asset or a picture library, check out our Wiki page at:

http://social.technet.microsoft.com/wiki/contents/articles/8110.sharepoint-2010-best-practices-asset-vs-picture-library.aspx

Content db limits include remote BLOBs

It’s funny, cynical, and educational: http://www.sharepointedutech.com/2011/07/11/sharepoint-contentdb-guidance-too-many-shades-of-gray-along-with-a-little-brown/

Easy to miss, since the article is not about that, but we really liked the comment that the fact that auditing is either turned on or off has a great impact on capacity planning:

With the BLOBs remoted it’s much more likely that you’re going to hit an object density threshold (i.e. items in a list) before you reach a content db size threshold unless of course you have an enormous amount of metadata, are storing a large number of versions, or have auditing turned on…that last one always catches folks off guard and is rarely accounted for in capacity planning exercises.