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, but since they will be moving in November we will be meeting at:


750 Town & Country Blvd
10th Floor
Houston, TX 77024


Note: There is a parking garage attached to the bulding 


Follow us on Twitter - @HASSUG, #HASSUG


Upcoming Events:


Next Meeting: Tue, May 14 2013

HASSUG & H-BI Monthly Meeting - May 14, 2013

Language: English
Event Type: In-Person & Online
Online Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=HASSUG_MAY2013&role=attend

The general schedule for each meeting will be:

11:30-11:40 – Announcements
11:40-12:45 – General presentation (Topic 1)
12:45-1:15 – Lunch\Networking – Raffle #1
1:15-2:20 – BI themed presentation (Topic 2)
2:20-2:30 – Recap Announcements – Raffle #2


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


750 Town & Country Blcd
Houston, Texas

Direction: None

Featured Presentation

My Favorite Free SQL Server Tools

Speaker: Nancy Hidy Wilson, SQL Server Service Engineer T-Systems

Summary: We’ve all been there – an activity to do and we know we’ll need to do it again. We also know we probably are not the first DBA to need to do that particular task – surely someone else has already figured it out, scripted it and shared it. But, how do you know that script you found on the internet is reliable? Especially if you are new to SQL Server and don’t know whom to trust. I’ll share several reliable sources and the free stuff that all DBAs should have in their toolbox.

About Nancy Hidy: Nancy Hidy Wilson has been working with Microsoft SQL Server since 1994. She originally volunteered for PASS at the first Community Summit held in Chicago in 1999 and has served on various PASS Committees since that time. Nancy was a PASS Community Summit speaker from 2000-2007. Nancy led the Houston Area SQL Server User Group (HASSUG) from 2001-15 and presents there and at SQLSaturday events. She also currently volunteers as an editor for the SQL Server Benchmarks with CIS.

Achieve “near-real time” in OLAP with Dynamic Cube Partitioning

Speaker: Rich Ancy, Consultant Pariveda Solutions

Summary: Developers of large OLAP cubes generally run into two issues as the data set increases: Timeliness of cube refreshes diminishes and decreased query performance. The method of processing a cube is inherently a batch process and was not designed to handle near real-time updates while still storing all the data in MOLAP mode. Typically developers will schedule their cube and dimension refreshes for a time after business hours; perhaps when all the data for the data has been loading. However, developers tasked with building a global solution, with no apparent cube refresh window, would be forced to refresh the cube multiple times per day. Please join us to learn how to use dynamic cube partitioning and parameters to deliver the slice-and-dice multidimensional analysis capabilities of OLAP while also delivering the near-time data latency that can traditionally only be achieved via direct SQL reporting.

About Rich: Rich Ancy is a consultant at Pariveda Solutions and alumnus of the University of Texas at Austin. While at Pariveda, Rich has designed and implemented data solutions for a variety of clients. Additionally, Rich has developed custom applications on .NET and on top of the Microsoft Dynamics CRM platform for his clients.