Sunday, August 30, 2009

Flickr RSS Feeds. Too big, too small

Read More

In this article about using slideshows in wordpress I showed you how to embed slideshows in Wordpress blog posts and sidebars using the Google Ajax Feed API.


I prefer to use this facility to pull in Image feeds from Flickr.


The problem with the images in these feeds is that they’re either too large or too small.


The MediaRSS specification has a tag which lets you have a thumbnail image in your feed. That’s great, but the image size of the thumbnail is 75×75 pixels, which is useless for a nice looking slideshow. It ends up looking terribly blurry with no detail.


The Google Ajax Feeds API tries to get around this by letting you specify a “thumbnailTag” in the slideshow options object. Basically, you set this to “content” to tell the API to look for the image in the “content” section of the feed, rather than the section. This is also great, but the problem is that Flickr uses the LARGE (or even worse, ORIGINAL) image size in this section. So you get nice large detailed images in the feed, but they’re so large that they take ages to load, and your slideshow sits there for ages saying “Loading….” while it grabs the huge images and chews up your audiences bandwidth.


So I wrote a simple PHP screen scraping utility which grabs the Flickr feed, and changes the ImageUrl…_L.jpg to ImageUrl….M.jpg – in other words, it modifies the feed to include the medium size image rather than the large size.


Medium sized images are fine for slideshows, and they load quite quickly.


Here’s the PHP code:



<?php
date_default_timezone_set('UTC');
$uri="";
$first_var = "1";
foreach($_GET as $variable => $value)
{
if ($variable == 'uri')
{
$uri = $uri . $value;
}
else
{
$uri = $uri . "&" . $variable . "=" . $value;
}
}
header("Content-Type: application/xml; charset=ISO-8859-1");
$ch = curl_init() or die(curl_error());
curl_setopt($ch, CURLOPT_URL,$uri);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$data1=curl_exec($ch) or die(curl_error());
$data1=str_replace("_s.jpg","_m.jpg",$data1);
$data1=str_replace('height="75"', "",$data1);
$data1=str_replace('width="75"', "",$data1);
echo $data1;
echo curl_error($ch);
curl_close($ch);
?>


Just save this in a file named FlickrRSS.php in the top folder of your wordpress directory. Then instead of using your flickr RSS feed, pass the feed as a query parameter to the PHP utility.


You’ll need to change the <> tags in the file to <>.


So if your feed URL was this:

http://api.flickr.com/services/feeds/photos_public.gne?id=8575807@N07&lang=en-us&format=rss_200


Use this instead

http://YourBlogUrl/FlickrRSS.php?uri=http://api.flickr.com/services/feeds/photos_public.gne?id=8575807@N07&lang=en-us&format=rss_200


This will change the tag to point to the lager sized image, so your slideshows will load quickly, and look nicer :)



Sunday, August 02, 2009

Cool technology

Read More
Six and mean

Lilly came in to my office the other day. “Dad I have to go out now. Can you get the TV to record my favourite show in an hour”.


“Hmmmm????”, I replied in typical pre-occuipied father mode.


But she had an intensity in her eye that made me realize I ignored this six year old at my peril, despite my displike of leaving my desk while in the middle of solving a problem.


Happily, I didn’t have to get up from my chair. I just logged in to IceTV, found the program she was interested in, and told my PVR to record it via the website.  My PVR is a High-Definition Beyonwiz DP-S1. It’s wireless, but I’ve wired it in to the house LAN so we can watch movies from our D-Link DNS323 1TB NAS


We also have an older Topfield 5000 PVRT.  It’s only standard definition, but the cool thing about it is that it has an open programming interfacem , so a lot of people have written their own software to get it to do cool things.  One application I added to it was ToppyPC by John De Angelis.  It has a program called “TWIN” which adds a web page to your Topfield PVR.  So you can set timers, and record shows, like IceTV lets you do with the Beyonwiz.   ToppyPC needs another utility to run – an FTP server (ftp4t by Aldarin) which runs on a PC which I connect to the Topfield via a USB cable.


All this technology is both good and bad. It’s convenient, but I don’t get the exercise I need going up and down stairs to program the PVR!


But at least I don’t have an angry six-year-old to contend with!


Monday, July 27, 2009

Some amazing facts

Read More



I just watched this fascinating Youtube video. The world is an amazing place!


