I have being a user of PromptSQL since version 1.0. This utility was acquired by Red-Gate some months ago and today they shipped the version 2.0, renamed ad SQL Prompt 2.0 . SQL Prompt is fundamentally the ability to add Intellisense when you are editing  Read more

I just had to profile MDX queries sent to SSAS from some client. Office Web Components (that are used in the cube browser of Management Studio) in many circumstances send a lot of MDX queries, increasing roundtrip between client and server, resulting  Read more

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