Triad SQL Business Intelligence User Group

Welcome

The Triad SQL Business Intelligence Users Group is a forum where any one interested in the Microsoft business intelligence stack can meet to learn more about the product, share ideas and make contact with other similar individuals. Our group is run by Microsoft BI professionals for the benefit of anyone interested in participating in the group.

All of our meetings are free and open to anyone who is interested in sharing their knowledge of SQL Server. Our meetings are generally held on the last Tuesday of every month, unless otherwise noted. Pizza and drinks are provided.

Please register on this site to be included on the latest newsletter and emails announcing our next meetings.


Next Meeting: Tue, Apr 26 2016

Triad PASS BI - April 2016 Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: http://www.meetup.com/Triad-SQL-Server-BI-User-Group/events/230228948/

Come join us April 26th to learn about some of the improvements with Columnstore indexes under SQL Server 2016 and how they might improve performance for your fact and dimension tables in your data warehouse.

 

When

iCal
UTC : Tue, Apr 26 2016 22:00 - 00:00
Event Time : Tue, Apr 26 2016 18:00 - 20:00 Eastern Daylight Time
Your Local Time: Tue, Apr 26 2016 22:00 - 00:00

Where

Inmar Building
635 Vine St.
Winston-Salem, North Carolina

Direction: None

Featured Presentation

Winning with Column Store: A Customer Story

Speaker: Rick Heiges, Principal Solutions Architect DB Best Technologies LLC

Summary: This session will feature a real story of a customer who was running into performance and scaling issues on a big iron Oracle RAC system and why they decided to consider the magic of the Column Store for this situation. Discussion will focus on the existing environments for testing both SQL 2016 and Oracle as well as the methodologies used for testing. We will examine the decisions made for choosing indexes (both traditional and column store) for the main tables in the data warehouse as well as the partitioning strategies employed. We will wrap up the discussion with the results of the testing and where they are now.

About Rick: Rick is a Data Platfrom MVP (2007-2017) and Principal Solutions Architect for DB Best where he focuses on working with customers on their data estate. His career includes work as a DBA, University full-time faculty member, Systems Analyst, Project Leader, and Developer. He has found his passion in working with data and the community. Rick served nine years on the PASS Board of Directors and spearheaded the popular 24 Hours of PASS event. He also started his local User Group in 2002. Today, he spends much of his time with his head in the clouds.

Attachments

Please visit our sponsors at:
 
 



 

 

 

Contact Us:

Triadsqlbi@Gmail.com

 
 
 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids