If you have trouble installing SQL Server 2005 SP1 and you found in the log that views sys.dm_exec_query_resource_semaphores and sys.dm_exec_query_memory_grants are missing, then you have to move the Resource database into the same path of master database.  Read more

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