A number of people have spotted this announcement on the SQLCAT blog already:
http://sqlcat.com/sqlcat/b/technicalnotes/archive/2011/09/19/announcing-the-first-wave-of-ssas-maestros.aspx, but if you have not seen it yet, I’m very proud to say that I’ve been made an Analysis Services Maestro!

If you have not heard about the Maestro program you can find out more details about it here; as Chris has said, it’s basically something like an MCM for Analysis Services. The course itself was a fair bit of work and went into a lot of the Analysis Services internals, along with worksheets for the labs during the course we had to sit a written exam and submit a 5000 word case study.

Congratulations also go to the other ten awardees: Ulf, Alberto, Greg, Chris, Dirk, Mick, Vidas, Marco, Harlan and John. (Interestingly the 3 founding members of the BIDS Helper project are all in this first batch of Maestros)


# re: I'm an Analysis Services Maestro

Congrats Darren! :)
9/23/2011 4:39 PM | Jason Thomas

# re: I'm an Analysis Services Maestro

Congratulations, Darren!It is really great achievement but you deserve it for sure! 9/23/2011 9:13 PM | Laura

# re: I'm an Analysis Services Maestro

Congratulations Darren on being selected as one of the first and few SSAS Maestros in the world.

Its about time and certainly well deserved. 9/24/2011 1:30 AM | Naveen Das

# re: I'm an Analysis Services Maestro

You rock Daz! 9/26/2011 9:09 AM | Belinda Toniolo

# re: I'm an Analysis Services Maestro

I am try to find out a way to programmatically (using Transact SQL or C#) change the datasource of an excel file linked to powerpivot from one SQL Server connection to another and automatically refresh all the data using this new connection without having to do this manually using the interface. I was wondering if this can be done. 9/30/2011 6:57 AM | Lalit

# re: I'm an Analysis Services Maestro

@Lalit - there is not currently anyway of doing this in Powerpivot. There is a hack someone posted for doing a refresh, but it's unsupported and could corrupt your workbook. However there is no API at all for changing the data source for a Powerpivot model at the moment (we have been asking the product team to add this).

You could possibly do something outside Powerpivot by using a DNS alias, a SQL alias or an entry in your Hosts file to redirect a connection from one server to another. 9/30/2011 8:45 AM | Darren Gosbell

Post a comment




About Me
I am a consultant, based in Melbourne Australia. I primarily work in the Business Intelligence area with SQL Server, although I also dabble in Content Management Server and .Net coding

Contact Me


Any and all code, software, examples, suggestions and anything else on this web site is available for you to use at your own risk. No warranty is expressed or implied.
Views and Opinions
The views and opinions expressed on this web site are not necessarily the views or opinions of my employer.

Subscribe in Bloglines Subscribe in NewsGator Online

Locations of visitors to this page


Tag Cloud

Article Categories


Post Categories

.Net Blogs

Aussie Bloggers

BI Blogs

CMS Blogs