December 2005 Entries
This month's Melbourne SQL Server User Group meeting was all about the CLR integration in SQL 2005. There has been a lot of hype about this feature and you can find various views ranging from “use it for everything” to “don't even enable it”. The talk we given by one of our local members, Greg Obleshchuk from A & G Software and I think he did a great job of presenting the good points of the CLR integration and highlighting when to use it and when not to use it. As a general ......
[via Chris Webb] I've just found the 'SQL2005 BI Metadata Samples Toolkit', downloadable from here:http://www.microsoft.c... I have added this to my collection of downloaded tools :) It sounds pretty interesting and as Chris says, could be really helpful on a large project that has a team of developers working on it. I will be interested to see if it will applications for consultants like me when we get called ......
Nick Barclay, another BI blogger from downunder, has just blogged about using Visio 12 as a BI client. It sounds interesting, things such as being able to associate areas of a map with KPIs or Measure from a cube sounds like it might have potential. It will be interesting to see how this comes off in practice. Chris Webb has also been blogging about Office 12 with some details about the BI features in Excel 12 ......
I have been answering a couple of questions on the microsoft.public.sqlserver.... newsgroup about code for keeping the page filters for multiple pivot tables in synch in the one Excel workbook. One person had 2 pivot tables on the one sheet and another had 2 sheets with a pivot table on each one. I was starting to get mixed up between the two threads so I thought I would just build a solution that would work across all pivot tables across all sheets in the workbook. The workbook I created contains ......