Now you can get driving directions and choose “Bicycling” to get bike specific directions. That’s nice and all, but here’s the part that I like even better. Looking for more trails around Cherry Creek State Park? First, find the park at Google Maps, then click on “More…” and check the “Bicycling” box. All those green lines are the trails.

• Dark green indicates a dedicated bike-only trail;
• Light green indicates a dedicated bike lane along a road;
• Dashed green indicates roads that are designated as preferred for bicycling, but without dedicated lanes

This is going to be a great resource for finding and planning rides. I’m pretty stoked. Will it replace my paper map of the Denver area trails (sold via the Denver Bicycle Touring Club)? Nah, but it will definitely be the first place I start now.

Oh, and check out the Satellite view – the trails really “pop” in that view:

Related posts:

1. Maps.Amung.us
2. Windows Mobile GPS Apps?
3. TrackMe: A Quick Look

It turns out that SQL Server Management Studio has a nifty little option to speed up many, if not most, database tasks. Just find the Template Explorer under the View menu:
(note: my understanding is this is the same for 2005 and 2008 versions. The pictures below are from 2005)

This opens a new panel on the right side of SSMS (by default). Tons of tasks are listed. For instance, suppose you want to create a new table. Drill down to it and then double-click.

That leads to the template opened in a new SQL editor window.

But look at all those angle brackets. We’re not done quite yet. In the past I would start editing all those to replace my own values manually. Today Chris Randall showed me a better way while on a bit of a “side trip” during a test prep session.

Under the Query menu, select “Specify Values for Template Parameters…”

Now you get this slick little dialog. Set your values, click OK and you have a script ready to go.

Great tip, huh?

Check out the template list sometime, it is huge! I’m sure it is documented somewhere… but I couldn’t find a full list of all the stuff it holds.

Related posts:

1. SQL Server in the Cloud
2. Tiny Wi-Fi rant, New Meebo feature and SQL Server observation
3. One Week Full of SQL Server DTS Development

I hate to risk losing data or configurations so before I retire a server I convert it to a virtual machine. The same with employee PCs. When someone leaves, I convert it to a VM before it gets rebuilt for the next use. I can’t deny that this habit has saved more more than once over the past few years when you suddenly realize a key file only existed on Billy’s machine – and Billy’s old machine has been reloaded twice since he left! Just fire up the virtual machine and grab that file.

There’s a small wrinkle though. After converting servers and desktops to VMs for a few years, the storage needs grow dramatically! Storing VMs is the primary purpose for my Openfiler server (first mentioned). However, now when I need to fire up a machine it is a lot more tedious moving the VM image to the ESXi server or my local VMware Workstation machine (powering them up over the LAN is even more tedious imho).

While watching one copy last week I wondered aloud, “Wouldn’t it be handy if I could just treat that virtual hard drive (.vmdk) like any other drive?” VMware was already way ahead of me. Enter the VMware Workstation Disk Mount Utility. Note: There’s not much to see at that link. Just accept the agreement and you’ll get the download.

This is a command line utility so a glance at the docs wouldn’t be a bad idea.

Run vmware-mount with no arguments to see what is currently mounted. To mount a .vmdk file to a drive letter run
vmware-mount [driveletter:] [path to .vmdk] [arguments]

This works fine even while the .vmdk file is on another server. Assuming you have proper access you can specify the “path to .vmdk” portion in UNC form (\\servername\share\path\to\file.vmdk). As you might guess, this saves me a lot of time shuffling around big files over the network.

When done just run vmware-mount [driveletter:] /d to dismount it.

One small note: While this has worked for me every time I’ve used it, it may have quirks.

Related posts:

1. VMware Converter
2. Upgraded to VMware ESXi
3. VMware ESXi Goes Free — Hmmm…

The Web Platform Installer is smart enough to grab pre-requisite software so not only did it installed IIS, SQL Server Express and all the .NET stuff I asked for, but since I asked for WP it also installed PHP 5 and MySQL. Not only that, but it then prompted me for the usual stuff you deal with when installing WP and gave me a link to my completed site.

Bam. Just like that, I had a working WordPress site hosted on my Windows box. Not only that, but Permalinks and auto upgrade worked too! Pretty slick, really. A nice, native, alternative to a WampServer or XAMPP.

