Welcome to DigitallyCreated! This website is where I host my blog, publish some of the software applications that I have written and display my résumé. I wrote this website entirely from the ground up rather than using an off the shelf CMS/blog software product mainly as a demonstration of my technical skills and as a learning exercise.
Blog
More Lessons from the LINQ Database Query Performance Land
July 19, 2011 2:00 PM
Writing LINQ against databases using providers like LINQ to SQL and Entity Framework is harder than it first appears. There are many different ways to write the same query in LINQ and many of them cause LINQ providers to generate really horrible SQL. LINQ to SQL is quite the offender in this area but, as we’ll see, Entity Framework can (read more)
Incremental Builds in MSBuild and How to Avoid Breaking Them
June 26, 2011 2:50 PM
One of my recent tasks at a client has been to help improve the speed of their build process. They have around 140 projects in their main Visual Studio solution, and one of the problems they had was that if they changed some code in a unit\integration test project at the bottom of the compile chain, Visual Studio would rebuild (read more)
Sweeping Yucky LINQ Queries Under the Rug with Expression Tree Rewriting
May 02, 2011 2:06 PM
In my last post, I explained some workarounds that you could hack into your LINQ queries to get them to perform well when using LINQ to SQL and SQL CE 3.5. Although those workarounds do help fix performance issues, they can make your LINQ query code very verbose and noisy. In places where you’d simply call a constructor and pass (read more)
Working Around Performance Issues in LINQ to SQL and SQL CE 3.5
April 25, 2011 5:17 PM
Recently I’ve been optimising LINQ to SQL queries running against an SQL CE 3.5 database in order to stop them taking over 5 minutes to execute and bringing them down to only a few seconds. In this post I’m going to go into two of the biggest offenders I’ve seen so far in terms of killing query performance. Credit must (read more)
Windows Phone 7 Performance Tips and Resources
April 10, 2011 9:57 AM
Following in the same vein as my previous post, this post will detail a number of tips and resources I’ve found for developing on Windows Phone 7, specifically covering optimising application performance. Unfortunately, the phone is not your eight core beast with 16GB of RAM and a graphics card that chews 300W of power when under load, so you need (read more)
Twitter Updates
A Nation of Traders, where a job is an exchange of value between employee and employer, not a mandated "right": http://t.co/fk3jyO7X
RT @hingwahkwok: Douchebag Merit Badges! http://t.co/c3i3Uqz1
@dwainbunker Same here. Some corporate-controlled aircon for the whole building. I don't care, I'm freezing to death, they need to fix it.
5 days ago in reply to dwainbunker
@brentos Noooooo, why??? Are they replacing it with another .NET subject?
5 days ago in reply to brentos
@dwainbunker I don't understand how it's so hard to get right. It's bloody uncomfortable, plus it wastes energy that you pay for like crazy.
5 days ago in reply to dwainbunker
If I need a jacket when its 30 degrees outside, you're doing air conditioning wrong. #JustSayin
A guy from my credit card company just read me back my account password over the phone. NOOO YOU GUYS ARE SUPPOSED TO BE SECURE! #EpicFail