I'm an Analysis Services Maestro

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)

Print | posted on Friday, September 23, 2011 12:05 PM

Comments on this post

# re: I'm an Analysis Services Maestro

Requesting Gravatar...
Congrats Darren! :)
Left by Jason Thomas on Sep 23, 2011 4:39 PM

# re: I'm an Analysis Services Maestro

Requesting Gravatar...
Congratulations, Darren!It is really great achievement but you deserve it for sure!
Left by Laura on Sep 23, 2011 9:13 PM

# re: I'm an Analysis Services Maestro

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

Its about time and certainly well deserved.
Left by Naveen Das on Sep 24, 2011 1:30 AM

# re: I'm an Analysis Services Maestro

Requesting Gravatar...
You rock Daz!
Left by Belinda Toniolo on Sep 26, 2011 9:09 AM

# re: I'm an Analysis Services Maestro

Requesting Gravatar...
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.
Left by Lalit on Sep 30, 2011 6:57 AM

# re: I'm an Analysis Services Maestro

Requesting Gravatar...
@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.
Left by Darren Gosbell on Sep 30, 2011 8:45 AM

Your comment:

 (will show your gravatar)