bookmark_borderSetting Max memory usage in SQL Server

When running SharePoint locally it is a good idea to control the memory usage of SQL. To do this use the SQL query below.

[code lang=”sql”]
sp_configure ‘max server memory’, 1024
RECONFIGURE
GO
[/code]

A good article that goes through some of the areas you need to look at in relationship to memory is located at: http://www.eraofdata.com/blog/2008/10/sql-server-memory-configuration/

Sytone

I’m a principal engineer working at Microsoft. I have run and supported services for over twenty years and worked in multiple countries. I love working with passionate people and new technology.

bookmark_borderGetting the Central Admin URL for a Farm in SharePoint

Toy CarI recently needed to get the Url of the CA for a SharePoint farm, after a bit of hunting in the API it was tracked down under the SPAdministrationWebApplication object.

C#

[code lang=”csharp”]
SPAdministrationWebApplication caWebApp = Microsoft.SharePoint.Administration.SPAdministrationWebApplication.Local;
var url = caWebApp.Sites[0].Url;
[/code]

PowerShell

[code lang=”ps”]
$caWebApp = [Microsoft.SharePoint.Administration.SPAdministrationWebApplication]::Local
$caWebApp.Sites[0].Url
[/code]

Sytone

I’m a principal engineer working at Microsoft. I have run and supported services for over twenty years and worked in multiple countries. I love working with passionate people and new technology.

bookmark_borderLooking for Objects in the SharePoint Deployment failed log.

SharePoint Content Deployment can be a fun beast at times, this article will walk you through a approach for resolving issues.

While working with a client we had the following error in a incremental job:

The object has been updated by another user since it was last fetched

Since the client was not on the latest patch level and unable to patch at this point in time I want to see if I could resolve it out manually. The problem was I dod not know which site they had edited and replaced the default page on.

Running the job it was failing at object 1829, being the lovely SharePoint that it is I have no way to workout what object is at 1829… or do I?

If you have the system setup to leave the failed cabs on the destination server you can open them up and look for the Manifest.xml files. Once you have these copy them to a place on the system.

The following powershell commands will allow you to find the object that it stopped on so you can resolve it, delete it or recreate it.

PS C:\> [xml]$man1 = get-content .\Manifest.xml
PS C:\> [xml]$man2 = get-content .\Manifest1.xml
PS C:\> $man1.SPObjects.SPObject[1829]
Id              : 2f93cb16-fae5-4344-8549-3f6c5de60863
ObjectType      : SPDocumentLibrary
ParentId        : b677f641-222c-4185-9cf4-e916174b316b
ParentWebId     : b677f641-222c-4185-9cf4-e916174b316b
ParentWebUrl    : /SiteCollection/SubSite
Url             : /SiteCollection/SubSite/Pages
DocumentLibrary : DocumentLibrary
admin

Please enter the biographical info from the user profile screen.