Fullsix Blog

While migrating a database from SQL Server 2005 to SQL Server 2000, a colleague was faced with this exception:

The ‘System.Web.Security.SqlMembershipProvider’ requires a database schema compatible with schema version ’1′. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_reqsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.

He didn’t use aspnet_regsql on the target db. Instead, he generated schema create scripts from SQL Server Management Studio. I usually use RedGate SQL Compare and SQL Data Compare, which I believe to be priceless for database synchronization.

There are many probable causes for this. After browsing for solutions, here’s a summary of steps we took to solve it:

1. If possible, use aspnet_regsql on the target db.
2. Make sure the user specified in the connection string has EXECUTE permissions on aspnet_* stored procedures. Grant them if necessary.
3. Restart the web application

Don’t forget step 3!

One thing that always bugged me about Tortoise SVN is the intensive disk I/O performed by TSVNCache. If you look at the CPU usage in Task Manager for the TSVNCache.exe process, it is usually always greater than 0. TSVNCache is a Tortoise SVN helper process that helps putting the icon overlays in Explorer (you know, those green checkmarks and the like…).

For the last couple of weeks, whenever I opened a folder under source control which had quite a lot of files, my Explorer would hang, making my system unusable. Aparently, TSVNCache was the responsible and, after fixing some of it’s settings, my system is now a LOT faster when working with folders under SVN. I stumbled across a solution, which I suggest even you are not experiencing these problems.

Here’s the step-by-step guide on how to fix this issue:
http://www.paraesthesia.com/archive/2007/09/26/optimize-tortoise-svn-cache-tsvncache.exe-disk-io.aspx

In my system, all of my development projects are under d:\development, so my settings in TortoiseSVN are:

Last week I was at two events about Scrum, organized by Microsoft and Fullsix Portugal.

The first was called Scrum for Managers and was presented by Mitch Lacey (from Ascentium). I never enjoyed project management (actually, I think it’s more ‘I always hated it!’), probably because in college I had a really bad experience and then never quite got into it. I’ve been in touch with some agile methodologies, but I never got in touch with Scrum. Mitch’s session blew me away! Was REALLY good, he’s a great presenter, and I finally enjoyed something about project management. The thing is that Scrum really is Fun! And makes perfect sense in today’s world of software development, where requirements keep on changing and customers expect this requirements with little time or cost impact.

The second one was called Scrum + Team Foundation Server and was presented by Jim Morris (also from Ascentium). It was my first hands-on contact with TFS and it looks nice. I’m used to SVN (for source control) + NAnt (build) + CruiseControl (integration), but the idea of having all of these functionalities integrated in one environment is really appealing. Also, the support for Agile project management and Scrum in TFS makes it possible to have the management part of the project integrated with the development experience. The one thing that didn’t really convinced me was the source control interface provided by TFS. At the moment I’m very SVN biased. A big thanks to Jim for keeping this event very interesting (and for a nice car ride by the sea ) .

Can’t wait to be on a Scrum project!