..:: I like SharePoint ::.. Rotating Header Image

Administration

Database Maintenance Do’s & Dont’s for SharePoint 2010

If you are responsible for a SharePoint Farm or developing things for a SharePoint farm, I bet you’ve heard things like “it’s not supported by Microsoft to do…” and those things mostly dealing with database operations like updating values or settings. But what is about doing administration stuff like defragmentation of indices or shrinking a database?

In this post I try to make some things more clear. My information is based on this technet article, so I was not creative at all. The things I will point out are valid for SharePoint 2010.

Routine database maintenance is essential for the smooth operation of Microsoft SharePoint 2010 databases

That means that we have to do some work on the SQL Server. Microsoft recommends to check database integrity, defragment indexes by reorganizing or rebuilding them as well as set the fill factor for your server.

In SharePoint 2010 the health analyzer evaluate the health of database indexes and statistics daily and reports them at the central administration. But this happens only for some SharePoint databases like

  • Configuration DB
  • Content DBs
  • User Profile Service Application Profile DB
  • User Profile Service Application Social DB
  • Web analytics service application reporting DB
  • Web analytics service application staging DB
  • Word automation services DB

Let’s see what are the details and what you should not do. (more…)

SharePoint 2013: Missing Slide Library

After searching for the SharePoint 2010 Slide Library i found this little help on Mike Smith´s blog

/_layouts/15/slnew.aspx?FeatureId={0be49fe9-9bc9-409d-abf9-702753bd878d}&ListTemplate=2100

Just add the above mentioned link to your SharePoint URL and you are able to create the Slide Library within SharePoint 2013.

..:: I like SharePoint ::..

 

SharePoint Create Sites based on Site Collection with Powershell

In SharePoint 2010 and 2013 it is possible to create Site Collections by the UI, using C# Coding or Powershell. In one of our scenarios we had to prepare a web application in which each site collection should get its own Content Database and each site collection should be based on a site collection which already exists in the webapplication as a site collection.

Normally you have to save this site as template, download it, create a new site, upload the template and then you’re done. But that’s not the things administrators, users or developers like to do. We all would like to use a cool Powershell script.

So we created a Powershell Script as function, which does the job using some parameter.
Let’s see the steps it takes:

  1. Check if Content Database exist and create the new one
  2. Create a site collection with the same template in the new content database
  3. Export the template from site collection
  4. Import the template into new site collection
  5. Change the title of the web

Let’s see the code. (more…)

SharePoint 2013: eSignature with SharePoint 2013 / 21-CFR-Part-11

Electronic Signatures with SharePoint is not impossible. There are some steps to perform to enable eSignature for your SharePoint Library.

How to set up 21-CFR-Part-11 you will find here: http://download.microsoft.com/download/3/6/B/36B2F4F5-55AD-4D64-BC5B-62B536E35A62/SharePoint-2013-Configuration-Guidance-for-21-CFR-Part-11%20v2.pdf (more…)

SharePoint 2013: Get File Size of List Attachments

Sometimes you just want to know how big are your attachments within a SharePoint list? Here you get a simple PowerShell Script to get these information

$file.Length

(more…)