Column Order in Relational Database Tables

Mar 25, 2015 No Comments by

I have seen questions, and even debate, around column order in relational database tables and whether it is important or not.  The problem with these arguments is not whether or not column order is important or not, rather where any requirement for column order is implemented and enforced.  After reading a Stack Overflow answer regarding […]

Application Design, Relational Databases Read more

Xamarin Studio and Default Startup Projects

Dec 22, 2014 No Comments by

I working on a new mobile project in Xamarin this past weekend and started running into a strange issue that had me going in circles.  I was trying to debug my project in Xamarin Studio, but the iOS simulator was not starting up.  So, I tried deploying to my iPhone, but the device pulldown to […]

Uncategorized Read more

Looping Through Fields in a Record Returned from a LINQ Query

Jul 31, 2014 No Comments by

One situation that does not have an intuitive solution to is looping through fields in a result set returned by a LINQ query.  While the strong typing of the fields returned in these records is nice and convenient, there are times where I don’t want everything returned from the table.  This isn’t much of an […]

.NET Development, C#, Data Access Read more

Entity Framework and DateTime

Jul 03, 2014 No Comments

Over the past couple of weeks, I have been dealing with an error being thrown in a service I am building using Entity Framework 6 and SQL Server 2008: System.Data.SqlClient.SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.   Keep in mind that the error above […]

Read more

ngCordova and the Ionic Framework

Jun 06, 2014 No Comments

Over the past year or so, I have gotten hooked on AngularJS. I have also been spending the majority of my side project time working on mobile development using the Ionic Framework. One of the projects I am working centers primarily around the device’s camera, so I have started working on accessing it through the […]

Read more

Beta Is Just That

May 27, 2014 1 Comment

I was perusing the Ionic Framework forums last night and came across a reply to a post regarding the latest beta release (they are working hard toward their v1 release), and one developer made a comment saying that the last 4 (beta) releases have broken functionality in his production application code, and that this pattern […]

Read more

Winter Survival

Apr 11, 2014 2 Comments

As we are at the tail end of one of the most brutal winters in recent Minnesota history, it’s not just the physical dust that needs to be cleared off of most surfaces, it is also the mental dust. It is a natural inclination for many, if not most, to just retreat into our caves […]

Read more

iOS 7.1, Xcode 5.1 and Cordova

Mar 12, 2014 No Comments

tldr: If you have an iPhone that you also use for development and you want to update to the latest minor version (e.g. iOS 7.0 – 7.1), you will need to also perform updates across much, if not most the development tool chain to get things to work properly. My updates included iOS 7.1, Xcode […]

Read more

Web Hosting Rip-Off Artists Dressed in an MSA

Feb 27, 2014 No Comments

Ok, I just have to rant for a minute or two. Let me preface this first with the standard disclaimer–these opinions are mine, and mine alone, and not necessarily those of my employer. I currently work for a subsidiary owned by a large health plan.  We are employees of the health plan, but operate relatively […]

Read more

Snippet 001- T-SQL — Delete Large Number of Records

Jan 13, 2014 No Comments

This is the beginning of my attempt to capture snippets of code or quick tips I come across that helped me resolve issues or that I may use from time to time, but always end up going back and googling to find it later. Recently, I needed to clear a large number of duplicate records […]

Read more