-
Some days ago I posted my troubles with SSIS after SP1 install. Today Microsoft has published KB918644 where this behavior is officially described as a bug. It seems that product feedback is working well... Read more
-
I tried MapPoint 2006 hoping to see an improved interface to UDM data. Unfortunately it seems there is not a direct support to OLAP cubes and a dynamic navigation with territory dimension. I wrote a proof-of-concept of a .NET WinForm application that Read more
-
The use of DiscretizationMethod=Clusters can cause a process error that is not so clear: Internal error: Unexpected error. File 'mddiscretizer.cpp', row 1532, function 'MDDiscretizer::GetBucketForValue'. This happens because you have an attribute with Read more
-
SQL Server 2005 SP1 seems to stop many working installations of SSIS service. I lost some hour on this problem and only a few days after I discovered a good workaround here . While you install SQL Server 2005, setup procedure brings you to use NETWORK Read more
-
Today I implemented a classification through a NTILE equivalent function. The T-SQL NTILE implementation has very bad perfomance when used against large datasets of rows, so I and Davide Mauri realized a better implementation that Davide posted some weeks Read more
-
I just exited from the SharePoint 2007 odissey to correctly configure settings to get updates from Analysis Services 2005 cubes. The big problem is the Microsoft Single Sign-On service, that is the single component who really make the data connection Read more
-
I'm trying to use SqlBulkCopy removing a C++ DLL I wrote two years ago to create staging tables in SQL Server from remote databases, dynamically creating queries to get data basing on table structure I defined into the staging database. This tool helped Read more
-
The news is that Microsoft announced it has agreed to acquire ProClarity . Now a decent client for Analysis Services 2005 will be available from Microsoft, and I hope that a new commercial licensing scheme will allow to small companies to get a mixed Read more
-
I recently had some problem with memory configuration of SQL Server Analysis Services 2005 and I'd like to share lessons I got. This post is a replacement for my previous post , that I striked to keep history of some bad assumptions I initially made. Read more
-
I recently discovered a few pitfalls on memory configuration of SQL Server Analysis Services 2005: the main problem is that the default configuration (written by setup) doesn't consider the actual physical resources (mainly RAM) of your server and this Read more