SQL Breakfast

This morning we (i.e. my team and I) tried something we’ve spoken about for some time, but haven’t got around to doing until now; a “Tech Breakfast”. So I stopped at a bakery on the way to work to pick up some yummy baked goods, and all 3 of us …

Snapshot isolation and tempdb growth

Over the weekend we were alerted to a server running low on disk space. Not particularly exciting in itself, but the fact that it was happening on a relatively newly build SQL 2008 database server with a small database (~2.5GB) was interesting. This particular database belongs to one of our …

Our SQL Server “Denali” experiences – Part 1

I got around to installing SQL Server 2011 (Denali) on a production server last week, and fortunately it’s been pretty slick so far. And in case you’re wondering why it’s on a production server instead of a dev or test box, this particular SQL server is one of many that …

Where am I?

Well, right now I’m sitting in a hospital room waiting for my wife to come out of surgery – nothing too serious. In the mean time it feels like I’ve got a rather nice little office in fact; a comfy(ish) chair and desk in a private ward with good free wi-fi …

Public speaking jitters

The week before Easter, a colleague and I presented at the Wellington SQL Server User Group.  It was a first for each of us, and its fair to say neither of us was jumping with joy at the idea of it.  To ease into it we did a few things which …