Sytone's Ramblings
Me, Family, Life
Me, Family, Life
Jul 30th
When running SharePoint locally it is a good idea to control the memory usage of SQL. To do this use the SQL query below.
sp_configure 'max server memory', 1024 RECONFIGURE GO
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/
Jul 30th
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.
SPAdministrationWebApplication caWebApp = Microsoft.SharePoint.Administration.SPAdministrationWebApplication.Local; var url = caWebApp.Sites[0].Url;
$caWebApp = [Microsoft.SharePoint.Administration.SPAdministrationWebApplication]::Local $caWebApp.Sites[0].Url
Jun 22nd

Photo by ichibodI finally got me one of those new fangled netbooks with touch! I have been looking for a small form tablet PC for a while. So far it has been working as expected, the IO seems a little slow but I am uninstall a heap o apps and will defrag the poor thing shortly. The touch seems ok so far but I cannot wait to get OneNote 2010 on it to see how it rolls.
It seems to come with a bit of bloatware and has office 2007 pre-installed. So farm I have removed:
Ill see how the other applications go before removal.
They keyboard is nice and responsive which is a bonus, I was always dubious hitting the small keys with fat fingers but it seems fine so far.
Jun 22nd
I found this peice of SQL on the web a while ago, I have no idea where it came from but it did come in handy the other day when a client needed to delete a content type but kept on getting the message it was in use.
When deleting content types you need to ensure:
To help track down where the content type is in use the following query will help.
DECLARE @ContentTypeName nvarchar(128) SET @ContentTypeName='ABCC.CourtCasePage' SELECT w.Title AS [Web Site], w.FullUrl AS [Web Url], al.tp_Title AS [List Title], ct2.* FROM ContentTypes ct1 JOIN ContentTypes ct2 ON LEFT(ct2.ContentTypeId, Len(ct1.ContentTypeId))=ct1.ContentTypeId LEFT OUTER JOIN dbo.ContentTypeUsage ctu ON LEFT(ctu.ContentTypeId, Len(ct2.ContentTypeId)) = ct2.ContentTypeId LEFT OUTER JOIN dbo.AllLists al ON ctu.ListId = al.tp_Id AND ctu.WebId=al.tp_WebId LEFT OUTER JOIN dbo.Webs w ON al.tp_WebId = w.Id WHERE ct1.ResourceDir=@ContentTypeName
May 31st
When you look at true stored in the .Net framework.
While playing with Pex I found out a interesting fact that the bool is a byte in the MSIL. Which means that a bool could be euqal to anything on the byte range… Now this would require you to go out of your way and create unsafe code blocks to do this. Why you would do this… No ideas
Its marked as a no-fix which is not supprising as I would not fix it either becase as they say, if you know about this and you use it then you are on your own..
May 27th
Information can be found on: http://www.sytone.com/toodledo-distraction-free/
May 24th
Made a few fixes, I am also working on a simple API after dusting off some old work I had. This will allow interaction from the desktop and eventually a cached mode.
V 0.20.1005.2301
- Created link in options to edit css styles.
- Fixed issue where focus mode would not take window out of topmost mode.
May 19th
You can get the update here: http://www.sytone.com/toodledo-distraction-free/
Changes:
Apr 28th
You can use an undocumented Registry key to display a Query Builder tab on the Filter dialog box associated with the View Summary dialog box. After you use the Query Builder to construct your query, you can then copy the Filter syntax displayed on the SQL page and paste it into your code. Do not attempt to add the Query Builder page Registry setting unless you are familiar with the Windows Registry Editor.
To display the Query Builder tab of the Filter dialog box, follow these steps:
HKEY_CURRENT_USER\Software \Microsoft\Office\12.0\Outlook.Apr 27th
Procmon is created by sysinternals and should be deployed to any server in your enterprise (and desktop) it allows you to see what file, registry, network and processed & thread activity is happening on your system.
I just used to to work out why VS 2010 was not installing, it turns out it iterates through all the drives on your system including your mapped drives. As I had just been playing with WebDav I had a mapped WebDav drive which was very slow to access. Looking at proc mon I could see straight away what the issue was and I disconnected the drive.
Problem sovled!