I fired up an XP machine, downloaded the Web Platform Installer, only checked “WordPress” and then started the installer. With XP, if IIS isn’t already on there you will get prompted for the install CD for that part – but everything else was downloaded and installed on the fly.

WordPress works fine under XP but there are no pretty Permalinks (just “almost pretty”) on this older version of IIS (version 5.1). Also, the auto upgrader prompts for FTP credentials instead of just upgrading. Probably a permissions issue but I didn’t chase it down as I don’t spend much time on XP anymore.
[note: if you need to sort this out try the Process Monitor tool as mentioned below]

Next I tried Vista. Same routine, only selected “WordPress” and ran Web Platform Installer. Wasn’t prompted to install any other media, unlike XP, and after a brief wait and some WP setup prompts it was done.

With Vista I got a more modern version of IIS and Pretty Permalinks worked right away – but with a wrinkle. I had to create and populate the web.config file manually as WP couldn’t do it automatically. Oh, and the auto upgrader took me the FTP route. Once again, I figured I had a permissions issue but this time I decided to chase it down.

Grabbed my old friend, Process Monitor, and did some monitoring to see what was up. It didn’t take long:

I explored that Access Denied line to see what the user was and found that it was IUSR. I went to IIS Manager, expanded down to my WordPress site and then right-clicked and chose “Edit Permissions…”. In the result dialog I chose the “Security” tab, clicked “Edit…” and then added the IUSR user with “Modify” level permissions.

Now upgrades happen automatically and Permalink changes require no manual intervention. Now, I can’t speak to the security of this approach – but then I’d never expose a Vista server live on the internet either!

Going full circle I next tried just the WordPress install on another Windows 7 machine. To make a long story short, it was just like the Vista story above. So, something I installed my first time around (with all the other .NET stuff) changes permissions around a bit. Or, perhaps it was the fact that on that first install I created the WP installation as a new IIS site, not as part of the Default. Something else to test on another day…

Related posts:

1. Web Platform Installer Updated
2. Testing New WordPress Versions Part 1: XAMPP
3. Microsoft Web Platform Installer

The Rocky Mountain Tech Tri-Fecta is a free, information-packed day of practical training and information concentrated in .NET, SQL Server, SharePoint and Microsoft Windows technologies. There will be  loads of sessions on a wide range of interesting topics by top rock stars in the .NET, SQL Server, SharePoint and Windows Server arenas. In addition, we’ll be hosting several “Birds of a Feather sessions” where attendees can interact with top professionals in specialized areas. Each of these sessions will focus on the tech and will be filled with code and actual hands-on demonstrations to maximize the value to you, our peers in the technology community. All IT professionals who want to learn are invited. Please check out the Schedule page for additional information.

Anyone else going? I went last year and had a good time while learning a lot. I am hoping for the same this year.

Updated:
Alas, I had a scheduling conflict and ended up not being able to go today.

Related posts:

1. The Rocky Mountain Tech Trifecta
2. Upcoming Events For February 2009
3. 2/17/2009: Today’s Appearances

He was talking web site vulnerabilities when one of the attendees challenged him with “Well, if these issues are so prevalent, let’s see if they exist on one of our sites.”  Not only did the issue exist on their site, but someone had already taken advantage of it!

Read the article for the entire story. Pretty interesting stuff!

Related posts:

1. Are you still using Internet Explorer? New Exploit
2. Free eBook Offer: Vulnerability Management for Dummies
3. Word Vulnerability — Be Careful With Attachments

If you’re a Pidgin user, as I am, check out this how-to article on Casey Ho’s blog. The Facebook help center also has a page up on how to configure for iChat, Adium and (again) Pidgin. Pretty straight-forward to do – it took just a few seconds for me to configure Pidgin to add facebook chat.

Now, I have pidgin running almost all day long for work IM. Will I always have Facebook IM enabled as well? Oh heck no. That would be madness! But I might experiment with keeping it going in the evenings and see how it works out.  Just from watching this evening it is interesting to watch people come and go.

Facebook isn’t often praised for being “open” but I think this is a step in the right direction.

Related posts:

1. Manage Facebook Chat
2. My dream chat plug-in
3. Pidgin 2.0 Rocks