Friday, July 17, 2009

My Inbox

Read More
Neil's empty inbox - a rare event

Neil's empty inbox - a rare event


 


Isn’t this beautiful?


I haven’t seen an empty inbox for years, and I love it! When it’s full I feel like I have the cares of the world on my shoulders. But when it’s empty, it’s like I’m making progress. Even if it might be illusory, I like that feeling.


So I’m going to persist in my strategy which can be described simply as:

If it’s junk, get rid of it.

If it’s someone elses problem, forward it.

If it’s worth reading, read it now, then delete it.

If it needs more info, request more info and delete it.

If it needs acting on, then act on it now, then delete it.


Monday, July 13, 2009

Slideshow from RSS for Wordpress

Read More




Loading…


It took me hours to find, but the easiest way I found to build a slideshow from a MediaRSS feed and add it to a WordPress blog was using the Google Ajax Feed API.


There are a few plug-ins that are supposed to work with WordPress, but I didn’t like them because they were really limited, or didn’t work on an IIS hosted blog. Good old Javascript, although it’s verbose, works fine.


That’s what I’ve used on this blog. Have a look at the slideshow on the lower right. It’s generated by the Google Ajax Feeds API.


If you don’t like getting your hands dirty with JavaScript, the best Flash based slideshow generator I know of is at VuVox.com. That’s what I use for some of the ObSrv examples of slideshows here.


The beauty of building a slideshow from an RSS Feed is that you don’t need to have the images on your own site, and the content updates continually as more items are added to the feed.


Of course, sometimes it’s hard to find a good feed. That’s where ObSrv.com comes in, because it can generate a feed from a google images search.


So when you use the Google Ajax Feed API and ObSrv.com you can make a slideshow of any topic you’d like. The one on this site is for “Information Technology”.


And just to make this post pretty, I thought I’d include a slideshow of the most recent ten pictures from the Creative Commons group on Flickr


Sunday, July 12, 2009

We've Moved!

This blog has moved!
The new address is


Please update your browser and RSS reader to the new links. All of my existing articles have moved too.

I'm now using WordPress as my blogging platform, and really like it.

If you've got any comments or suggestions, please let me know.

Thursday, May 21, 2009

Using Twitter

A few friends have asked me to explain twitter.

Rather that re-invent the wheel, I thought I'd upload a few links that explain what it's all about.

1. The official Twitter Help Resources / Getting Started

2. How to Use Twitter Without Twitter Owning You - 5 Tips (Tim Ferriss)

3. How to Use Twitter (Darcy Logan, includes great short video)

4. Newbie's guide to Twitter

5. Twitter Fan Wiki (Sort of like Wikipedia for Twitter)

6 HashTags

Actually HashTags deserve a post all of their own. I'll post something about that later.

I hope these links help. The bottom line for Twitter I think is to follow people who have something interesting to say. Don't just follow anyone, because then the interesting comments will get drowned out with "noise".

And the converse is that it's important make your posts useful. Say stuff that will be interesting to people who follow you. Here's some examples of people who post some really great twitter articles:

@Astro_Mike An Austronoaut tweeting from orbit
@tferriss Author and blogger on lifestyle design
@612brisbaneMy local ABC radio station

Oh, and if you're interested, I'm on twitter as @NeilEnnis

Sunday, March 22, 2009

ObSrv: Server Problems Fixed

I apologise for the unavailability of ObSrv.com over the last few days.

Our server failed, so we bought a new server, which also failed.

Not being one to give up easily, I've been on this issue since Friday lunchtime, and am relieved to say that as of about 10pm last night, everything is now working fine.

On the bright side, we have a larger, faster server so things should run much better than before.

Wednesday, February 25, 2009

RSS Feed Do's and Don'ts



To the right you can see a screen shot of three RSS feeds as seen on my iGoogle page. Two of them are good, one of them is not so good. Can you tell the difference?

They're all really specific in nature. The first one just shows breaking news as reported by the ABC. The second shows recent posts made be people about cruises in Australia via the CruiseCritic.com message boards, and the third shows new posts to the "General Cruise Discussions" section of the OzCruiseCritics message boards.

With the ABC feed, whenever there's a new story, it appears at the top of the list, pushing older stories off the bottom of the list.

Same with the Cruise Critic feed (the 2nd one). As a new post is received on a particular subject, that subject goes to the top of the list, pushing older ones off the bottom.

The problem with the third feed ("General Cruise Discussions") is three-fold:

1. The name of the feed doesn't do OzCruiseCritics justice. Anyone casting a quick glance at the feed doesn't know where it's from. With the first two feeds on this example, it's quite plain who's supplying them, but not the third feed.

2. The discussion topics are not formatted properly. The name of the feed is repeated in each of the item descriptions. E.g. you see "General Cruise Discussions :: Re: Queensland Cruise" and "General Cruise Discussions :: Re Snorkelling". This is redundant. We already know what feed the item is coming from by looking at the title of the feed. Each of these items should have a more concise description. In this case they should be "Queensland Cruise" and "Snorkelling".

3. You can't see it from the picture, but take my word for it, whenver someone replies to a topic on the OzCruiseCritics feed, it generates a new feed item. So if I was to reply to the "Snorkelling" discussion, the feed would end up looking like this:
General Cruise Discussions :: RE: Snorkelling
General Cruise Discussions :: RE: Queensland Cruise
General Cruise Discussions :: RE: Snorkelling

I think that is crowded and difficult to read. What should really happen is that if an item is updated, it goes to the top of the list, and the old version of that item is removed from the list. So the feed should look like this:

Snorkelliung
Queensland Cruise

These suggestions might seem pedantic, but the whole aim of RSS is to get your content read. Whish means the info needs to pack as much punch as possible, with as little clutter as possible. The reward for this is that your message gets out, more people hear what you say, and you get more traffic to your site.

Wednesday, February 04, 2009

ObSrv: Improved image search

I just fixed a couple of minor bugs which were preventing ObSrv from serving up images based on advanced google image searches.

They should be working ok now.

If you still have any problems, please let me know or reply to this post.

Friday, January 30, 2009

ObSrv: Getting an RSS feed from ANY site with images

I mentioned earlier that I'd modify ObSrv to be able to generate an RSS feed from any site that has images.

I didn't realize it, but it already does this.

Just key in the search words, followed by site:yourdomain.com

For example, if you want a feed of all images of the planet Saturn from Nasa.gov, just type in:
Saturn site:nasa.gov

Or for a feed of all images of Antarctica from NationalGeographic.com, type in:
Antarctica site:nationalgeographic.com

How cool is that?

Thursday, January 29, 2009

ObSrv: Some example image feeds

Here's some slideshows built on image feeds from ObSrv. If you've got some you'd like to show the world, please send an email to mail {at] ObSrv [d0t} com and I'll be happy to showcase it here for you.





Sunday, January 25, 2009

ObSrv: Watching the World

I've just completed a project called "ObSrv" which will convert Google Image Searches into MediaRSS compliant RSS feeds.

If you don't know what an RSS feed is, perhaps you should read this, or this. I love RSS because it's an easy way to let other people know what you're doing, and to find out news that is of specific interest to you. This blog (like almost all others) has an RSS feed. Most news sites and picture sharing sites have RSS too. This makes it easy for you to show their content on your website, or to view their content in an RSS reader.

If you don't know what MediaRSS is, you might want to read the specification. Basically, it's for a special type of RSS feed that contains media, such as pictures, video, and music. These feeds are cool because pictures, videos and music are much more entertaining than plain text. You can do more with them. For example, there's a slideshow on the right hand side of this blog that updates every few seconds with pictures of hi-tech gizmos. It's based on a Media RSS feed.

My favourite Media RSS application is John's Background Switcher. It updates the wallpaper on your computer desktop with pictures from a Media RSS feed.

My only problem with Media RSS is that the biggest source of images on the web (Google Images) doesn't serve up their image searches as an RSS feed. Which means that while you can search for images at google, you can't automatically feed them into a media RSS application.

That's where ObSrv comes in. It converts a Google Image search into a Media RSS feed.

Here's how:
  1. Go to http://obsrv.com/

  2. Type a few search words in the box. (Hint. If you want, do an advanced search in Google Images, and copy the Google Images URL into the box instead).

  3. Press ENTER or click on the "GO" button.

  4. ObSrv will give you the link to your feed.

  5. Click on the link to open the feed in a new window, or copy the URL for the feed from the textbox.

