Big events every month this quarter

A new Financial Year in Australia, and a bunch of technical events coming up. Of course there’s the usual monthly user groups, but there’s more – particularly if you’re in Adelaide. July sees CodeCampSA in Adelaide on the weekend of July 18/19. I’ve put my name into the hat for speakers, and will try to be there for a chunk of Saturday (Sundays are too busy for me). I’m sure at least one of my sons will want to come along as well, which will be fun. Big thanks to David Gardiner for putting the website together. August sees SharePoint … Continue reading Big events every month this quarter

40,000 days since the beginning of ‘time’

Next Tuesday feels like a significant day. Not only is it 7/7, and the fourth anniversary of the London bombings (in 2005), but it’s 40,000 days since the beginning of time. Well, not proper time, but since the start of the 1900s. SELECT DATEDIFF(day,’19000101′,’20090707′)+1 AS DaysOf1900s So if Day 1 is Jan 1, 1900 (as many systems tend to use – SQL actually considers it Day 0), Day 40000 is 7/7/2009. I actually rate the start of the twentieth century as a very significant event in the human race. In 1900 the world was changing faster than it had ever … Continue reading 40,000 days since the beginning of ‘time’

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 the View menu. Now you can find the Beep in the “Non-Plug and Play Drivers” section and edit its properties (setting it to Disabled).

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 help from Paul Randal & Kimberly Tripp, Conor Cunningham and Adam Machanic – all SQL Server legends in their own right. The book they have made is just excellent, and should be read by everyone who wants to get deeper into SQL Server. There are … 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. One of the things he mentioned was DISTINCTROW. I’ve never really known what DISTINCTROW does, so I asked him. He sent me a link which explained the difference between DISTINCTROW and DISTINCT, and it described as “DISTINCTROW works on records, not just individual fields”. This … 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 an SSAS (2005) Calculated Member in a cube, and then have trouble trying to get it into a Display Folder, or associating it with a Measure Group… I always hit F4 and go hunting through the properties list… repeatedly pull down the drop down that … Continue reading Putting a Calculated Member into a Display Folder