Next Meeting: Tue, May 14 2013
HASSUG & H-BI Monthly Meeting - May 14, 2013
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
2000 W. Sam Houston Pkwy S. #350
My Favorite Free SQL Server Tools
Nancy Hidy Wilson, Chapter Leader Houston Area SQL Server User Group
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
Rich Ancy, Consultant Pariveda Solutions
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.
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.