Marco Russo's Blog posts of 2006

Page 2 of 45 results

Unicode, VARCHAR, NVARCHAR and index usage in SQL Server

This is not the first time I found non-intuitive issues with collation, Unicode and 8-bit strings with SQL Server, but this time I discovered (more precisely: one of my customers discovered and asked me…) a strange behavior that affects the query plan  Read more

SSAS suggestions for Katmai: perspectives and drillthrough

I just added two suggestion items to my feedback for SSAS2005. The first suggestion is about the perspectives: it would be useful to select member filters and default members on each single perspective. Another important thing could be to be able to rename  Read more

SQL Refactor in public beta

I am trying the beta of SQL Refactor (available here ). It is really helpful to refactor the layout of a query and I like to do this in at least three scenarios: when I read a query written by other people, when I need to modify a query in a Reporting  Read more

Using MSOLAP as a linked server

I just faced the problem to connect an Analysis Services (2000 or 2005) to a SQL Server 2005 database using a OPENROWSET statement. If you face an “access denied” error (precisely, “The OLE DB provider “MSOLAP” for linked server “SERVERNAME” reported  Read more

The many-to-many revolution: paper finally released!

After a month of editing, I finally released my paper titled “The many-to-many revolution”. I copied in this post the introduction of the 84-page paper that is published (for free!) on a dedicated dimensional modeling page of SQLBI.EU web site. I would  Read more

Refresh of a linked dimension in SSAS

I started to evaluate the use of linked dimension across different database on the same server. I encountered the first issue after a few minutes: when you link a dimension, VS editor create a dimension file that copies the structure of the dimension,  Read more

How to handle schema in Visio database modeling

Alberto Ferrari wrote a nice post with a workaround to generate tables in different SQL Server 2005 schemas starting from a single Visio document. The trick includes a SQL script to do the magic. I hope that next Visio version would be able to do that  Read more

Many-to-many dimensional modeling paper: looking for reviews

I’m approaching the review phase for a paper I wrote about advanced dimensional modeling with Analysis Services 2005 using many-to-many dimension relationships. Currently the paper has around 80 page (with many figures!) and covers 2 base techniques (base  Read more

Wiki on BI with SQL Server

I just opened the wiki on SQLBI.EU : it contains link to useful resources for BI solution development with SQL Server, so it covers SSIS, SSAS, SSRS and of course SQL Server itself. The wiki works well when there is large contribution, so please share  Read more