SQLSaturday #136: Done & Dusted!

Phew! It’s Sunday afternoon and I’m starting to feel relatively normal again after a few hectic days doing the final prep work for yesterday’s SQLSaturday #136 here in Wellington, New Zealand. In the Beginning Preparation for the event started 3 months ago with Rob Farley asking whether I’d be interested …

CURSORs and WHILE-Loops

Yes, I know this is a giant (some might say pointless, and I wouldn’t totally disagree) can of worms I’m opening here, but stay with me for a minute. Why? We were discussing this at work a few months ago, and I was one of those people who followed “conventional …

What a turn-out!

I’ve been a little busy over the past few weeks; what with us taking a planned outage at work to perform a fairly major upgrade of both server hardware and clustering software, the Wellington SQL Server User Group keeping me on my toes as usual, and finally the up-coming Wellington …

SQL Saturday is coming to Wellington

The title pretty much says it all; we’ve got a SQL Saturday event confirmed for Wellington, on the 14th of April 2012! Rob Farley and a few other folks from PASS are organising 6 SQL Saturday events in a row across Australia and New Zealand (well, 1 in New Zealand), …

Wellington SQL Server User Group

A few weeks ago I was asked to take over the running of the Wellington SQL Server User Group by the original founder of the group.  I had been wanting to get more involved in the local SQL community, and last year kicked that off by speaking at 3 different …

Preventing identity overflow

Here’s a stored procedure I put together a week or so ago that I thought others might find useful. We had an issue which should really never be allowed to happen (but as they say, “shit happens”); a rather important table ran out of integer values for the identity column.  …

PASS Summit trip wrap-up

I left for the US just over 2 weeks’ ago to attend the PASS Summit in Seattle, followed by a week in San Francisco doing the tourist thing. Basically, the Summit was awesome. The pre-con sessions were amazing (and intense!) – I think my brain was physically stretched during Itzik …

How’s the weather in Seattle?

PASS Summit I’m fortunate enough to be heading to Seattle this weekend for the PASS Summit courtesy of my employer (thanks again!). It’s my first visit the the US as well, so I’m extra-excited! The weather here (in Wellington, New Zealand) is pretty average at the moment – I still …