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
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
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