Sytone's Ramblings
Me, Family, Life
Setting Max memory usage in SQL Server
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/
Getting the Central Admin URL for a Farm in SharePoint
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.
C#
SPAdministrationWebApplication caWebApp = Microsoft.SharePoint.Administration.SPAdministrationWebApplication.Local; var url = caWebApp.Sites[0].Url;
PowerShell
$caWebApp = [Microsoft.SharePoint.Administration.SPAdministrationWebApplication]::Local $caWebApp.Sites[0].Url
New Toy! Eee PC T101MT
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:
- Office 2007 + Language Packs – Will install Office 2010
- Trend Micro Security – Will install MS Security Essentials
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.
Deleting Content Types in SharePoint
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:
- All items using the type are deleted (and deleted from the recycle bin)
- The Content type is removed from any list using it.
- Any Page Layouts using the type nolonger reference it.
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
When is true not true?
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..
Toodledo DF – Update
May 27th
Information can be found on: http://www.sytone.com/toodledo-distraction-free/
ToodleDo DF Update
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.
Updated Toodledo Distration Free
May 19th
You can get the update here: http://www.sytone.com/toodledo-distraction-free/
Changes:
- Added Focus mode which will grey out the background so you just have your toodledo list.
- Updated the hover icons.
Enabling the query builder for outlook views
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:
- Click Start and point to Run. In the Run dialog box, type Regedit, and then click OK to launch the Windows Registry Editor.
- In the Registry tree, navigate to
HKEY_CURRENT_USER\Software \Microsoft\Office\12.0\Outlook. - From the Edit menu, select New, and then select Key.
- In the Key edit box, type QueryBuilder. Regedit will suggest New Key #1, but you should replace that key name with QueryBuilder.
Why Procmon is a great tool!
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!
