Event Calendar

Loading Events

« All Events

  • This event has passed.

MS SQL Server 2016 OLAP Performance Practices

April 11 @ 6:00 pm

With MS SQL Server 2016, a variety of optimization techniques are available due to enhancements made towards indexes and memory optimized tables.  Because of these enhancements, many options exist for differing types of OLAP analysis.  In addition, these same optimizations can assist with storage constraints associated with on-premise and cloud solutions.

In this session, we will discuss these optimizations in more detail.  We will also compare different approaches to loading and analyzing data.  These approaches will be similar to practices maintained in both MS SQL Server 2012 and MS SQL Server 2016.

The topics will include:

• A brief primer on MS SQL Server indexes

• The versioning history of columnstore indexes

• Review table loading results via Power BI

• Review adhoc performance

• Review table space utilization

 

Presenter: Scott Fountain

 

I have been in Charlotte since 2010 and my focus involves data warehouse automation and business intelligence.  I have developed solutions for manufacturing, education, agriculture, and finance.  My other responsibilities include training entry-level developers and prepping developers for certification exams.  My current workload involves cloud development and better understanding Hadoop administration.

When not on my laptop, you can find my wife and I enjoying the sunshine.

Details

Date:
April 11
Time:
6:00 pm
Event Category:
Website:
https://www.meetup.com/ModernDevsCLT/events/238301743/

Organizer

Modern Devs CLT

Venue

Time Warner Cable
7800 Crescent Executive Dr
Charlotte, NC United States
+ Google Map

Daimler and Bosch create a driverless parking garage https://t.co/oXL8YnSzGm

Copyright © 2017 Logical Advantage. All Rights Reserved