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
750 Town & Country Blvd., 10th Floor
My Favorite Free SQL Server Tools
Nancy Hidy Wilson, SQL Server Service Engineer T-Systems
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
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.