Recently at work, I’ve had the pleasure of working on a new project written in ASP.NET MVC2 under .NET 4.0.  Our team has decided to use Entity Framework 4 for data access, and for the most part, we’ve been very pleased with this decision.  One of the things I tend to make use of pretty regularly is default values for columns in SQL server.  In doing this, I’ve encountered a pretty nasty bug in EF4.  Here’s the deal: I have several tables in my application where I add some basic auditing columns, such as CreateDate, CreatedBy, LastUpdatedDate, and LastUpdatedBy. ...

So I know it’s been a while since my last post, but I just couldn’t resist this one.  Here at work, we’re upgrading to Visual Studio 2010 since it’s finally been released, and overall I’m very pleased with the latest and greatest from Microsoft.  During the testing phases I installed the Beta 2 and RC versions of VS2010, and aside from horrible performance in the beta (which was later fixed), I’ve always been relatively happy. Today, however, I came across perhaps one of the most ridiculous design flaws I’ve ever seen.  Anyone that uses Visual Studio will tell you that...

I’ve been stuck for a while now.  There are so many amazing technologies and frameworks out there, and I’ve finally decided to devote some serious time to one of the best (in my opinion) which is Rails.  I know I’ve talked about this in the past, and, frankly, I’ve been either too busy or too lazy to seriously devote time to it.  But this year I’ve decided to make a resolution to seriously learn Rails by rebuilding this blog with it.  I know there are a million blog platforms out there, especially when you consider the fact that every geek seems to write their own. ...

A while back I wrote about my experiences installing SQL (and additionally .NET 3.5 SP1) on a Windows Server 2008 VPS.  For various reasons I decided not to keep the VPS server at the time (mostly because of the cost, and the fact that I didn’t really have a strong need for it).  Recently, however, I’ve really begun to ramp up my ASP.NET MVC development work, and it’s blatantly apparent that I need a Windows server full time.  After shopping around for a while, I decided to go back to KickAssVPS.com and see what their packages looked like.  Having ordered my shiny new...

Over the past couple days I’ve been reading what’s shaping up to be an excellent book about Ruby on Rails called “Agile Web Development with Rails (Third Edition).”  This book takes a practical approach to teaching Rails by building a demonstration shopping cart application called “Depot.”  I must say that, so far, learning Rails has been a complete pleasure.  I really enjoy the MVC methodology and the idea of “convention over configuration.”  The basic idea behind Rails is that we (as web developers) generally know what we’re doing, and we can follow some...

As I was surfing through StackOverflow today, I noticed a question that got me thinking.  This developer had been working with a classic ASP application that used MySQL for it’s backend database.  The project on his plate was to convert this application to ASP.NET with MS-SQL as the database.  The only problem he encountered was the fact that passwords were stored in the database using a MySQL-specific hashing algorithm called via the PASSWORD() function.  He needed a way to convert these passwords to .NET. Given that I have a MySQL database laying around, I decided to poke...

Recently I’ve been debating moving my site over to a Windows VPS.  If I make this move, I’m hoping to take advantage of the new features available in Windows Server 2008 as well as .NET 3.5 SP1 and IIS 7.  After some preliminary research, I decided to give KickAssVPS.com a try.  Within a few hours of my order, they had my VPS up and running, and so far I’ve been fairly pleased with the performance. When I logged into my VPS, one of the things I wanted to install right away was SQL Server 2008.  In order for SQL Server 2008 to install, you must first have installed the...