Welcome to TechNet Blogs Sign in | Join | Help

Analysis Services 2005 (RSS)

Tuesday, January 03, 2006 5:14 PM

SQL 2005 Metadata Samples Toolkit and whitepaper now available

Reposted 10/1/06 to include in 'free tools' category  I'm constantly asked "what's Microsoft doing about metadata and do we have a solution." In the old days (SQl 2000 and 7), Microsoft provided Meta Data Services, a platform designed to help tools
posted by Mat_Stephen | 0 Comments
Filed Under: , , , , ,
Monday, November 28, 2005 5:47 PM

Feature Pack for Microsoft SQL Server 2005 - November 2005

Overview The Feature Pack is a collection of standalone install packages that provide additional value for SQL Server 2005. It includes: Latest versions of redistributable components for SQL Server 2005 Latest versions of add-on providers for SQL
posted by Mat_Stephen | 3 Comments
Filed Under: , , , , ,
Tuesday, November 01, 2005 12:42 PM

TechNet Briefing: What's NEW in SQL 2005 - Analysis Services & Data Mining

Here's a little self publicity for gig I'll be doing in December: To register please go to https://msevents-eu.microsoft.com/cui/EventDetail.aspx?culture=en-GB&eventid=118761637 05 December 2005 18:30 - 05 December 2005 21:00 (GMT) GMT, London Welcome
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
Tuesday, October 04, 2005 1:07 PM

Microsoft .NET Data Provider for SAP

After my recent SQL 2k5 BI session, here at TVP Reading, I had an enquiry asking for more info regarding the SAP provider I showed in the list of providers available to SQL Server Integration Services .  The best public information I can find
posted by Mat_Stephen | 0 Comments
Filed Under: , , , , ,
Tuesday, September 20, 2005 12:59 AM

OLAP, Darwin and Evolution

Edited 21st Sept 05 to include picture of herbarium sheet.   In my article 'Business Intelligence (BI): The way it is without the blah blah', I mention that I was aware of some exiting research using the SQL Server OLAP engine, the results of which
posted by Mat_Stephen | 0 Comments
Filed Under: , , ,
Tuesday, August 30, 2005 4:27 PM

Project REAL—Business Intelligence in Practice - great website!

For sometime a group of Program Managers from the SQL BI team have been working with a customer, Barnes and Noble, to produce a SQL BI solution for their data warehouse and analysis needs using SQL 2005.  The leasons learnt from all their work is
posted by Mat_Stephen | 0 Comments
Filed Under: , , , , , ,
Thursday, July 21, 2005 2:38 PM

Serialising an ADOMD.net CellSet object

I'm grateful to T.K. Anand for this useful code snippet which is useful if you're writing a web services client that consumes OLAP data. The following Adomd.net code can be used for saving and loading cellsets… Save:           
posted by Mat_Stephen | 0 Comments
Filed Under: , , ,
Monday, March 21, 2005 9:48 PM

Using SQL against the Unified Dimension Model in Microsoft SQL Server 2005 Analysis Services

Following Deepak's question, asked in his comment on my previous UDM post, I quizzed our internal Yukon alias and received the following useful info regarding using SQL against a UDM;  thanks to Akshai Mirchandani.   AS2005 supports a limited
posted by Mat_Stephen | 1 Comments
Filed Under: , ,
Thursday, March 10, 2005 12:40 PM

Microsoft SQL Server 2005 Analysis Services – Unified Dimensional Model (UDM). Can you get your head round it? If you do BI, you’ll need to!

There are very many, and from my own professional perspective, too many (I’ve got to try and learn all this stuff) new features in SQL 2005.  Some of them can be described as ‘catch up’ features and some of them might be described as ‘tick in the
posted by Mat_Stephen | 5 Comments
Filed Under: , ,