Resolving Analysis Services “The provider ‘SQLNCLI.1’ is not registered”

I know. While everyone else is moving on to SQL 2012 here I am upgrading a SSAS 2005 cube to SQL Server 2008 R2 Analysis Services. I can hear Garth imploring me to "Live in the now man!" So as I went about the mundane task of upgrading a cube from a really old version… Continue reading Resolving Analysis Services “The provider ‘SQLNCLI.1’ is not registered”

Formatting MDX and DAX: Free Online Tool From Microsoft

Ever cut and paste a mess of generated MDX from Excel? How about a coworker who doesn't know how to use the "tab" key when working in SQL Server Management Studio? I came across this no frills online MDX formatter from "Microsoft Labs" and have been using it for the last few days to clean… Continue reading Formatting MDX and DAX: Free Online Tool From Microsoft