Thursday, December 18, 2014

Quick Rest Interface samples to reuse

SP2013
http:///site/_api/lists
http:///site/_api/web/title
http:///site/_api/lists/getbytitle('listname')
http:///site/_api/lists/getbytitle('listname')/items
http:///site/_api/lists/getbytitle('listname')?select=Title
http:///site/_api/lists/getbytitle('listname')/Lists (POST)
Body
{
'_metadata':{'type':SP.List},
'AllowContentTypes': true,
'BaseTemplate': 104,
'ContentTypesEnabled': true,
'Description': 'My list description',
'Title': 'RestTest'
}

http:///site/_api/lists/getbytitle('listname')/lists/getbytitle('listname')/items (POST)
Body
{
'_metadata':{'type':SP. listnameListItem},
'Title': 'MyItem'
}

SP2010
http:///_vti_bin/ListData.svc
http:///_vti_bin/ListData.svc/ListName
http:///_vti_bin/ListData.svc/$metadata
http:///sites//_vti_bin/listdata.svc/TestData(2)
http:///sites//_vti_bin/listdata.svc/TestData?$orderby=FieldName
http:///sites//_vti_bin/listdata.svc/TestData?$filter=FieldName eq 'testval'

References :
http://msdn.microsoft.com/en-us/library/office/jj164022(v=office.15).aspx
http://msdn.microsoft.com/en-us/library/office/ff521587(v=office.14).aspx

Tuesday, December 16, 2014

SharePoint Internal Load Balancing and Network load balancing

SharePoint Internal Load Balancing -  SharePoint internally manages service request load by its inbuilt "Application Discovery and Load Balancer Service". By default it works with Round Robin algorithm but can be customized as needed.

Network load balancing -
Also servers in the farm can be load balanced with pair of backup servers. In this case, if any of the server in SharePoint farm goes down the backup server will fill that up.

Came across few interesting links -

http://blogs.technet.com/b/meamcs/archive/2012/05/29/prepare-sharepoint-farm-part-3-prepare-nlb-for-sharepoint-web-front-end-wfe-servers.aspx

http://community.bamboosolutions.com/blogs/sharepoint-2013/archive/2014/01/10/network-load-balancing-for-sharepoint-2013-part-one-how-to-display-network-load-balancing-manager-in-windows-server-2008.aspx

https://www.martinhatch.com/2014/05/sharepoint-2013-reference-sheet-services-on-server.html

Monday, October 27, 2014

Add/Remove Dlls from GAC in Windows Server 2012

http://camerondwyer.wordpress.com/2013/05/22/how-to-install-a-dll-to-the-gac-on-windows-2012-using-only-powershell-without-having-to-install-sdk-or-visual-studio/

Recover SharePoint config database from Suspect/Recovery mode to online state

Follow the steps given below in sequence one after another-

Steps
1.
use master
EXEC sp_resetstatus 'SharePoint_Config';
2.
ALTER DATABASE SharePoint_Config SET EMERGENCY
3.
DBCC checkdb('SharePoint_Config')
4.
ALTER DATABASE SharePoint_Config SET SINGLE_USER WITH ROLLBACK IMMEDIATE
5.
DBCC CheckDB ('SharePoint_Config', REPAIR_ALLOW_DATA_LOSS)
6.
ALTER DATABASE SharePoint_Config SET MULTI_USER

Monday, August 4, 2014

Import ULS logs in Database


Sometime it is difficult to load huge amount of ULS logs in ULSviewers so the tool provide feature to import GBs of ULSLog files in database and use traditional SQLQuery to analyze it further.


http://spstools.codeplex.com/releases/view/93135

Wednesday, March 19, 2014

Windows Server 2012 - User access control settings


Grant local admin rights-

http://wp.sjkp.dk/windows-8-windows-server-2012-uac-grant-local-admin-rights/