We write articles and white papers on Microsoft Business Intelligence technologies on a regular basis. The list below showcases all our content sorted chronologically - you can filter through the content by post type, topic, and author.
     Page 91 of 943 posts
blog post –

Report Builder Model with UDM

Today I lost a lot of time digging on this problem so a I hope post about this will save time of other developers! I wanted to import the UDM into a model for Report Builder. You have to do these steps: go into SQL Server Management Studio connect to  Read more

blog post –

SQL Server 2005 Feature Pack

The SQL Server 2005 Feature Pack is freely downloadable and contains a set of useful tools for SQL Server 2005: many items are for compatibility issues (DTS/DSO/DMO backward compatibility), but there are data mining viewer controls and JDBC drivers for  Read more

blog post –

SSIS: how to migrate Data Transformation Task of a DTS

As you already know, the DTS migration wizard of SSIS 2005 doesn’t migrate Data Transformation Task in a Data Flow component, but instead it uses to encapsulate each Transformation Task into a legacy embedded DTS 2000 package. Now, you can imagine my  Read more

blog post –

AS2000 magics: working without repository

Today I discovered that you can have a working AS2000 database without repository data relative to structure internals to that database (cubes and dimensions). Just to explain how it works. You have a “Foodmart 2000” database Into the Olap Data directory,  Read more

blog post –

Star schema vs. snowflake with SSAS2005

Recently I discovered that a very large dimension could be loaded more effectively by SSAS2005 if it is designed as a snowflake schema instead than as a singular table (star schema). I have to say that I’m a strong supporter of star schema, but these  Read more

blog post –

SSAS2005 connection via HTTP

A short post to link this article: Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows Server 2003 . Very useful: I haven’t found a clear description for this task in Books On Line (but, we know, beta documentation is not  Read more

blog post –

SQL 2005 Data Mining articles and books

This useful post of Karen Watterson has a link to the first chapter of the upcoming book Data Mining with SQL Server 2005 by ZhaoHui Tang and Jamie MacLennan. In the same post there are other useful links to articles and video about Data Mining on SQL  Read more

blog post –

Excel 12 BI revealed

I’ve just attended the Excel 12 BI session held by Amir Netz and Allan Folting. This is the first time that Excel 12 BI functionality are shown to the public. My expectations seems to be satisfied, even if I really want to put my hands on a Beta, but  Read more

blog post –

Excel 12 and SharePoint v3

I’ve seen Excel 12 and SharePoint v3 integrated with SQL Server 2005 Report Builder and Analysis Services here at PDC: we’ve seen very little, but enough to understand that this combination is what can really leverage on SQL 2005 BI capabilities. Tomorrow  Read more

blog post –

SSIS Migration Wizard as Shared Source: yes, please!

I’m sitting in DAT411 session room and I’ve just heared that Microsoft is considering to release SSIS Migration Wizard as shared source: please do it and do it now! :-) I’ve a lot of DTS packages that could be really better migrated if only I could modify  Read more