Archive for the ‘MS Office SharePoint Server’ Category

SharePoint 2010 how to reduce the size of logging database or how to purge the old data from Logging Database

October 15, 2014

WSS logging database grows very fast and it cause the storage problem most of the time in sharepoint server 2010.

To reduce the size of the logging database or to purge the old data from the logging database we can these steps.

To find the Logging Database Name go to following path:-

Login to Central Administration -> Monitoring -> Configure Usage and health data collection->


The Logging database stores the following things:-

  • ULS Logs from 14 Hive\LOGS
  • Raw Resource Usage Data

This data is used by Web Analytics in Sharepoint. Two timer jobs Microsoft SharePoint Foundation Usage Data Import and Microsoft SharePoint Foundation Usage Data Processing are used for importing and processing the raw data in the web analytics database.

By Default the system retains 14 days of Usage data in this database. By following PowerShell command we can check and change the value of retention days of this database. Get-spusagedefinition and Set-SPUsageDefinition

Try  Get-SPUsageDefinition

Now you need to find which table is taking most of the space inside the WSS logging Database.


You Can check the same from the SQL Server

Login to Sharepoint Management Studio -> Select your logging Database (Right Click) -> Reports- > Standard Reports -> Disk Usage by Top Tables.


Say RequestUsage* is taking most of the space inside WSS Logging database so  you can bring down the retention period of  Page Request Event.

Or if you want you can bring down the retention period for all the Events for any number of days from 14 to 1.

Use the following command to do so.

Set-SPUsageDefinition -Identity”Page Requests” -DaysRetained 3

Run the same Power Shell command again to cross check “Get-SPUsageDefinition” and check the Retention period is changed or not.

After that we need to run the two timer jobs to clean the old data ‘Microsoft SharePoint Foundation Usage Data Import’ and ‘Microsoft SharePoint Foundation Usage Data Processing’.

Go to Sharepoint Central Administration -> Monitoring -> Configure Usage and health data collection-> Log Collection Schedule.

And it will take you to the timer jobs.

Now Click on both the Job Definitions one by one and hit ‘Run Now’ to run the timer jobs


Once the timer jobs is run you can check and confirm database has released the space.

Original Source: Manhar Sharma

Why does /_layouts/15/start.aspx appear as part of my SharePoint 2013 Site URL ?

October 2, 2014

The URL path of a newly created site collection will include “/_layouts/15/start.aspx” To avoid this it is necessary to deactivate the following site feature:

1. Go to Site Settings – Site Features page.

2. Deactivate the “Minimal Download Strategy” feature.

Why is the Minimal Download Strategy available by default on various site collection templates including the Team Site? This is a new feature for SharePoint 2013 that is designed to increase the performance of the SharePoint site.

The start.aspx page has a specific JavaScript object asyncDeltaManager (defined in start.js). This parses the URL, looks for the # sign and takes the path following that and dynamically loads that page.

Subsequent requests to pages are dynamically loaded through the asyncDeltaManager object. Once a link is clicked it will invoke a method in the JavaScript object which creates the MDS URL and appends the query string parameter AjaxDelta=1. A request is created and downloaded asynchronously and only the “delta” is returned to the client and assembled and rendered using JavaScript.

For a full explanation please read Wictor Wilen’s Blog post here:—introduction-to-the-minimal-download-strategy-mds

Enable iFilter for TIFF OCR in SharePoint Foundation or SharePoint Server

October 1, 2014

In some companies, paper documents are scanned into TIFF formats and stored electronically.  To search for them, you’ll need to enable the TIFF OCR iFilter to allow SharePoint to index TIFF documents.

1. Install Windows Server feature Windows TIFF IFilter:


2. Enable OCR filter




3. You may need to restart the machine

4. Force SharePoint to perform a full crawl from Search Administration

5. Search for your file – here, I’m searching for “Therefore”


Source and original post

Tips for SQL tuning for SharePoint

September 24, 2014

Part 1 – MAX DOP:

Part 2 – Shrink DB:

