May 2007 - Posts

• Drop views from a schema

  Today I wrote a procedure to drop all views from a schema (and the schema itself) in SQL Server 2005. I use views to expose objects to SSAS DSV and it's useful having a cleanup code. Here's the script: DropSchema drop all the views and the schema itself, Read More... Posted Wednesday, May 30, 2007 4:33 PM by Marco Russo (SQLBI) | 0 Comments Filed under: SQL Server 2005

• Is Microsoft serious about BI?

  The short answer is yes. The long answer is that Microsoft should still improve in many ways. I thought about this many times before writing this post, because I want to be constructive and I hope that my words will not be misunderstood. My consideration Read More... Posted Saturday, May 26, 2007 2:17 PM by Marco Russo (SQLBI) | 2 Comments Filed under: Integration Services, SQL Server 2005, SSAS, SSIS

• BIDS Helper beta 0.9

  BIDS Helper is an addin for Visual Studio that really improves productivity developing solutions for Analysis Services. Today I tested it and looking for its feature I encountered a page describing the "Show Extra Properties" feature... and it links a Read More... Posted Monday, May 21, 2007 6:11 PM by Marco Russo (SQLBI) | 0 Comments Filed under: BI Developer Studio, BIDS

• Attribute Aggregation Usage Priority

  I and Alberto have posted a suggestion on Microsoft Connect to improve aggregation wizard behavior in a future version of SQL Server. The idea is to give an aggregation usage priority to dimension attributes for each cube or measure group. If you find Read More... Posted Thursday, May 17, 2007 1:17 AM by Marco Russo (SQLBI) | 0 Comments

• Calculation in Time dimension

  David Shroyer published an interesting paper about a Different Approach to Implementing Time Calculations in SSAS . It is something I would have found the time to write since Analysis Services 2000 (I have being using a similar approach since then) and Read More... Posted Wednesday, May 16, 2007 1:29 PM by Marco Russo (SQLBI) | 0 Comments

• The Many-to-Many Revolution available as a printed book

  During the Microsoft Business Intelligence Conference 2007 we distributed a free printed copy of The Many-to-Many Revolution to attendees who visited our booth. Now the same book can be ordered on Lulu.com paying only the print and shipping costs (we Read More... Posted Tuesday, May 15, 2007 3:17 PM by Marco Russo (SQLBI) | 0 Comments

• Microsoft BI Conference 2007 comments

  The Microsoft Business Intelligence Conference 2007 has been a good conference. Not very good, probably as a result of its success. Microsoft wanted to send the message "we are serious in the BI market" with this event. From my perception, half of attendees Read More... Posted Monday, May 14, 2007 4:52 AM by Marco Russo (SQLBI) | 0 Comments

• SQLBI at MS BI Conference 2007 - Day 2

  Now that our presence as exhibitor is finished (Day 3 is only for keynote and breakout sessions), we can say that we had a great success! We distributed all the 300 copies of The Many-to-Many Revolution paper we printed just to show the kind of content Read More... Posted Friday, May 11, 2007 6:58 PM by Marco Russo (SQLBI) | 1 Comments

• SQLBI at Microsoft BI Conference 2007 - Day 1

  The first Microsoft BI Conference started today and we received a lot of people at our booth. Thank you to all the people who came to visit us! Read More... Posted Thursday, May 10, 2007 5:30 AM by Marco Russo (SQLBI) | 1 Comments

• Introducing Microsoft LINQ book

  Usually I blog about Business Intelligence, but BI is not the only field I work on. I born as developer and I recently co-authored a book about LINQ with Paolo: the title is Introducing Microsoft LINQ , we created a dedicated site where you can find blog Read More... Posted Monday, May 07, 2007 10:32 AM by Marco Russo (SQLBI) | 1 Comments

• SSAS: Model on the server vs. client-side MDX

  In the last two years I worked on advanced modeling with Analysis Services. One result of this was the paper " The many-to-many revolution " I released in September 2006. Since then, I got a lot of feedback and I have been working on other evolutions Read More... Posted Sunday, May 06, 2007 6:34 AM by Marco Russo (SQLBI) | 0 Comments

• A better solution to control multi-phase data pump in DTS editor

  Almost two months ago I wrote a post about the lack of multi-phase data pump control in Management Studio "legacy" user interface for DTS. Microsoft answered that documentation has the workaround I have found using RegEdit... In the meantime, I received Read More... Posted Friday, May 04, 2007 12:55 AM by Marco Russo (SQLBI) | 0 Comments