Here's some links to some applications that you can use with RSS Image Feeds:

John's Background Switcher (Windows desktop background switcher)

Vuvox (Slideshows)

Feed Reader

RSS Popper

What's Next?

I'll be adding functionality to ObSrv as time permits. My next task is to get it to convert any webpage containing images into an RSS Image Feed.

Monday, September 08, 2008

Outlook not showing embedded images

Sometimes when I received an email in Outlook with an embedded image, the image would not display, but I'd just see a white rectangle with a small red "X" in it instead.

This was nothing to do with the outlook security settings.

To fix the problem, I deleted the following registry key:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Outlook\Security\OutlookSecureTempFolder

After I deleted it, I restarted outlook, and my images now appear fine.

Monday, September 01, 2008

Schizophreinc Blogs!

I have a schizophrenic blog. Some days I upload copies of postcards that I receive. Other days it's info about migration to Australia in the 60's. And then it might be some photos of family and friends.

So it's a bit of a mixed bag.

Which is fine by me. My attention gets pulled all over the place, and I get interested in lots of different things. A bit like Homer Simpson walking through a shopping mall :)

But it could make life hard for my readers, so I recently added a little Javascript widget that makes the blog change its appearance depending on what interests you. Coupled with judicious use of blogger labels, it works wonders.

It's the same blog, but it changes shape depending on how you get to it.



Have a look at these two different links to see what I mean.

First if you're interested in Postcards go to the blog via the URL: http://neilius.blogspot.com/search/label/Postcards?pcd=1.

Second if you're interested in Ten Pound Poms go to the blog via the URL: http://neilius.blogspot.com/search/label/Ten%20Pound%20Poms?tpp=1.

(Hint for the uninitiated "Ten Pound Poms" were migrants who came to Australia from Britain between 1950 and 1971).

There are two cool bits to this.

The first is that you get a totally different set of links at the top of the blog depending on how you view it. I do this by adding some query string parameters to the URL. (The "?pcd=1" or "?tpp=1" parts of the URL).

Secondly, using labels in the URL lets me control what articles appear when you visit. (That's what the "/search/label/..." bit of the URL is all about).

You might think using query strings on your URL is a messy way to get to your blog. But it's really easy to set up a domain and (using something like ZoneEdit's "webforward") point that domain to a more complex URL.

For example, http://TenPoundPoms.com and http://Postcards.NeilEnnis.com both point to the same blog, but I've used ZoneEdit to add different parameters to the URL query string.

A small Javascript widget at the top of the blog looks at the query string, and decides what sort of links to display. Basically it's saying "If you've come here to look at postcards, I'll show you some postcard links. But if you're interested in Ten Pound Poms, then I'll show you some different links instead.

Here's the code. The Orange section is a javascript function to pull the query parameter out of a url. The Green section controls what gets displayed when people are interested in "Ten Pound Poms". The Blue section is what gets displayed when people are interested in "Postcards".


