This website is home to the tsql User Group, a group where you can discuss new and old versions of SQL Server, ask for help on the project, discuss design, complain about bugs, investigate technology, share vision, review tools, or even look for jobs or contracts.

Exploring SSAS database data folder

Date: June 15th, 2011 @ 18:15
Location:    Hyatt Regency 370 King Street West
The offices are reached via a bank of elevators on the main floor to the West of reception (right near the Starbucks). After 6 p.m. one needs a key card to use them so Alan will be shuttling people up to the sixth floor.

To join: Toronto SQL Server User Group send email to: tsql-subscribe@yahoogroups.ca

To register: You do not need to register for the event.

Food: Pizza will be served

Exploring SSAS data folder – by Vidas Matelis

In this presentation you will review how SSAS stores MOLAP data in database folder. We will review database folder structure and different file types that are created by SSAS.  Then we will use that information to review how to:

1. Identify time when cube/measure group/dimension was processed
2. Calculate size of the cube/measure group/partition/dimension and attribute
3. Calculate size of the indexes, aggregations and size of data in cubes and dimensions
4. How to identify if your aggregations and indexes where dropped after updating attribute value in flexible relationship.
5. How to identify if partition that does not have slicer specified contains just data that you were expecting to be there.

BIO – Vidas Matelis

Vidas Matelis is Business Intelligence Consultant who specializes in building data warehouse solutions using Microsoft technologies (SQL Server, SSAS, SSIS and PowerPivot). He has more than 12 years of experience in this area. He maintains popular websites http://ssas-info.com and http://powerpivot-info.com. His blog can be found here: http://www.ssas-info.com/VidasMatelisBlog/. He is Microsoft SQL Server MVP.

Meeting Notifications

To be notified of upcoming TSSUG events, you can join our tsql email list by on YahooGroups.ca. Simple send an email to tsql-subscribe (at) yahoogroups.ca and follow instructions that you will receive in the email. You will require a Yahoo! id (but not email from Yahoo) to join the list.

We recently had a debate about communication platform. We could not really make consensus, so we have created twitter, facebook and linkedin accounts and linked them together.
When we post to twitter, other two will get it.

Twitter: tsqlca
Facebook: tsql ca
Linkedin: User Group, Toronto SQL
Email: tsql.ca@gmail.com

 Site Migration

We are in the process of switching hosts to PASS.  This will allow us to better manage the site without having to deal the maintenance of servers.  Well, hopefully. :)