Using SqlConnectionStringBuilder in PowerShell

I wanted to use the SqlConnectionStringBuilder object in the SqlClient area but was having issues accessing the properties. The Object itself is just a collection with a key value structure.

To access the keys use the following PowerShell code:

$builder = New-Object System.Data.SqlClient.SqlConnectionStringBuilder
$builder.Keys

To set a property just use the key as a reference. For example:

$builder["Data Source"] = $server
$builder["Initial Catalog"] = $database
$builder["Encrypt"] = $true
$builder["TrustServerCertificate"] = $false
$builder["User ID"] = $login
$builder["Password"] = $password

New Toy! Eee PC T101MT

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:

New Toy! Eee PC T101MT

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:

Deleting Content Types in SharePoint

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.

When is true not true?

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.. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=455553&wa=wsignin1.0 http://blog.dotnetwiki.org/2009/05/29/TamingThePexBeastWellbehavedEnumsMultidimensionalArraysAndBooleans.aspx

Toodledo DF - Update

Information can be found on: http://blog.sytone.dev/toodledo-distraction-free/

ToodleDo DF Update

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

You can get the update here: http://blog.sytone.dev/toodledo-distraction-free/ Changes:

• Added Focus mode which will grey out the background so you just have your toodledo list.
• Updated the hover icons.

A hunting we will go!

Had a great day today, went for a walk up the mountain with the family and gave geocaching a spin. The kids enjoyed it. We did GC14179 and then tried to find GC18JGE but were not able to. Anja was not amused… On the way back down the mountain we found GC2498 and a great view. The kids bugged me to find another one so we did GC13C0A. This was better as I got the geocache app for my HD2 up and working this time. Much easier.

Visual Studio 2010 and .NET Framework 4 Training Kit - January Release

If you are looking at catching up with the VS2010 Beta 2 and Framework 4.0 world there is a free training kit avaiable at: http://www.microsoft.com/downloads/details.aspx?FamilyID=752CB725-969B-4732-A383-ED5740F02E93&displaylang=en In additiona Channel 9 is also running some courses. http://channel9.msdn.com/learn/courses/vs2010/