Marco Russo's blog posts of 2010

61 blog posts
blog post –

A new Excel 2010 book for Data Analysis

Microsoft Press just announced the printing of Microsoft Excel 2010: Data Analysis and Business Modeling , which is the third edition of the book written by Wayne L. Winston covering many data analysis and modeling techniques using a very clear problem-solution  Read more

blog post –

Clearing standby cache (and other caches) in Analysis Services

Greg Galloway just released a new version of the Analysis Services Stored Procedure Project that includes a command to clear the File System Cache , including the standby cache. A technical discussion about how it works is available in this post on his  Read more

blog post –

Programming Microsoft LINQ in .NET 4

30 months after the LINQ book based on .NET 3.5, it is now available the Programming Microsoft LINQ in Microsoft .NET Framework 4 ! I wrote this book with Paolo Pialorsi and we updated existing content adding several chapters. This is the list of chapters:  Read more

blog post –

Monitor SSAS performance counters using a cube!

This is a tool I would have mentioned in the Expert Cube Development with Microsoft SQL Server 2008 Analysis Services book I wrote last year. Unfortunately, the ResMon sample cube has been published just a few days before PASS Summit 2010 on CodePlex.  Read more

blog post –

Varigence Vivid and Bonavista Dimensions

Yesterday Chris blogged about Varigence Vivid and Bonavista Dimensions . His post remembered me that I might share my comments about Vivid and I had to take a tour around Bonavista Dimensions, and here we are. Varigence Vivid is simply something that  Read more

blog post –

PowerPivot Workshop – last days to register

There is less than one week (and only a few seats) available to register to the first PowerPivot Workshop that will be held in the Netherlands on December 1-2, 2010. I and Alberto spent the last days to refine the last slides and demo. Despite the workshop  Read more

blog post –

PowerPivot Sessions from TechEd OnLine

If you have not been at Microsoft Business Intelligence Conference this year, which was co-located with TechEd 2010, you probably missed the sessions I and Alberto made there. Well, now you can watch them online on Microsoft TechEd Online site: DAX Patterns  Read more

blog post –

The Microsoft BI Roadmap: BISM, UDM and Beyond

Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it  Read more

blog post –

PowerPivot ebook – 50% discount offer of the day

Yesterday I delivered my Inside DAX session at PASS 2010. Someone might have missed the link to buy the PowerPivot for Excel 2010 book with a 50% discount that is valid just today. The link is http://oreil.ly/sqlpass2010 !  Read more

blog post –

SQL Server Monitoring

I’m not a DBA, but I’ve been impressed about how much intuitive and easy to use is the online demo of SQL Monitor from Red Gate . This is what I would really call a useful Dashboard. It could be a good demo for a CFO too!  Read more