A review: “Learning SQL Server 2008 Reporting Services” by Jayaram Krishnaswamy

A while back I got asked if I’d review this book, but as they could only get me a copy in PDF format, it’s taken a while to get to it. Whilst I like having electronic copies of books, I generally prefer to read them in paper form, and just have the electronic copy for … Continue reading A review: “Learning SQL Server 2008 Reporting Services” by Jayaram Krishnaswamy

Counting consecutive instances with DENSE_RANK

It’s hard to think of a practical use for DENSE_RANK(), but here’s one. It’s one of the ranking functions that was introduced in SQL Server 2005, along with RANK(), NTILE(n) and the incredibly useful ROW_NUMBER(). But apart from producing reports, it’s quite hard to find genuine uses for some of them. Yesterday I answered a … Continue reading Counting consecutive instances with DENSE_RANK

Annoying SharePoint error about features and templates

Following a successful installation of SharePoint (WSS) and making a new web application using a content database restored from another server, this annoying error appeared when on one of the sites. Feature ‘75a0fea7-2d1e-451a-b445-16bc346d78e’ for list template ‘1’ is not installed in this farm. The operation could not be completed. I say “annoying” because it seemed … Continue reading Annoying SharePoint error about features and templates

A really good book on BI

Business Intelligence is so much more than the technologies involved. Doing BI well is about delivering the right solution for the client, and being able to plan accordingly, about finding a match between the technologies and the business needs, and about being able to come up with a good design that incorporates not only the … Continue reading A really good book on BI

Hey Microsoft — let me restrict my network connections better!

I’m sure you know the feeling… you jump online by tethering to your mobile because you want to check a particular website, and all of a sudden you find your connection is being flooded by a Windows Update, or Live Mesh download, or a Sync Framework thing. Perhaps even Outlook is downloading your Junk Mail … Continue reading Hey Microsoft — let me restrict my network connections better!

Four speaking engagements coming up

I’m just going to list them… This Saturday (July 18th), at Code Camp SA. I’m going to be talking about functions in SQL, particularly those that involve BEGIN and END. At the end of the month, at the ACS Branch Conference. I’m going to be part of a panel discussing Open Source v Closed Source. … Continue reading Four speaking engagements coming up

DeepZoom fixoutlook — and a tip on hosting SilverLight

I haven’t done much SilverLight development — I’ve dabbled at best. And I don’t really count using DeepZoom Composer as proper SilverLight, but it makes a SilverLight application. So I’ve got one at http://www.lobsterpot.com.au/fixoutlook The background is that there’s a group of people who feel very strongly that Outlook should use proper standards for rendering … Continue reading DeepZoom fixoutlook — and a tip on hosting SilverLight

The new brand is Microsoft SQL Azure

It used to be SQL Server Data Services. Then SQL Data Services. Then we started hearing about SQL Services, and now (I hope finally), we have Microsoft SQL Azure instead of SQL Services, and the Microsoft SQL Azure Database instead of SQL Data Services. http://blogs.technet.com/dataplatforminsider/archive/2009/07/08/microsoft-sql-services-is-now-microsoft-sql-azure.aspx I think this is a sensible move. For a while … Continue reading The new brand is Microsoft SQL Azure

Excel dates counted differently and a reliable way of working out the day of the week

Following my recent post about 40,000 days, I got a couple of emails telling me that Excel disagrees about when the 40,000th day is. And this is true — Excel counts Day 40000 as July 6th 2009, not July 7th. Unfortunately for Excel users, they’re wrong. And it’s down to the fact that Excel thinks … Continue reading Excel dates counted differently and a reliable way of working out the day of the week

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 … Continue reading Big events every month this quarter