Welcome to the Houston Area SQL Server Users Group

HASSUG and Houston BI User Group will continue meetings on the second Tuesday of every month during an expanded "lunch" time.  The joint group meets at the Microsoft Houston Office. Our normal room is Suite #350 Discovery, but check the visual display when you arrive to confirm.

The general schedule for each meeting will be:

11:30-11:40 – Announcements

11:40-12:40 – General presentation (Topic 1)

12:40-1:00 – Lunch\Networking – Raffle #1

1:00-2:00 – BI themed presentation (Topic 2)

2:00-2:30 – Recap Announcements – Raffle #2; Networking


One Briar Lake Plaza

2000 W. Sam Houston Pkwy. S. #350

Houston, TX 77042 


Follow us on Twitter - @HASSUG, #HASSUG


Going to PASS Summit 2014 in Seattle, Nov. 4-7? Register by June 27 before the registration rate jumps.

Use our Chapter Discount code: USSCS27 for an additional $150 off and help our chapter earn referral funds.

Next Meeting: Tue, Oct 14 2014

HASSUG & H-BI Monthly Meeting - October 14, 2014

Language: English
Event Type: In-Person
Online Meeting URL: None

The schedule for this meeting will be:

11:30-11:40 – Announcements
11:40-12:40 – SQL Bytes - By HASSUG Members
12:40-1:00 – Lunch (Sponsored by Pariveda Solutions)
1:00-2:00 – Implementing a data-driven security modelin SSAS – Evan Hein & Mike Duffy
2:00-2:30 – Recap Announcements & Networking


UTC : Tue, Oct 14 2014 16:30 - 19:30
Event Time : Tue, Oct 14 2014 11:30 - 14:30 Central Daylight Time
Your Local Time: Tue, Oct 14 2014 16:30 - 19:30


2000 W. Sam Houston Pkwy S. #350
Houston, Texas

Direction: None

Featured Presentation

SQL Bytes


Summary: Short topics presented by various HASSUG members. First-come, first-present as time permits. Please keep topics under 10 minutes.

About HASSUG: None

Implementing a data-driven security model in SSAS

Speaker: Evan Hein Pariveda Solutions

Summary: The "additive" design of SSAS role security can present some unexpected challenges when trying to implement a data-driven security model based on multiple dimensions. This may be a relatively common use case in enterprise scenarios, such as the case where a sales rep is restricted to only see data in his primary region or in regions in which he has sold products. In this talk, we will introduce two potential solutions to this problem: the “Monolithic Security Dimension”, and the custom role assembly.

About Evan: Evan is an Associate at Pariveda Solutions with experience across the Microsoft stack from .NET application development on the desktop, the web, and mobile devices to enterprise solutions using SQL Server and SharePoint.