Customising SQL Management Studio 2012
Tips for customizing SQL Server Management Studio 2012, including dark themes, keyboard shortcuts, and syncing templates via symbolic links.
Read more →Recent Posts
What's in your toolbox?
How to organise your SQL Server utility scripts using SSMS Template Explorer, snippets, and other tools for easy retrieval.
Read more →
SQL script of HTML status codes
A downloadable SQL script that creates a lookup table of all HTTP status codes and their descriptions, sourced from Wikipedia.
Read more →
Combining different database technologies
Exploring when to combine SQL Server with NoSQL technologies like Redis and MongoDB for workloads such as search and recommendations.
Read more →
Putting Humpty together again
Progress report on rebuilding a 1980 Kawasaki KH-125 motorcycle, from painting the frame to reassembling the chassis in a freezing garage.
Read more →
Elbow grease
A personal update on restoring a 1980 Kawasaki KH 125 motorcycle -- stripping the frame, rebuilding the carb, and polishing chrome.
Read more →
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 →
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 →