May 2006 - Posts

• Post hotfix post-SP1 problem with DTS Designer

  After I installed build 2153 , my SQL Server Managment Studio DTS 2000 Package Designer (which is part of SQL Server 2005 Feature Pack ) was not working. After I searched for an updated feature pack (which has not been released) I discovered that the Read More... Posted Tuesday, May 23, 2006 1:31 PM by Marco Russo (SQLBI) | 0 Comments

• SQL Prompt 2.0

  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... Posted Monday, May 22, 2006 6:37 PM by Marco Russo (SQLBI) | 0 Comments

• MDX quality improvement in Excel 2007

  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... Posted Sunday, May 21, 2006 6:11 PM by Marco Russo (SQLBI) | 0 Comments

• Solved trouble with SP1 setup

  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... Posted Sunday, May 21, 2006 7:04 AM by Marco Russo (SQLBI) | 0 Comments

• SSIS service does not start with SP1: KB filed it as a bug

  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... Share this post: email it! | bookmark it! | Read More... Posted Monday, May 08, 2006 5:55 PM by Marco Russo (SQLBI) | 0 Comments

• MapPoint 2006: first impressions

  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... Posted Tuesday, May 02, 2006 6:49 PM by Marco Russo (SQLBI) | 0 Comments