Entity Framework Fluent API and Indexing

With the release of Entity Framework 6.1 the Fluent API can now be used to create indexes. It's still pretty basic and will hopefully evolve to become more complete in future releases. For all the examples below I'm using the following model public class People { public int Id { get…

Rails Continuous Testing

Coming from the .Net world where continuous testing is expensive on both the wallet and processing power seeing what Ruby has to offer in this area is pretty incredible. You can pretty much bring in a few gems and have continuous testing with awesome notifications out of the box. For…

Browser Based Web Notifications

3 of the 4 major browsers now support web notifications (Safari, Firefox, Chrome) and no where near enough sites are making use of this killer feature. One web app that does make good use of this is Gmail, if you've enabled it then it will show notifications when you get…

Cloning a SQL Server Database

The following script will backup and restore a database to the same server with a different name. Tested on SQL 2012/2008. You just need to set the 4 variables at the top of the script to specify source and destination along with directories to store the backup and restored…

Using Google Charts With AngularJs

I recently rewrote a small webpage in AngularJs and it was amazing how much lighter and cleaner it made the code. The conversion was mainly a case of me throwing away most of the code and adding a couple of lines of AngularJs. This was all very simple until I…

Debugging Issues With Log4Net Not Logging

When you find log4net is not writing anything to your logs it can be a pain to debug as obviously Log4Net will (and should) never throw an exception. The first thing you want to do when you find you have this problem is to enable tracing in Log4Net. This is…

ASP.Net MVC Debugging “Internal Server Error 500”

I was recently seeing “Internal Server Error 500” when trying to make an ajax call from an ASP.Net MVC view back to the controller. No breakpoints or errors were being thrown in the application. I ended up getting the error information by adding the following event to my Global…

Das Keyboard - First Thoughts

There seems to be a lot of buzz around mechanical keyboard lately as more and more manufacturers have started producing them. It’s only a matter of time before these become more mainstream. I’ve spent the last 6ish years using the Microsoft Ergonomic 4000 which is an amazing keyboard…

Connecting to SSIS 2008 Without Local Admin

The default install of SSIS only allows users with local admin rights on the server to connect. This can be changed by modifying some permissions in DCOM. The following is a guide for SSIS 2008 but I would imagine it’s very similar for more recent versions. On the client…

SQL Server Development Permissions

After setting up a new SQL Server instance for development I found the following permissions were needed extra permissions were needed to enable key development features… (Note these were for a development instance and should not be needed on a production database) Permission To View Query Plans This needs to…