Disabling the beep

I thought I’d blogged about this before, but when talking about with Simon Sabin just now, I couldn’t find it. Simon’s just blogged a couple of ways of stopping the beep from the command line. Here’s one using a User Interface. Go to Device Manager, and make sure that “Show Hidden Devices” is checked in … Continue reading Disabling the beep

A review — SQL Server 2008 Internals

I’m reading SQL Server 2008 Internals at the moment. I say ‘reading’, because I think it’s going to be long-term thing. It’s just so full of useful information, that I’m sure I’ll be reading it over and over for a long time yet. Kalen Delaney’s books are always great, but in this one she has … Continue reading A review — SQL Server 2008 Internals

Access’ DISTINCTROW keyword explained — it means WHERE EXISTS

Steve Koop spoke recently at the Adelaide SQL Server User Group, talking about things which don’t convert particularly nicely when upsizing from Microsoft Access to SQL Server 2008. I think this is a really important thing for SQL people to know, as there seem to be many Access databases living in even the largest organisations. … Continue reading Access’ DISTINCTROW keyword explained — it means WHERE EXISTS

Putting a Calculated Member into a Display Folder

There are some blog posts that are there to inform other people — this isn’t one of these. This is something I always seem to forget, and I’m hoping that writing it in here will cause me to never forget again. It’s the knot in my handkerchief, or the writing on my hand. I put … Continue reading Putting a Calculated Member into a Display Folder