Browse by Tags
All Tags »
Business Intelligence (RSS)
I promise this is the last time I mention SQL Bits this week, but I wanted to let you know I have got 25 free tickets for the paid for event this Friday which would normally cost £149 to attend. The venue is the Celtic Manor in Newport… and is probably
Read More...
The first publicly available technical preview of SQL Server 2008 R2 has just been released to TechNet / MSDN subscribers. As with the development of SQL Server 2008 each successive CTP will have more features in. This CTP’s main feature is the
Read More...
Chris Webb MVP can, to quote a friend of mine can, “Make MDX sound interesting”. I have to say when I first when on a course on MDX the tutor went for the “Make MDX confusing and boring” approach. Chris has recently coauthored a book on Expert Cube
Read More...
One of the fundamental dichotomies in development is the relational world of the database and the object orientated world of services, which sadly spills over into developers and DBA’s not always being the best of friends. Developers don't always
Read More...
I wanted to call out the BI evening on 10th June because they’ve given me a slot to talk about SQL Server 2008 r2 and specifically the BI features you can expect. There’s also sessions on Data Modeling and information architecture from Alex
Read More...
There’s a lot of heat on MP’s expenses so if you want to quickly see how your local MP compares then have a look at them on Virtual Earth here .. What I like about this is that it shows the spikes, so in my neck of the woods this MP is in red because
Read More...
I have seen some comments on the tweet sphere about SharePoint 2010 only being available as a 64 bit application. I don’t have a problem with this for a number of reasons: SharePoint like SQL Server loves memory and as document sizes and the richness
Read More...
Metadata is “data about data” and in the BI world this means two things: Definitions of terms, particularly calculations so that business users can understand what they are looking whether on screen or on paper. Lineage to understand where and how
Read More...
Sometimes when you run a report it’s not going to return any rows, perhaps because the user selected a filter for which there is no data, and that needs to be handled properly. Fortunately there’s a simple way to control the messaging when this
Read More...
Speaking at SQL Bits is a cool thing to do but may terrify many of you. Part of this is that you are on stage for an hour and that means a lot of preparation, both content and rehearsal. So one of the organisers, Martin Bell has come up with
Read More...
In pretty well any service industry you can leave feedback about your experience, even Microsoft will pester you to fill in evaluation forms whenever you attend one of our events. However while the NHS often seems to be awash with scorecards
Read More...
It’s time to spring clean the blog as I have realised that a few of my older posts have been overtaken by events and could be misleading if they were acted upon now. For example: SQL Server 2008 is now supported on VMWare and other virtualisation platforms
Read More...
Many resources on data warehousing talk about slowly changing dimensions and how to deal with them but what happens when your dimensions change more quickly and what is does fast or quick mean in in this context? First let’s be clear on what is meant
Read More...
A key part of business intelligence is the collaboration between the business user and the BI IT professional and so Microsoft are running a one day seminar addressed to both of these audiences. The well renowned BI guru Rafal Lukawiecki is running this
Read More...
I have just been following a thread about using reporting services 2005 to produce a 55,000 row excel spreadsheet. The initiator of the thread was concerned that the report was locking up and was looking for a fix. I could suggest migrating to SQL Server
Read More...
Subscribe in a reader" />