Part 3 – TEMPDB:

SharePoint Foundation 2013 Language Packs with SP1 downloads

September 5, 2014

SharePoint Foundation 2013 Language Packs with SP1:

SharePoint Server 2013 Language Packs with SP1 downloads

September 3, 2014

SharePoint Server 2013 Language Packs with SP1:

SharePoint 2013 SP1 language pack

September 1, 2014

One missing piece in the SharePoint 2013 SP1 release were slipstream installation files for the language packs.

These should be available soon on download center on the following link:

Microsoft Demo Builder 2013

August 17, 2014

Demo builder helps you build demos with data which can be used in your corporate demo.

It also comes with OOB SharePoint integration, Azure Integration as well as customer portal. Very handy for setting up quick demo environment.


Check this link for details:

Microsoft Office SharePoint 2013 FBA Pack Released

July 1, 2014

The SharePoint 2013 FBA Pack has been released. It was ported from the SharePoint 2010 FBA Pack (which was originally ported from the SharePoint 2007 CKS Forms Based Authentication Solution), and includes all of the features from the SharePoint 2010 FBA Pack:

  • User Management
  • Role Management
  • Membership Request Web Part
  • Password Recovery Web Part
  • Change Password Web Part
  • Change Password Menu Item

Forms 7 – A lightweight InfoPath alternative for SharePoint

June 16, 2014

Forms7 is a lightweight InfoPath alternative that uses a jQuery plugin that allows users to easily create forms for SharePoint 2007/2010/2013 using basic HTML.


Forms7 comes with many features that can add robustness and usability to your forms including:

- Create forms using ANY HTML editor and store form in ANY SharePoint List

- Store multiple forms on the same SharePoint list without adding additional fields

- Helper functions for loading Cascading Drop Down lists from other SharePoint Lists

- Custom validation that checks for required fields, validity of entered data, and the ability to create your own validation functions

- Forms7 can use jQuery UI for date fields and other functionality

- “Required” fields are ignored if the fields are not visible on the page

- NEW in version 0.05 Reporting using the DataTables Library. Create List Views for your Forms7 forms!

Videos for more information and getting started

Introduction to Forms 7

Installation and Minimal Form

Select Boxes and Loading Select boxes with SharePoint List data for options

Converting Word Document to Forms7 Form 

Reporting/List Views of form data stored in Forms7


The Forms7 plugin will iterate over the fields in your HTML form and store the fields as a JSON object in one field in your SharePoint list. Using Forms7 you can promote fields to SharePoint list fields as well as add custom validation of fields.

Forms7 puts the power of the forms in the hands of your business again by allowing non-technical users to create attractive forms using any HTML editor and passing that HTML off to your JavaScript developers should additional functionality want to be added like conditionally hiding/showing fields.

Forms7 is a great InfoPath alternative for users wanting to move away from that technology for their basic forms needs.

An earlier version of Forms7 is currently in use by a fortune 100 company storing 9 different forms in one list with great success.

Forms7 is free, and for free, it does have it’s limitations including:

1) People Pickers are not currently supported
2) It’s in ALPHA!! I’ve not tested every possible iteration and possibility.
3) Documentation is currently light (non-existent) but this will be added as interest grows.

Forms7 uses SPServices to read and write SharePoint list data ( Future plans include a supported version that uses the Client Object Model.

How can you help?? Let me know you are interested so that I’ve got some motivation to document and improve this promising technology.

The included Sample Form will help you get started until I can get some actual documentation in place. To use the sample form without modifications:

1) copy the form and script to a “SiteAssets” document library on your site.

2) Create a list called “Contacts” and add a multiline plain text field called “Forms7Data”.

3) Create a Web Part Page called “SampleForm” under Site Pages

4) Drop a Content Editor Web Part on the page and link it to ../SiteAssets/sampleForm.html

You can see a live sample here:

A more styled example of form for same list can be found here (best viewed in Chrome because of CSS used):

More Examples and Documentation Coming Soon! 


Get every new post delivered to your Inbox.

Join 30 other followers