SharePoint 2010 with SQL Server 2012

To install SharePoint 2010 on SQL server 2012, you will need to ensure that you have at least the SharePoint 2010 with Service Pack 1 installer. SQL Server 2012 removed the system stored procedure sp_dboptions. This is a required stored procedure for installing SharePoint 2010. Service pack 1 for SharePoint 2010 does eliminate the dependency for the sp_dboptions stored procedure.

How to buy an app from the SharePoint Store

To add an app to a site, you must have at least Full Control permissions for that site. If you are a Site Owner, you already have this permission.

(1) On the site where you want to add an app, click the Settings button, and then click Add an app.
(2) On the Your Apps page, click SharePoint Store in the left-hand navigation.
(3) Use the Categories on the left to filter the selection and browse for the app that you want.
(4) Click the app you want to add. Click Details or Reviews to learn more about the app.
(5) If you are buying this app, use the drop-down list under the price to specify whether you are buying it for your own use, or for use by several people. If required, specify the number of user licenses that you want to buy.
(6) To buy the app click Buy It. (If it’s a free app, click Add it.)
(7) Follow the steps to log on with your Microsoft account to buy the app.
(8) When you are asked whether you want to trust the app, review the Terms & Conditions and the Privacy Statement from the app developer, and then click Trust It.
(9) The app will now appear on the Site Contents page. You can go to the app by clicking it on the Site Contents Page, which takes you to the app.
(10) Done! 🙂

Understanding SPMinuteSchedule.BeginSecond property and SPMinuteSchedule.EndSecond property

The SPMinuteSchedule.BeginSecond property and the SPMinuteSchedule.EndSecond property specify a start window of execution. The SharePoint Timer service starts the timer job at a random time between the BeginSecond property and the EndSecond property. This aspect of the timer service is designed for expensive jobs that execute on all servers in the farm. If all the jobs started at the same time, it could place an unwanted heavy load on the farm. The randomization helps spread the load out across the farm.

Types of Web Pages in SharePoint 2010

Although SharePoint 2010 gives you a lot of helpful tools to work with content, the ability to communicate effectively with your team, starting with a customizable home page, pulls everything together. Using web pages and Web Parts is how you arrange and present information in a collaboration site. Team sites use wiki pages to make it easy for everyone on your team to share information.

Type 1: Publishing Page
Default Location: Pages library
Typical Usage Scenario: Complete control over look and feel; more granular content management.

Type 2: Web Part Page
Default Location: None; can reside in any library or folder
Typical Usage Scenario: To display Web Parts; no content management requirement.

Type 3: Wiki Page
Default Location: Site Pages
Typical Usage Scenario: Pages that look and function like the home page.

Exporting a SharePoint list in SharePoint 2010

To export a list from a SharePoint site you can follow the steps below:

  • Ensure that the user account performing the process is a member of the farm administrator group.
  • In Central Administration, on the Home page, click Backup and Restore on the left hand menu.
  • On the Backup and Restore page, in the Granular Backup section, click on the Export a site or list option.
  • On the Site Or List Export page, select the appropriate web application, site collection and list that you want to export.
  • In the File location section enter the UNC path of the export folder. This should be a share on either the server or another network location.
  • If the file already exists and you want to overwrite this, then select the Overwrite existing file check box.
  • Select the Export full security check box if you want to export all the security and permissions settings with the select list or library.
  • Click on the Start Export button when you are happy with the selected options.


SharePoint 2010 – “Installation of this product is not permitted on this computer. Please contact your network administrator for more details.”

If you have the following entry in the register of the target server:

HKLM\Software\Policies\Microsoft\Shared Tools\Web Server Extensions\14.0\ SharePoint\DWORD DisableInstall

DWORD DisableInstall=00000001

Users who try to install SharePoint 2010 on that server will receive the following error message:

“SharePoint installation is blocked in your organization. Please contact your network administrator for more details.”

You will need to set

DWORD DisableInstall=00000000

to allow installation of SharePoint 2010.

SharePoint 2010 support for Windows Server 2012

Currently, Microsoft SharePoint Server 2010 is not supported for installation on computers running the Windows Server 2012 operating system. Installing SharePoint Server 2010 on a computer that is running Windows Server 2012 could lead to unexpected behavior, therefore, Microsoft does not support SharePoint Server 2010 in Windows Server 2012. SharePoint Server 2010 with Service Pack 2 and SharePoint Foundation 2010 with Service Pack 2 will offer support for Windows Server 2012. The release date for Service Pack 2 for SharePoint Server 2010 and SharePoint Foundation 2010 is to be determined.