Category Archives: Uncategorized

SQL Server: Finding a column in multiple databases.

My client has many instances of the same database in various versions. The version I’m developing against is missing a field expected by a c# class, and I can’t find a script to create the column. I came up with the following … Continue reading

Posted in Development, Uncategorized | Tagged | Leave a comment

Launching .EXE applications from a browser

My client has an Angular intranet portal for their main c# WinForm application. They have a requirement to launch the main application from the portal website. There is a fairly easy way to go about this in Windows although it … Continue reading

Posted in Development, Uncategorized, Web Development | Tagged , | Leave a comment

Automatically building NuGet packages for your project

I’ve been using the Nuget Package Explorer for ages, but recently found out how to automatically build  the NuGet for a project as part of your normal build. Enable NuGet Package Restore  for the solution. This will create the .nugget folder … Continue reading

Posted in Development, Uncategorized | Tagged , | 1 Comment

Login redirection using AngularJS & UI-Router

When a user follows a link on an email to the site, but needs to login before they can view the page, you need to remember the requested page and return to it after a successful login. In the following … Continue reading

Posted in Angular, Development, Uncategorized, Web Development | Tagged , , | Leave a comment

Facebook Spam

Facebook are filling my phone app with so many updated from pages I haven’t liked, that the app is becoming useless. They obviously know I’m a software developer, but this is terrible spamming. So much that I don’t see updates … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Entity Frameworks, WebApi, JSON.Net and Serializing Circular References – Better fix

As an improvement on yesterday problem and solution, there is a simple change to the JSON.Net settings which solves this issue, just add this into Global.asax: JsonSerializerSettings settings = new JsonSerializerSettings {     PreserveReferencesHandling = PreserveReferencesHandling.Objects,     Formatting = Formatting.Indented }; HttpConfiguration config = GlobalConfiguration.Configuration; config.Formatters.JsonFormatter.SerializerSettings = settings;

Posted in Uncategorized | Leave a comment

Entity Frameworks, WebApi, JSON.Net and Serializing Circular References

While Entity Frameworks handles circular references between models very well, putting them through a WebApi web service and serializing them, Json.Net starts throwing errors. The quickest way around this is to rebuild the objects and miss out the references from … Continue reading

Posted in Uncategorized | Leave a comment

Microsoft ALM

At work on Monday, we had a presentation from Microsoft of their Application Lifecycle Management tools, specifically TFS and its corresponding testing and release tools. I was very impressed overall by the latest product suite and the improvements to our … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Get last day of the month in SQL Server

A quick way to get the last day of the month: declare @date dateTime; set @date = convert(DateTime,’2013/12/01′); SELECT DATEADD(dd, -DAY(DATEADD(m,1,@date)), DATEADD(m,1,@date))

Posted in Uncategorized | Leave a comment