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.