I started having fun with stored procedures today. In fact, before today, I had no idea what a stored procedure was, especially given my relatively limited exposure to the likes of MySQL and Access and the fairly facile uses of databases in the past. Don’t get me wrong, I’ve done some technical stuff with databases, but once you’ve written one CMS, you’ve written them all.
Nope, today, the joys of MSSQL, stored procedures, and the delicacies of getting fulltext searching installed were explored, and by the end of the day I had rewritten several of the major queries used to search one of our databases. Was most fulfilling. What a pleasure UNION is.
(God, I’m a geek. I always knew I was, but I think I’m reaching new levels of geekdom.)