.NET Admin GUI for MongoDB

Having just started out fiddling around with MongoDB from .NET, finding a GUI over the top of MongoDB to help me out while I find my feet was one of the first things I looked for. And I’ve been using the first tool I found : MongoVUE - there undoubtedly are others out there, but at the moment I’ve found no reason to continue searching. Can it do everything I want it to? [Read More]

Getting Started with MongoDB and .NET

Getting up and running with MongoDB using C# is a very simple process. It literally takes a couple of minutes, including the time to download MongoDB itself and the C# drivers - so if you fancy having a play around with it to see what it’s all about, there’s no barrier stopping you. Nutshell To quote MongoDB.org: MongoDB (from “humongous”) is a scalable, high-performance, open source, document-oriented database. Check out the MongoDB homepage for a highlight of the key features. [Read More]

Round up of 2010

2010 was my first year as a blogger, after finally pulling my finger out back in February. I learnt an early lesson in naming/tagging posts appropriately after my first search engine hits came in via the term “pull my finger”. Not exactly the kind of search term I was hoping to bring up my site - things have improved now so I’ve headed in the right direction with a focus on SQL Server and . [Read More]

SqlBits 8 - Upcoming SQL Server event

So SQLBits 8 has been announced and is going to be beside the seaside (so maybe it should be called SeaQLBits) in that there Brighton at The Grand, from Thursday 7th April to Saturday 9th April 2011. If you’re reading my blog, then there’s a pretty strong chance you use SQL Server in which case without a doubt, SQLBits will have a lot to offer you. Chalk it down in your calendar. [Read More]

SQLSoton UserGroup Jan 2011

After the success of the first ever SQL Server Southampton UserGroup this month, the next is planned for Wednesday 19th January 2011 with Christian Bolton (Blog| Twitter) doing a talk on “Exploring SQL Server’s Architecture”. Followed by SQL Supper - a chance to eat pizza and discuss anything SQL Server related. Got a niggle at work you’d like 2nd/3rd/nth opinions on? Perfect opportunity. Just want to network and have a casual chat? [Read More]

SQL Server Southampton UserGroup

Last night was the first SQL Server Southampton UserGroup (#sqlsoton for those on twitter) organised by Mark Pryce-Maher (Twitter | Blog). It’s a difficult job trying to get a local usergroup up and running especially when it’s difficult to reach out to local professionals and get a firm idea of who’s going to come, and so credit to Mark for making it happen. Cap’n, we have no power Despite projector/power lead problems (and there being a million and one kettles in the hired room, none with suitable lead! [Read More]

SQLBits 6 videos available

First tweet I say today was a great one - the SQLBits 6 videos are now available. Good news from Simon Sabin (Blog | Twitter) - thanks once again, and to the whole SQLBits team. If you were there, then no doubt you’re like me and keen to either catch the sessions you didn’t attend or re-watch some sessions you did attend. If you weren’t there, then even more reason to check them out (list of sessions). [Read More]

SSMS Tools Pack

Today I downloaded and installed the SSMS Tools Pack, a free add-in for SQL Server Management Studio developed by Mladen Prajdić (Blog | Twitter). Late to the party…and not even fashionably late Yes I know, I know - everyone uses the SSMS Tools Pack and I’m well aware I’m late to the party! Fail whale on my part. It’s one of those things I bookmarked a long time ago and just never got round to actually trying out. [Read More]

Long time no post

It’s been a while since my last blog post, with good reason as September saw the arrival of my first child - a beautiful baby girl. It did mean I had to miss SQLBits 7 up in York, but of course that pales into insignificance when comparing to becoming a Dad for the first time! Besides, there’s always SQLBits 8…(cough bring it to the south coast! cough). Now I’m back at work after paternity leave and I’m starting to get back in the swing of things. [Read More]

Passing a TABLE variable into dynamic SQL

A question popped up on StackOverflow today, asking how to pass a TABLE variable into a dynamic SQL statement in SQL Server 2008. I’ve previously blogged about table-valued parameters, comparing the approach of passing in a TABLE of values to a stored procedure to the techniques you’d have had to use in earlier versions of SQL Server (e.g. CSV or XML), but this specific question is worth a quick follow-up. [Read More]