<script>
function gup( name ){ name = name.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]"); var regexS = "[\\?&]"+name+"=([^&#]*)"; var regex = new RegExp( regexS ); var results = regex.exec( window.location.href ); if( results == null ) return ""; else return results[1];}
</script>

<script>
var tpp_param = gup( 'tpp' );
var pcd_param = gup( 'pcd' );
if(window.location.href == 'http://neilius.blogspot.com/search/label/Ten%20Pound%20Poms')
      tpp_param = '1';
if(window.location.href == 'http://neilius.blogspot.com/search/label/Postcards')
      pcd_param = '1';
if(tpp_param == '1')
{
      document.write('<div id="tpp-info" class="sidebar section">');
      document.write('<h2 class="title">Ten Pound Poms</h2>');
      document.write('<a href="http://neilius.blogspot.com/search/label/Ten%20Pound%20Poms?tpp=1">Home</a> Ten Pound Poms | ');
      document.write('<a href="http://neilius.blogspot.com/2008/07/about-tenpoundpomscom.html?tpp=1">About</a> Ten Pound Poms | ');
      document.write('<a href="http://neilius.blogspot.com/2008/08/links-for-ten-pound-poms.html?tpp=1">Links</a> for Ten Pound Poms<br/>');
      document.write('<a href="http://neilius.blogspot.com/2008/08/migrant-ships.html?tpp=1">Migrant Ships</a> - How we got here<br/>');
      document.write('<a href="http://neilius.blogspot.com">Musings</a> - Back to the main blog');
      document.write('</div>');
}

else if(pcd_param == '1')
{
      document.write('<div id="pcd-info" class="sidebar section">');
      document.write('<h2 class="title">My Postcards</h2>');
      document.write('<a href="http://neilius.blogspot.com/search/label/Postcards?pcd=1">Home</a> - My Postcard Blog | ');
      document.write('<a href="http://neilius.blogspot.com/2008/05/about-my-postcards.html?pcd=1">About</a> My Postcards | ');
      document.write('My Postcrossing <a href="http://www.postcrossing.com/user/Neilius" target="_blank">Profile</a><br/>');
      document.write('<a href="http://postcrossing.com" target="_blank">Postcrossing</a> - A great way to send and receive postcards<br/>');
      document.write('<a href="http://flickr.com/photos/magictyger/sets/72157604961465429/" target="_blank">Postcard Collection</a> at Flickr<br/>');
      document.write('<a href="http://neilius.blogspot.com">Musings</a> - Back to the main blog');
      document.write('</div>');
}

</script>

Wednesday, July 02, 2008

More algebra

A couple of years ago, in this post I published the formula for calculating loan repayments based on rate, PV, FV and interest rates etc.

I mistakenly said that you couldn't arrange the formula to give an expression which would calculate the TERM given the other values.

I was wrong.

Here's the formula:
NPER = LOG((PMT*(1+RATE*TYPE) - RATE * FV) / (PMT*(1+RATE*TYPE) + @RATE*PV)) / LOG(1+RATE)

FV is the "Future Value" of an investment assuming an initial investment (PV), constant repayments (PMT) and a constant interest rate (RATE) over a fixed term of months (NPER). When "TYPE" is zero, loan repayments are made in advance. When "TYPE" is 1, loan repayments are made in arrears.

It yields a non-integer result. The result should be rounded up to the next highest integer, with the value of the final repayment reduced.

If I get time I'll post a formula for the final repayment later.

Saturday, December 22, 2007

Where did my money go?

The Money Tracker
www.MoneyTracker.com.au is a great site that lets you track the location of your bank notes after you spend them.

Basically you go to the money tracker web site, and enter the serial number of any bank notes (cash) you have. Then you just spend them like you normally do. Eventually, someone else will get the note, enter it into money tracker which then notifies you of the new location of your bank note.

This fascinating idea was inspired by the US website http://wheresgeorge.com/ which lets you track U.S. bank notes.

Now all we need is some sort of machine that can help us get our money back after we spend it :)

Sunday, December 16, 2007

Sir Arthur C. Clarke 90th Birthday Reflections



Scince fiction writer and visionary Arthur C Clarke turned 90 on Sunday.

Best known for his blockbuster "2001: A Space Odyssey", he also wrote numerous other books and short stories.

I've devoured most of his works since I was 11 years old, amd marvelled at Clarke's optimistic vision of the future, and what we could achieve as a species. He made the future exciting. I couldn't wait for it to happen, and still can't :)

I hope you stay around till you're at least 100, Sir Arthur. We need more optimistic vision like yours.

Sunday, October 07, 2007

What's cool, what's not?

Technology is cool.

There is so much new cool stuff you can do these days.

Here's just a few:

ShipWatcher - a new website I created that lets you look at the webcams of cruiseships, view their progress on a map, and take photos of ships you like. Every hour ShipWatcher picks webcams that it thinks are "interesting" and take a couple of photos, automatically uploading them to....

Flickr - a fantastic service, from Yahoo that lets you share photos with other people, place them on a map, group them into sets and collections, pool them into groups with other people, and even track the type of camera that took the photo - to help you choose your next camera. I even used Flickr to share some great looking Photo Mosaics that I generated with...

Andrea Mosaic - a clever little utility which lets you generate mosaic pictures like this one I did, from pools of photos that you might have. In fact, if you have large pools of photos, you might be interested in...

Photosynth - amazing new technology from Microsoft that pools photos, organizes them in relation to each other, and lets you view a 3-d model of the real world, by aggregating thousands of photos. This really has to be seen to be beleived. I have a copy of it on my main machine which runs....

