Mat Stephen's SQL Server WebLog
All things SQL Server. Complied by Matthew Stephen - SQL Server Product Specialist, Microsoft UK
Analysis Services 2005
Free SQL Server Tools, Utilities and Addins
High Availability and Disaster Recovery
Performance Top Tips
Post Event Follow Up
SQL 64 bit
SQL Server 2000
SQL Server 2005
SQL Server Integration Services
SQL Server Security
Browse by Tags
Mat Stephen's SQL Server WebLog
analysis services 2005
Tagged Content List
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 and applications manage metadata and information...
3 Jan 2006
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 Server 2005 Latest versions of backward...
28 Nov 2005
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 Time: 18:00 Language: English Microsoft...
1 Nov 2005
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 is @ http://msdn2.microsoft.com/en-us/library/ms216599 . The...
4 Oct 2005
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 where hopefully about to hit Nature magazine. I...
19 Sep 2005
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 being continually published to this website http://www...
30 Aug 2005
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: XmlReader xmlReader = command.ExecuteXmlReader(); string xml = xmlReader.ReadOuterXml...
21 Jul 2005
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 set of SQL features – I can’t say for sure what the level...
21 Mar 2005
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 box’ features. There is one that is wholly revolutionary...
10 Mar 2005
Page 1 of 1 (9 items)
© 2013 Microsoft Corporation.
Privacy & Cookies