December 2005 Entries

SQL Server User Group December 2005 - SQL CLR Integration
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 ......

Posted On Wednesday, December 21, 2005 7:03 PM | Comments (0)

SQL2005 BI Metadata Samples Toolkit
[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 ......

Posted On Tuesday, December 20, 2005 6:18 PM | Comments (3)

Visio 12 - a BI Client?
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 ......

Posted On Monday, December 19, 2005 7:09 PM | Comments (0)

An Excel Workbook that keeps the filters for all pivot tables synchronised
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 ......

Posted On Wednesday, December 14, 2005 4:43 PM | Comments (31)