Sytone's Ramblings

The occasional posts of a guy who plays with technology.

Setting Max memory usage in SQL Server

2010-07-30 1 min read Technology
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/

Getting the Central Admin URL for a Farm in SharePoint

2010-07-30 1 min read Technology
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]

Looking for Objects in the SharePoint Deployment failed log.

2009-04-08 2 min read Technology
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. Continue reading