Visual Studio 2010 Solution Won’t Open From Explorer

This one has caused me some problems recently.  I have a Visual Studio solution I downloaded, yet double clicking on the solution file in Windows Explorer does not open the solution. I know it’s a Visual Studio 2010 solution, because the file starts with: Microsoft Visual Studio Solution File, Format Version 11.00 # Visual Studio… Continue reading Visual Studio 2010 Solution Won’t Open From Explorer

FB Hacker Cup 2011 Round 2 – I’m Out

A couple of weeks ago, I blogged about my participation in the inaugural Facebook Hacker Cup.  Well, I didn’t get any further, and exited spectacularly in round 2. To say it was tricky is an understatement.  The level of difficulty was a huge leap up from the previous round.  Of the 1,673 programmers eligible to… Continue reading FB Hacker Cup 2011 Round 2 – I’m Out

Facebook Hacker Cup 2011

Over the last couple of weeks, I’ve been taking part in the inaugural Facebook Hacker Cup, a programming competition ran along almost identical lines to Google’s well established CodeJam. The format of the competition is quite simple.  To start with, there was a qualification round lasting 72 hours in which 3 problems were posted.  Competitors… Continue reading Facebook Hacker Cup 2011

An Alternative to Redirecting HTTP to HTTPS in IIS 7

Recently, I needed to ensure that a whole ASP.NET web application was forced to deliver content over a secure connection. Almost every page in the application contained sensitive data, and is was deemed acceptable for the small number of pages which didn’t contain secure content to be delivered over HTTPS too.  I started looking around… Continue reading An Alternative to Redirecting HTTP to HTTPS in IIS 7

Installing Ruby for MongoDB Use on Windows

I’ve recently downloaded the first three chapters of Kyle Banker’s “MongoDB In Action” from Manning’s early access program.  So far, it’s shaping up to be a great read.  In it, Banker uses Ruby in his examples, and the MongoDB project provide an official Ruby driver to access MongoDB.  Now, I’m pretty much a C# person… Continue reading Installing Ruby for MongoDB Use on Windows

Why I Never Use SELECT * FROM

I’ve heard for many years that using SELECT * FROM <some table> is a bad idea.  I’ve always agreed with this in principle, but in practice often haven’t followed this guideline.  That’s all about to change, as I was caught out by what (in my opinion) is a bug in Microsoft SQL Server that totally… Continue reading Why I Never Use SELECT * FROM

Published
Categorized as SQL

Excel with Stored Procedures

Introduction A couple of week ago, I read this post by David Poole about reading data from SQL Server into Excel, where the data source was a parameterised stored procedure.  David concludes that a small amount of (albeit trivial) VBA code is required in order to make this work.  However, deep down in my psyche,… Continue reading Excel with Stored Procedures

Published
Categorized as SQL

So… I have a Blog

Rather than do anything outlandish for my first post, I thought I’d do what the majority of bloggers seem to do for their first post, and that’s write a post about why I’m blogging.  What, you don’t believe me? Here are a couple of examples: ScottGu’s Blog Hanselman.com I sample a random selection of around… Continue reading So… I have a Blog

Published
Categorized as Blogging