Here’s something I was up to during the week. It’s a fairly mundane task, but despite that one which is very important, both to the client I was doing it for, and for most people generally who run this type of configuration. The databases I was working with were part of a true 24×7 configuration where any… Continue reading Step by Step procedure for rolling upgrades to database mirroring for SQL Server 2008
Month: February 2012
Tracing select statements on specific objects in SQL Server without using Profiler
I published a blog post with Basefarm last week about tracing select statements in SQL Server without using profiler. It demonstrates how to use SQL Audit (based on extended events) to record any select statements issues on particular tables over a prolonged time period in a scalable lightweight way. Although SQL Audit was designed as… Continue reading Tracing select statements on specific objects in SQL Server without using Profiler
Viking boat in Stockholm
There’s nothing particularly special about this photo apart from to say that i find it very evocative of my time in Stockholm. Quite what the Viking boat is doing I was never sure, but it’s just that it’s there that makes me think of Stockholm generally in that there always seemed to be something like this happening… Continue reading Viking boat in Stockholm
Looking south east from Åre high zone
A beautiful sunny day near the top of the cable car in Åre, this is a surprisingly good photo considering that it was taken with a mobile phone, a winmobile 6 one at that! Those were the days eh, stylus in hand…..thank god for the HTC sense which made it almost useable, although it did… Continue reading Looking south east from Åre high zone
Looking north over Amberley from the South Downs Way
This is one of my favourite photos of all time, this is my default screen saver on all my machines, if you ever employ me or have me around your office, you’ll notice this on all of my devices. (when I haven’t got SSMS or notepadd++ open that it is) It’s taken from the south… Continue reading Looking north over Amberley from the South Downs Way
Coming back from Grinda
Over the past few years I’ve published content in all sorts of places across the web. I’ve finally managed to find a few hours to set up my domains properly, play with a bit of wordpress and try to centralise all my content going forward. This site is the result of that work and I… Continue reading Coming back from Grinda