Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Mid April Free Training from PASS VCs

By Aaron Nelson,

Building Applications That A DBA Will Love
All About Analysis Services

Building Applications That A DBA Will Love
April 12, 2011, 12 PM Eastern
Andy Warren
Attendee URL: LiveMeeting

It's natural for the focus to be on the end user when we build applications, but it's important and worthwhile to build into our design some things that make it easier for the DBA to provision, tune, and support the product we deliver. So what does a DBA care about? Performance of course, but also security, scalability, space usage, and yes, even documentation. This presentation will cover tips in a number of areas that address the concerns of the DBA, and we'll talk about why you should care about making the DBA happy too!

Andy Warren
Andy Warren is a SQL Server consultant and trainer who occasionally writes some code too. He's on the PASS Board of Directors, was a founding partner in, started the SQLSaturday event format, and is currently a SQL Server MVP. Andy blogs at, and can be reached via Twitter as @sqlandy and on LinkedIn at

How do I attend?
Attendee URL: LiveMeeting
Efficient and effective processing of OLAP CUBES with AMO and XMLA
Fri April 15th 12PM EST (US)
Speaker: Steve Simon

Topic Description:
Within the financial industry, rapid and effective decision making is critical to our client relationships. Analytical tools such as OLAP cubes help make this a reality. In many 24 X 7 enterprises, data capture and cube updates occur on an ongoing basis throughout the business day. We are able to achieve this through the innovative utilization of SQL Server Integration Services (SSIS). This intermediate level hands-on presentation will show the attendee how we have utilized Analysis Management Objects (AMO) commands and SSIS to 'fire' our OLAP CUBE updating processes. The presentation will discuss the high level concepts behind Analysis Management Objects (and the XMLA that is generated from the commands) and the scenarios under which we can benefit from their usage. Topics covered will be the updating of dimensions, measures, partitions, the cube and more.

Steve Simon
is an Assistant Vice President with State Street Corporation in Boston. He has been involved with database design and analysis for over 26 years. Steve has presented papers at eight North American PASS Summits (in Orlando, Seattle WA (4), Denver CO (2) and San Francisco CA), two at PASS Europe 2009 and one at PASS Europe 2010. He has just recently presented his PASS 2008 Summit presentation in Johannesburg South Africa. Steve is actively involved with the SQL Server community within the Boston area and is a regular presenter at the New England Code Camps and SQL Saturday events and participates actively on many of the Microsoft User Forums. He is also the Virtual Chapter leader of the Professional Association for SQL Server (PASS) Oracle - SQL Server Virtual Chapter and is a PASS regional mentor. He will also be presenting a data mining paper at SQL Teach in Montreal between May 31st , 2011 and June 3rd 2011.



Total article views: 938 | Views in the last 30 days: 1
Related Articles

Analysis About Dimensions

SQL Server Analysis Services includes the ability to capture information about every query run again...


Upcoming Webinar: Building Dynamic SSRS Reports with Analysis Services

Join me next week for a really fun presentation on building Dynamic SSRS reports using Analysis Se...


Analysis About Analysis Services

SQL Server is an amazing business intelligence platforum, including many tools that other vendors fo...


Building an Effective Data Warehouse Architecture Presentation

I will be presenting the session “Building an Effective Data Warehouse Architecture” today at 11am C...


Building an Effective Data Warehouse Architecture Presentation

I will be presenting the session “Building an Effective Data Warehouse Architecture” this Wednesday,...


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones