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 93 of 948 posts
blog post –

BizTalk 2004 and Analysis Services: bad cubes?

In these last busy two months I’ve seen many things that deserves to blog, but until now I hadn’t time to do it. But today I have 5 minutes to talk about the current BizTalk 2004 integration with Analysis Services 2000: this time I have some critics to  Read more

blog post –

Multiple DISTINCT COUNT measures in SSAS 2005

Analysis Services has a limitation of one distinct count measure for each measure group; in the past, it was a limitation for the single cube. Each distinct count measure cause an ORDER BY clause in the SELECT sent to the relational data source during  Read more

blog post –

QueryLog in Analysis Services

More than 2 years ago I posted on the microsoft olap newsgroup a bug on the QueryLog table that Analysis Services uses to log user queries (very important to make usage based optimization). A KB was supposed to be pending, but after two years and a service  Read more

blog post –

Transform Data Task (DTS2000) and SSIS

My first period using SSIS in a real-world application convinced me that there is a lack of support in migration of SQL2000 DTS packages, expecially in a star schema transformation scenario. Most of my actual DTS packages are combinations of SQL Execute  Read more

blog post –

SSIS2005 feature request (small things)

May be it’s too late, but I think this requests (for SQL Server Integration Services 2005) could be scheduled at least for a SP1 if it’s not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task  Read more

blog post –

Surrogate key generation in SSIS

In the last few days I tested several ways to generate surrogate keys when loading a dimension into a data mart. The classical approach with SQL Server is to rely on a INT IDENTITY column. It works fine, but you don’t know what surrogate key has been  Read more

blog post –

Cascading many-to-many dimensions: unsupported scenario?

I already opened a bug and written on newsgroup about this specfic scenario, but I still haven’t received an answer. This morning I met Chris Webb in Munich (I’m attending SQL Pass Europe ) and he told me that one year ago someone of MS told him that  Read more

blog post –

Database snapshots to feed a data warehouse?

I just attended the pre-conference of Kimberly Tripp at SQL Pass 2005 Europe . The topic was “New SQL Server 2005 features that a DBA need to learn” and I took advantage of this day to cover an area of SQL2005 I still haven’t explored. One consideration  Read more

blog post –

Useful Reporting Service Scripter tool

I just discovered Reporting Services Scripter , which seems a very useful tool to move Reporting Services objects between different servers. Thanks to Davide Mauri for the link.  Read more