Columnstore Indexes in 2017-2019

Overview

Explore recent enhancements to Columnstore Indexes in SQL Server 2017-2019, focusing on performance improvements for Data Warehouses and BI solutions. Learn about new features and fixes for high-scale environments.

Syllabus

• Introduction to Columnstore Indexes
Overview of Columnstore technology
Benefits of using Columnstore Indexes in SQL Server
• Enhancements in SQL Server 2017
Adaptive Query Processing
Batch Mode Execution Improvements
Automated Columnstore Index Maintenance
• Enhancements in SQL Server 2019
Scalar UDF Inlining
Intelligent Query Processing enhancements
Data Virtualization support
• Performance Improvements for Data Warehouses
Real-world scenarios and performance benchmarks
Optimization techniques for large-scale data warehouses
Hybrid Transactional/Analytical Processing (HTAP)
• New Features for Business Intelligence Solutions
Columnstore Indexes in Power BI and other BI tools
Improvements in analytical query processing
Scaling BI solutions with Columnstore Indexes
• High-Scale Environment Considerations
Best practices for high-scale data solutions
Monitoring and troubleshooting Columnstore Index performance
Case studies and practical examples
• Advanced Features and Fixes
Handling large data volumes efficiently
Use of Incremental Statistics
System and user feedback improvements
• Conclusion and Future Developments
Summary of key takeaways
Possible future trends and developments in Columnstore technology
Resources for further learning and exploration
• Hands-on Labs and Assignments
Creating and optimizing Columnstore Indexes
Performance tuning exercises
Real-world data scenarios with SQL Server 2017-2019
• Q&A and Troubleshooting Session
Open forum for questions and troubleshooting specific issues
Review and discussion of participant challenges and solutions

Subjects

Conference Talks