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