The latest addition
Picking up a 1980 Kawasaki KH-125 as a weekend restoration project, with plans to document the strip-down and rebuild.
Read more →Posts
SQLSaturday #136: Done & Dusted!
A recap of organising SQLSaturday #136 in Wellington, New Zealand, covering venue selection, speakers, and lessons learned from the event.
Read more →
CURSORs and WHILE-Loops
Benchmarking SQL Server cursors against WHILE loops with surprising results -- cursors consistently outperformed loops in duration and I/O.
Read more →
What a turn-out!
An update on the strong speaker response for the upcoming SQLSaturday #136 in Wellington, with more sessions than available timeslots.
Read more →
SQL Saturday is coming to Wellington
Announcing SQL Saturday #136 in Wellington, New Zealand, on 14 April 2012, as part of the ANZ SQL Saturday Tour. Speakers and attendees welcome.
Read more →
Wellington SQL Server User Group
Taking over leadership of the Wellington SQL Server User Group, a PASS chapter running monthly sessions on SQL Server topics.
Read more →
Preventing identity overflow
A SQL Server stored procedure that checks identity columns across all databases and sends an alert when values approach the data type maximum.
Read more →
PASS Summit trip wrap-up
A recap of attending the PASS Summit in Seattle, followed by a week-long Harley road trip through Northern California.
Read more →
How’s the weather in Seattle?
Heading to the PASS Summit in Seattle for the first time, with plans for a Harley Davidson road trip through California afterwards.
Read more →
SQL Server word-level bigram function
A T-SQL function for generating word-level bigrams from search strings, useful for building did-you-mean and search auto-suggest systems.
Read more →