Setting up a Message Queue in SQL Server

Over the years I’ve had a few instances where I’ve had to set up a message queue with the broker in SQL Server and every time I come back to set up another queue I find the documentation to be very confusing. So here is my attempt to make the setup easier to follow. Please take note this has been … Read More

Mike GriffithSetting up a Message Queue in SQL Server

App.config transforms with Slow Cheetah

Recently while working on a console app that I was building for work I found myself missing the web.config transforms that are used in web projects. For those who don’t know you can build transform file that will change your web.config files depending on what build type you are running at the time. This comes in extremely useful when you … Read More

Mike GriffithApp.config transforms with Slow Cheetah

Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

When running your application on another machine are you getting the following error ‘Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.’? Most of the time this is due to a dll or other piece of code not being included in the build file and it doesn’t exist on the new machine. … Read More

Mike GriffithUnable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

Using table valued parameters to efficiently pass lists into SQL Server stored procedures

While optimizing some code, I came across this very comprehensive article on the most efficient way to pass a list of items into a SQL Server stored procedure. To summarize the article the fastest way to pass in a list is to use table valued parameters, but the ORM tool that we are currently using Mindscape Lightspeed has no support … Read More

Mike GriffithUsing table valued parameters to efficiently pass lists into SQL Server stored procedures

Review of The Art of Unit Testing with Examples in .NET

While working on some unit tests at one of my former employers, I reached a point where it became obvious that I’d hit a wall and I didn’t know of a good way to structure and build the tests that I was working on. What I didn’t know at the time was that I was wasting a lot of time … Read More

Mike GriffithReview of The Art of Unit Testing with Examples in .NET

Saving xml from web service calls in .net.

While working on some some web service calls at work I ran into a situation where I needed to record the XML that was being passed from both sides. After doing some Google searching I came across the following code on Microsoft’s site.

Essentially this code hooks into the base web service code and saves the XML that flows … Read More

Mike GriffithSaving xml from web service calls in .net.

Installation failed due to the absence of a ServiceProcessInstaller.

Recently I encountered the following error message while creating a new windows service in .net : System.InvalidOperationException: Installation failed due to the absence of a ServiceProcessInstaller. The ServiceProcessInstaller must either be the containing installer, or it must be present in the Installers collection on the same installer as the ServiceInstaller. After doing some searching I found that this was due … Read More

Mike GriffithInstallation failed due to the absence of a ServiceProcessInstaller.

Installing Sencha Touch on Windows with IIS

Recently I was installing a copy of Sencha Touch 2.2.1 on my machine at home and I noticed a few issues with the install documentation when installing it on Windows and IIS. Note: This information applies to version of 2.2.1 of Sencha Touch and is really just a rewriting of the instructions to make things easier to install on Windows.

Mike GriffithInstalling Sencha Touch on Windows with IIS

Optimizing linq queries with .Any() instead of .Count()

If you have any linq code that looks like this:

Replace it with code that looks like this:

Basically you save time since linq doesn’t need to count each and every record in the collection.

Mike GriffithOptimizing linq queries with .Any() instead of .Count()