Tag: Programming

December 5, 2013 / All

As developers we’re inclined to want to understand what is happening under the hood or at least know that we can check if we wanted to. This is the case with Entity Framework, which performs some magic to provide access to a database and allowing us to perform actions against it. While 99% of the time we are more than happy to treat Entity Framework as a black box, sometimes we like to look under the covers and see what the Entity Framework is doing. In this article I will show you how to log the SQL queries that are being performed by the Entity Framework in an ASP.NET MVC application.

August 10, 2011 / All

I found myself recently needing to be able to present the user with the difference between two dates as a string, unfortunately the data had to come straight from SQL Server into the application that they was using ready to be displayed. After spending quite some time looking around the Internet to try and find a TSQL function that would work, I came up with my own and decided to share it with you.

August 4, 2011 / All

Microsoft Excel is probably one of the most used pieces of software on the planet. Spreadsheets are used heavily throughout the business world and Microsoft have enjoyed their Office suite taking a large proportion of businesses

June 19, 2011 / All
June 4, 2011 / All
June 3, 2011 / All
May 19, 2010 / All