VMWare -fantastic software that lets you build "virtual" computers. You can configure a number of different types of computers with different amounts of memory, diskspace, networking abilities, each of which can run a different operating system like Windows XP, Linux, Vista, DOS, and run them all at the same time. You can even get your virtual machine to take a snapshot of itself. Do some risky stuff, and then if you don't like the result, rollback your machine to the state it was in when the snapshot was taken. Great for demos, when you want the demo to revert back to its previous incarnation when you're finished. If you have a laptop, copy your virtual machine from your desktop to your laptop, and it's ready to go. Everything on the laptop is the same as when you last used it on your desktop. So easy to backup too. Just copy the virtual disk (one file). I use VMWare to do all my software development, including a cool web development tool called...

Iron Speed Designer - easy to use software that lets you quickly generate websites based on any existing SQL, Oracle or Access database. I've never developed websites before, and Ironspeed made it easy to look like a pro. Great stuff.

It seems things just keep getting better. Life gets easier for us. We can do more, in less time.

BUT. Some things aren't cool. They make life harder. They suck. Even some things that are cool can suck. For example....

Iron Speed Designer - although a great tool, decided that they didn't like people using their software inside a virtual machine. Aparently some people were using the flexibility of virtual machine software such as VMWare to defeat the copy protection mechanism. So the folks at Ironspeed decided they'd put a limitation in version 5 of their software that makes it refuse to run on a virtual machine.

You may think "so what?". But think about what this means. If you've got your entire development environment inside a virtual machine. And one of your development tools stops working in that machine. What do you do? Uninstall it and move it to a real machine I suppose.

But I use MS Visual Studio in conjunction with Ironspeed. So I suppose that would have to come out too.

Then, to make it consistent, I suppose all my Visual Studio projects would have to come outside the virtual machine.

And then - what happens if I want to go out of town for a week and take my laptop. How do I easily move all this stuff from desktop to laptop?

The Virtual machine becomes useless. All because Ironspeed doesn't like you using their products in a virtual machine.

So one software supplier digs their heals in over technological innovation. Where will this end?

I predict one of two things will happen:

1. Ironspeed will see the error of their ways, repent, and their next version will run inside a virtual machine. Probably with some sort of licensing service that runs on a physical machine to police the licensing policy.

2. As more developers start using virtual machines, another software vendor will release an alternatuve web development utility, that does what Ironspeed does - except the new software will run inside a VM.

People who work in the technology industry can't run away from technological innovation. Or they will end up being people who USED to work in the technology industry. Technology is all about innovation. Anyone who wants to stay in the technology industry needs to embrace innovation, not shun it.

So, here's my message to Alan Fisher and the great guys at Ironspeed: You guys have a fantastic product. I love it. It's brilliant and makes my life easier. It's worth every cent that I paid for it. But if you want me to chose between Ironspeed and my Virtual Environment, then I'll chose the latter. I want my technological life to be easier, not harder.

Please change your mind.

UPDATE December 2007. The folks at Ironspeed have responded to user requests, and removed the restriction on ISD running in a virtual environment. Fantastic decision, guys. A great product just got even better. Thanks for listening to us!

Friday, September 14, 2007

SSL / HTTPS stops working on localhost under IIS 5.1

I have an ASP.NET web application that uses SSL.

The other day it stopped working on my development machine (Win XP Pro SP2). Whenever I tried to navigate to the SSL page my browser said it couldn't find the page.

I spent hours trying to google an answer to this problem.

The thing that finally fixed it was.... (drum roll)... a reboot.

Now here's the proof that I've taken leave of my senses. My colleague had the same problem a few days ago. I helped him resolve it, and even suggested the reboot solution. It worked for him. But today when this problem happened to me, I forgot all about that episode, and wasted time until I came up with the same solution. Again.

I must be getting old.

Incidentally, if you need an SSL certificate for testing purposes, try Microsofts SelfSSL utility. It creates the certificate and installs it for you.

It's available at https://www.microsoft.com/downloads/details.aspx?familyid=56FC92EE-A71A-4C73-B628-ADE629C89499&displaylang=en or search for "Internet Information Services (IIS) 6.0 Resource Kit Tools".

IMPORTANT UPDATE: Microsoft's SelfSSL utility will cause MSDE to stop working. It tries to install certificates in the SQL Server which makes it impossible to connect to.