December 2009 - Posts

• Microsoft BI Conference 2010 joins TechEd 2010 North America

  Even if the site still is not updated, the Microsoft BI Conference 2010 will be joined with TechEd 2010 in New Orleans, LA. The conference will start on June 7, 2010, with a pre-conference day on June 6 (there are still no updates about BI Conference Read More... Posted Tuesday, December 29, 2009 12:12 PM by Marco Russo (SQLBI) | 0 Comments

• Distinct Count Measure in PowerPivot using DAX

  UPDATE: PowerPivot for Excel 2010 in SQL Server 2012 and Excel 2013 support the DISTINCTCOUNT aggregation in DAX. This blog post is relevant only if you use PowerPivot for Excel 2010 in SQL Server 2008 R2. A PivotTable based on PowerPivot data doesn’t Read More... Posted Saturday, December 26, 2009 2:02 PM by Marco Russo (SQLBI) | 140 Comments Filed under: DAX, PowerPivot

• The best analogy for PowerPivot so far

  I just read what I think is the best analogy for PowerPivot so far – these are the words of Amir Netz in a discussion: A good analogy is the relationship between mainsteam media (newspapers and TV) and internet blogs. In the old days (7 years back...), Read More... Posted Monday, December 21, 2009 5:44 PM by Marco Russo (SQLBI) | 3 Comments Filed under: PowerPivot

• Many-to-Many relationships in PowerPivot

  UPDATE: This blog post is still good for learning DAX principles, but a better description of many-to-many patterns is available on The Many-to-Many Revolution whitepaper that is available here: http://www.sqlbi.com/articles/many2many/ - please download Read More... Posted Monday, December 7, 2009 8:30 AM by Marco Russo (SQLBI) | 92 Comments Filed under: DAX, PowerPivot

• SSIS remote execution and SqlBulkCopy performance analysis

  In the last few days Alberto wrote two very interesting posts: Remote Execution of SSIS Packages - this is something that many many people asked me since 2005. Now there is the complete code with the solution to this issue. Considering that SSIS 2008 Read More... Posted Friday, December 4, 2009 2:40 AM by Marco Russo (SQLBI) | 0 Comments