Blogs

I Love Idea Paint

We just received our Idea Paint that we are going to put on one of the walls in our new workout...

SQL Server 2005 to 2012 Differences for Developers

We are upgrading from SQL Server 2005 to 2012. There are a lot of features for developers that have...

Auto Feeding the Cat with Video Confirmation

From a scheduled program I wrote on my laptop, I wanted to turn on an electric wall outlet, which...

Programming Your Home

I wanted to do some home automation, and I wanted to write the code myself (I’m a software...

Recording Deletes When Using Entity Framework

I have all the changes archived to archive table using triggers, but this doesn’t record anything...

Generating Archive Tables and Triggers

I create archive tables to log all of the changes made to a table. The archive tables look like the...

Generating Indexes for Foreign Keys

Surprisingly, SQL Server doesn’t automatically create indexes just because you have a foreign key...

Show Child Count in a DataGrid

I have an application with the following as part of the data model: So an Account can have many...

Generic Boolean to Text Converter

I’ve seen this done a few different ways, but I think this is the best way because you can reuse it...