A few days ago I wrote how can one talk to Analysis Services. Though I have no PowerShell skills (I opened a PowerShell console 2-3 times) and I come from the Database Engine world - I thought that it would be interesting to try the powerSSAS provider for Analysis Services created by Darren Gosbell. So here's a screencast on this ...

Daca rulati pe 2005 poate nu este enabled xp_cmdshell. Verificati Surface Area Configuration.

or should I say Forever Young? If you try to troubleshoot AS connections like I had to, you will choose the second characterization for the Troubleshooting Analysis Services 2005 connectivity problems article.

LEAD Technologies Inc. V1.01

The answer depends on who you asked the question. If you ask an Analysis Services member team he/she might answer XML DDL, MDX (Multidimensional Expressions). DMX (as in Data Minining Extensions and not DMX the rapper), XMLA (XML for Analysis), PMML (Predictive Model Markup Language), OLE DB for OLAP (ODBO), ADOMD, ADOMD.NET, DSO, ...

At least it would not be supported though the API can be somewhere in the code. What is the execution plan? It was a feature of Analysis that resembles the actual execution plan from the Database Engine though it is not the same thing. What makes them similar (besides the name) is the final result, an XML that describes what happened. What makes ...

LEAD Technologies Inc. V1.01

LEAD Technologies Inc. V1.01

There's a small link on the top right corner of the site to the Heroes Happen Here :: SQL Server 2008 Test Drive If you didn't check it then you should. Why? You can play with an online installation of SQL Server 2008  without having to install your own, plus you can add some cool videos. Just have a look: You are looking at the Resource ...

SnagIT + WAITFOR :)