Setting 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/

July 30, 2010 · 1 min · Jon Bullen

Getting the Central Admin URL for a Farm in SharePoint

I 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]

July 30, 2010 · 1 min · Jon Bullen

Looking 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....

April 8, 2009 · 2 min · Jon Bullen