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 …

SQL Server word-level bigram function

I work for an online auction website, Trade Me, and as such collect quite a large quantity of search data (i.e. full text searches that people perform).  Over the years I’ve been involved in various aspects of our search; from tweaking the nuts and bolts of the full-text search itself …

Tech Ed done, bring on PASS Summit!

I’m feeling somewhat human again after having caught up on some sleep back at home after 4 days in Auckland at Tech Ed New Zealand. Thanks again to those who came to our session (DBI207 – Trade Me: 0-70 million pages in 0.34 Gigaseconds) – and specially to those who …

Getting ready for Tech Ed New Zealand

Tech·Ed NZ kicks off the day after tomorrow at the Auckland SkyCity convention centre.  I’ve been to a few in the past, so nothing new there – but what makes this year different is that myself and a colleague will be presenting a session: DBI207 – Trade Me: 0-70 million …

Snow snow snow!

I’ve been wanting to try posting from the WordPress iPhone app, and here’s my chance! Snow! (well, some snow, and lots of slushy stuff) Snow in itself isn’t that exciting, but snow in Wellington IS unusual. My wife is a local and can’t remember there ever been full-on snow like …

T-SQL Tuesday #21 – Temporarily permanent hacks

This month’s T-SQL Tuesday Wednesday is hosted by Adam Machanic (blog|twitter) – who in fact started the T-SQL Tuesday concept himself back in 2009 (read more about the genesis here). This month’s it’s about “crap code”. We’ve all seen it, and we’ve all written our fair share of it.  I’m not going …

Multiple CTE gotcha

This is probably one of those things you’ll read and think “What a dumbass, I’d never make that mistake!” – which is fine, but I thought I’d post about it nevertheless since it managed to trip me up twice in the space of a week. I’ve got a script which …