Manually creating default constraints in SQL Server

Default constraints can be added in Management Studio by setting a default value for a field in the designer, or by specifying it in your table create script. This SUCKS though, because it generates a random name for the constraint, which can lead to inconsistencies across databases - if you... [Read More]
Tags: sqlserver

MVC3 Deployment Nightmare

I had a freaking nightmare deploying an MVC3 app today. Seems simple. Database was up and running. The code was deployed and had been tested on our local systems. I deployed via our amazing SVN deployment process, and published on the live server. Permissions applied automatically, all the files appeared... [Read More]