Summary

SQL Server 2016 and SQL Server 2017 are packed with useful features, from JSON, PolyBase, to high performance features, such as the ColumnStore index and memory-optimized tables. Most of these features are compatible and can enhance your advanced analytics experience. In this chapter, you have learned the steps for creating forecast and seasonal trends of EMS incidents in Austin and Travis County. We used both JSON data source and CSV files in Azure Blob Storage. Finally, you also have learned how to make use of ColumnStore and memory-optimized tables to improve performance of R Services.