Development Tools

I’m setting up a new development environment, and I thought I’d share the list of tools and technologies I’m putting into place there. Please add any you’d recommend in the comments. Everything here is free except the OS, SmartSVN, and RedGate SQL Source Control.

Operating System: Windows Server 2008 R2 x64 ($$)
Application Server: IIS 7 with .Net 4.0
Database Server: SQL Server 2008 Developer Edition R2 x64 ($35)
(yes, that’s right - Microsoft has a fully-featured version of SQL server for development that is dirt cheap)

Installation Tools used:

  • Web Platform Installer - tool to help install IIS, .Net, MVC, and other components
  • NuPack - helps to add extra assemblies / web.config merges, etc. for third party DLLs for your project

Read More

Migrating Umbraco from MySQL to MSSQL

So you’ve been running the Umbraco CMS for a while on MySQL, but you’ve been told you need to move it to Microsoft SQL Server. Does it sound intimidating? It doesn’t have to be. With the SQL script and instructions in this post, it’s not too bad. First, let’s start with an overview of the process.

Overview:
1. Use the Umbraco installer scripts to create blank Umbraco tables on your SQL server
2. Set up a linked database in SQL Server to your MySQL database
3. Migrate the data (using my script below)
4. Update your web.config to point to the new database

Read More

SVN Trouble

(If all you want to do is solve the same problem, you only need to add a Timeout 1800 line to your c:\program files\visualsvn server\conf\httpd-custom.conf file and restart Visual SVN server - you can, of course, adjust the number of seconds as you like)

First off, if you are doing any kind of software development and you aren’t using source control of some kind, you are missing out big time. I highly recommend source control. I use Visual SVN for the server and Smart SVN for the client, but there are lots of other great options out there. OK, on to the good stuff.

We have purchased licenses for RedGate’s SQL Source Control, which allows you to use SQL Manager to check in SQL objects into a SVN repository. Very cool. I had been using this for a short while, and I soon saw this error when trying to scan for changes:

Could not read chunk Size: secure connection truncated

Read More

Toodledo

Having recently changed over to using a Droid Incredible, I’m having to rework some of my productivity tools to work with the Incredible. Part of that was finding a new GTD / Todo list app.

I had used OmniFocus on my Mac / iPod Touch, but ever since the iOS 4 upgrade, the only way to get it to sync is to wipe out the OmniFocus database on the iPod Touch and start over (My guess is that they updated their software to work with multitasking, and as a result it breaks with devices, like the iPod Touch 2G, that don’t support multitasking on iOS4). Not a great solution. After waiting several months for a fix to this, I’ve given up and I looked around for something similar for my Droid. I strongly considered Remember The Milk, but the Mobile side of that app was rather weak.

I ended up settling on Toodledo. It needs some work on the ability to set custom filters, but overall it does the job I need it to do and it even has a widget for the Droid that shows my ‘hotlist,’, which is a huge help for me to quickly see the next 10 items on my list, color coded by priority.

Will I stick with it long term? I’m not sure. But so far I like it. I did spend a couple of hours transferring all of my todo items from OmniFocus to Toodledo the other night, so I’m committed to trying to make it work.

I use it to keep track of my grocery list, and I walk around with it at Kroger like a true geek, checking things off as I put them in my cart - my wife has had several good laughs at me as a result.

But I also use it to keep track of when to do maintenance on the cars and house, errands I need to run, etc. It’s great to have a GTD tool that works on the web and syncs to my Droid.

Sharepoint 2007: 'Only their own' permission on Document Library - Update!

OK, after getting tired of manually setting this using Sharepoint Manager 2007, I decided to put together a solution. This solution provides a nice drop-down on the Document Library ‘Security’ menu like this:

And when you click on the ‘Read/Write Security’ link, you’ll see this:

It looks and acts just like the page for standard lists - but this one also works for document libraries.

Download the solution from codeplex at http://moresharepoint.codeplex.com

Sharepoint 2007: Picture Library limitations

In working with the Picture Library in Sharepoint 2007, I’ve run across 2 limitations:

1. No web part connections. For some reason Microsoft decided that Picture Libraries would never need web part connections. It’s greyed out, as seen here:

2. Picture Libraries do not have the option to give users permissions to only view the pictures they created (and not view pictures that other users created). You can do this on non-document, non-picture library lists. Here is what it looks like on the ‘Advanced Settings’ page for a list:


But you don’t get that on a picture library.