Bernie Cook's Blog

Azure, C#, .NET, Architecture & Related Tech News


“The Frustrated Architect” – Simon Brown

The Frustrated ArchitectI attended DevWeek 2012 earlier this year and was fortunate enough to be present for a number of very informative presentations. One particular talk which stood out was by Simon Brown titled “The Frustrated Architect” – which is currently available to view online. Continue reading


Leave a comment

Async in Windows Azure

At the time of writing (November 2012) Windows Azure C# development is only available with the .NET 3.5 and 4.0 Frameworks. So what happens when you want to implement some asynchronous server-based programming using the .NET 5.0 Async language features?

Microsoft’s answer is to install the Async Targeting Pack for Visual Studio 2012. The only prerequisite is that you’re developing with Visual Studio 2012. Continue reading

Leave a comment

Several Windows 8 Tips and Gotchas

Windows 8 was official released last week and personally I wasn’t all that excited after having spent some time with the Release Preview many months back. Anyway I thought I’d make the leap out of pure curiosity and after several days of exposure to Microsoft’s latest OS I can confidently say I’ll never look back.

The main areas that really shine are the performance and usability improvements. Everything runs significantly faster; compilation, application load times, start up, shutdown, etc. And once I’d familiarised myself with the Metro UI I found it a far simpler way to access all those applications that I couldn’t cram into an already overloaded taskbar.

I’ve collated a few tips and gotchas that I encountered in the last few days hoping they may be of benefit to anyone who hasn’t upgraded yet or is having troubles finalising their installation. Continue reading

1 Comment

Reviewing the T-SQL Generated by LINQ to SQL Within SQL Server Profiler

SQL Server ProfilerIf you’re interested in taking a look at the final T-SQL generated by your LINQ to SQL queries then you have a few options available:

  1. Utilise LINQPad which converts your C# LINQ database queries into T-SQL
  2. Execute an SQL Server Profiler trace against the database your application is querying while its running
  3. Understand how ADO.NET translates the LINQ to SQL expression tree into T-SQL so you know what it’s going to output

I thought I’d blog about the second option above given it’s the more common approach I adopt when I’m working with LINQ to SQL. Continue reading