HASSUG and Houston BI User Group will continue meetings on the second Tuesday of every month during an expanded "lunch" time. 

*** MEETING LOCATION ADDRESS ***

Microsoft

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

 

Note: There is a parking garage attached to the building, but  for free parking, park in the garage on the North side of Queensbury Lane.

 

Upcoming Events:

SQLSaturday #514 - Houston - May 14, 2016

 

PASS Summit 2016 in Seattle - October 26 to 28, 2016


Be sure to use our chapter discount code: LC15RBS6

And the price goes up in April 18th!


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

750 Town & Country Blvd., 10th Floor
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.

Attachments

Welcome to the Houston Area SQL Server Users Group