SQL Server Management Objects - An Update

So, after previous post called "Adventures with SQL Server Management Objects", I decided to take a step back and see if I could improve my code. I wasn't happy with the while(true) loop, as if the developer…

Adventures with SQL Server Management Objects

Recently, I had an issue where I needed to be able to trigger a SQL Server Job from a Console Application. Now initially, I had the knee-jerk reaction of hitting the good ol' ADO.Net SQL Libraries, to invoke my…

Challenge Accepted

Thought I would share an interesting problem I recently had at work. Our client has a collection of InfoPath forms it uses to connect to web services for testing BizTalk interfaces from external systems. On the whole, these are pretty…

Dialects

Like most things in life, hardly anything actually ever goes to plan. I did intend on writing a more in-depth entry on the new async features in C# 5 during the weekend, but had an insane weekend filled with relatives…

Cheesy Puns and Awesome Code

Tonight I attended the Perth .Net User-group, where Joe Albahari was speaking on some of the upcoming features (puns are awesome) in C# 5, specifically the new async and await keywords. It was a very, very interesting night and (thankfully)…

Exceptions and Preserving Exception Types

An interesting thing happened to me today, while working on an enhancement for the application my company supports. I was tasked with ensuring validation worked on collection of objects, exactly the same as if it were a single object being…