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

***MEETING LOCATION ADDRESS***

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 October 31 before the registration rate jumps.

Use our Chapter Discount code: USSCS27 for an additional $150 off.

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
RSVPURL: None

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

When

iCal
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

Where

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

Direction: None

Featured Presentation

My Favorite Free SQL Server Tools

Speaker: Nancy Hidy Wilson, Chapter Leader Houston Area SQL Server User Group

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. More recently, Nancy presented “Managing SQL Server in the Enterprise with TLAs” at SQLSaturday #97 in Austin. Nancy has led the Houston Area SQL Server User Group (HASSUG) since 2001 and presents there as needed. She also lead the steering team for Houston’s SQLSaturday #57 in January 2011 and currently leads the steering team for SQLSaturday #107 in April 2012. Nancy’s focus for the past 17+ years has been on providing standardized installation, configuration, and management of SQL Server for the global enterprise environment. Nancy holds a Bachelor of Science in Computer Science from Baylor University.

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.

Attachments