Author: Note to self
When setting up a virtualised clustering environment, using a base install of Windows that you want to clone for use later, remember to run sysprep BEFORE cloning. Thanks to James for pointing out the glaringly obvious.
My laptop is crying
I’ve finally got all four virtual machines required (per Jonathan’s blog series), up and running on my laptop, and it is taking serious strain. I’m inclined, in fact, to change all the machines from 2 vCPUs to a single vCPU each, because that’s what’s killing the machine. Then again, I never considered until February 2012Continue reading My laptop is crying
And he’s back …
A week ago, I had just returned from a three-week sojourn in sunny Tampa, where I spent most of the time indoors, far away from the sun, relearning everything about SQL Server. Those three weeks are best summarised in my previous blog entry, where I described Immersion Event 1. The result was that I wantedContinue reading And he’s back …
Remove duplicate indexes in SQL Server 2000
With permission from Kimberly Tripp, the creator of the fantastic duplicate index finder for SQL Server 2005 and 2008, I have ported this duplicate index finder to SQL Server 2000. I am fortunate in many respects, in that SQL Server 2000 does not support included columns, nor disabled indexes, so the scripts themselves were straightforward.Continue reading Remove duplicate indexes in SQL Server 2000
My brain hurts
Kimberly Tripp has a very neat series of stored procedures on her blog which are rewrites of sp_helpindex. Unfortunately for those of us with customers still using SQL Server 2000, these scripts are useless, because they are based on DMVs and catalog views built into SQL Server 2005 and higher. With her permission, I haveContinue reading My brain hurts
My first week of three with SQLskills Immersion Events
There are words that can accurately describe how I’m feeling right now. These would include exhausted, drained, tired, sleepy, somnolent, and soporific. Then there are other words that can describe my state of mind, which would also be accurate: inspired, grateful, excited, awed, amazed, and invigorated. The latter have resulted in the former, and whileContinue reading My first week of three with SQLskills Immersion Events
Still cruisin’ …
For my 35th birthday, M took me on a Caribbean cruise, on the Allure of the Seas, from Fort Lauderdale to Labadee, Costa Maya and Cozumel. It was possibly the best holiday I’ve ever had, notwithstanding the awesome holidays I’ve had in the past. So without getting all gushy, I’d highly recommend this sort ofContinue reading Still cruisin’ …
New stuff
Yesterday I attended my second meeting of the local writers’ group in town. I wrote something for the meeting, as well as a shorter piece during the evening (they call it a “prompt” where everyone writes for ten minutes from the same prompt, or opening line). Both of these pieces are available on my OriginalContinue reading New stuff
Ten years on
On 20 February 2012, just over a month from now, my blog will turn ten years old. This site, such as it is, won’t be as old, but I’ll have had a website for 16-and-a-half years. Last year I began writing a very long piece about how I’d been online for fifteen years and whatContinue reading Ten years on
Puns for Educated Minds
(Via Yolande) 1. The fattest knight at King Arthur’s round table was Sir Cumference. He acquired his size from eating too much pi. 2. I thought I saw an eye doctor on an Alaskan island, but it turned out to be an optical Aleutian. 3. She was only a whiskey maker, but he loved herContinue reading Puns for Educated Minds