April 2005 - Posts

• Useful Reporting Service Scripter tool

  I just discovered Reporting Services Scripter , which seems a very useful tool to move Reporting Services objects between different servers. Thanks to Davide Mauri for the link. Read More... Posted Thursday, April 28, 2005 7:02 PM by Marco Russo (SQLBI) | 0 Comments

• Reporting Services 2000 SP2: SharePoint Web Parts available now!

  After a few months of beta, SQL Server 2000 Reporting Services Service Pack 2 is finally available! As I said in a previous post , there are two SharePoint Web Parts to list and render reports inside a SharePoint site. Really great news. Read More... Posted Friday, April 22, 2005 10:11 PM by Marco Russo (SQLBI) | 0 Comments

• sp_OAxxx are evil

  Today I've got a question from a student (I was teaching a DTS/AS course) that asked me if the use of sp_OAxxx stored procedures to launch a DTS package execution is a good thing (of course, in a production environment). My answer is very simple: never Read More... Posted Friday, April 22, 2005 9:59 PM by Marco Russo (SQLBI) | 0 Comments

• Populating a fact table with SSIS

  Approaching SSIS (Sql Server Integration Services) from a DTS background one of the questions that comes to mind is: what is the better way to populate a fact table? Assuming you have a conventional star schema, you should have a fact table with two kind Read More... Posted Friday, April 01, 2005 11:33 AM by Marco Russo (SQLBI) | 0 Comments