Batch operation on SharePoint List through code

Are are you dealing with huge data for CRUD operation on SharePoint list through code, then you have to skip the conventional SSO code to calling the list and list item collecton.

Looping the each item in the Item collection is querying the database.

So if there is 50000 items to be inserted on your SharePoint list, your code will call the DB query 50000 times. Its process intense and overhead on SQL server.

In such scenario consider to use the ProcessBatchUpdate method of SPWeb class and also ContentIterator API.

SharePoint 2013 App Visual studio error SQL Permission

If you are seeing this error in Visual Studio while developing the SharePoint hosted App model,


Error occurred in deployment step 'Install app for SharePoint': We're sorry, we weren't able to complete the operation, please try again in a few minutes. If you see this message repeatedly, contact your administrator.

Your account used to log in as user who developing the SharePoint app does not have necessary acess permission on the "App Management" service database.

If you are working on your local VM or DEV server, you are welcome to log in to SQL Server and add the user  as shown in this figure.

And give the db_owner and db_securityadmin on the schema owned by the user and also select the db_owner ,db_securityadmin and SPDataAccess on the database role membership.

Setting up your app domain configuration in SharePoint 2013

Setting up your app domain configuration for SharePoint 2013 may be little complex for the beginners and soon end up with mess.

I really found the easiest step by step explanation by Mirjam, SharePoint Server MVP.
She explained on how to create the DNS and forward lookup zone to host your apps in separated App Domain.

I strongly recommend not to rely on other sources including MSDN site, if you are a starter.

Visit the Mirjam's post's on how to configure app development on your server or local development.

http://sharepointchick.com/archive/2012/07/29/setting-up-your-app-domain-for-sharepoint-2013.aspx

Using HTML 5 in SharePoint 2010

You can leverage the power of HTML 5 features in your SharePoint Pages and custom pages.
By default, the master page "v4.master" page has been designed to work on XHTML guidelines for rendering the html controls and to be used work with IE 8.

So you need tweak this properties in your v4.master page.
In master page, leave the Register attributes as it is and add the above the html tag.

Secondly  change to IE=9 in meta tag's' content attribute that all, save the file, do check in and publish the major version.

SharePoint 2010 Migration Plan.

Before Database migration,points to be considered.
blogging from mobile phone. Please excuse for any type and format.


1. Remove unwanted site and site collection and also any unused customization.
2.Plan to split large site collection in to individual database.
3.Be ensure all Servers are running the same build version and list all patches,Cumulative updates are done in SharePoint and SQL servers.
4. Run the wizard configuration on every single updates on the server.

Search Index database SharePoint migration approach

Lesson learnt , One cannot upgrade the Search Index database from SharePoint 2010 to SharePoint 2013.
As SharePoint 2013 uses the FAST search engine by default.
So after upgrading the search content database you need crawl in SharePoint 2013.

SharePoint 2013 App - Remote Development

You don't have full pledge of SharePoint 2013 installation and configuration set up on your local machine.

Or you don't have SharePoint 2013 server or don't have sufficient hardware and software requirement for your SharePoint 2013, Still you can make it by connecting the SharePoint Server through remote app development (SharePoint hosted app and Provider hosted app).

I assume, you must have to OS windows 7 or Windows 8, Windows 8.1 either 64 bit or 32 bit.

All you wanted is , before gearing up your SharePoint App Development ,you must install the "SharePoint Sever 2013 Client Component SDK".

 This will install all the assemblies on your machine those required for connecting you the SharePoint server remotely.

Download the SharePoint Server 2013 Client Component SDK from here.

Learn..Explore and Cheers up !