CISL (https://github.com/NikoNeugebauer/CISL) is a free and open source Columnstore Indexes Scripts Library that allows any user to get advanced insights over the Columnstore Indexes. With the help of CISL you can discover what are the tables that you should consider converting to Columnstore Indexes, what are the difficulties that prevent you from doing it in a matter of couple of clicks. Supporting all Microsoft implementations of Columnstore Indexes (SQL 2012-2016, Azure SQL, Azure SQL DataWarehouse, APS/PDW - the CILS will allow to use stored procedures without knowing exact DMVs. Learn how to use Columnstore Indexes maintenance solution in CISL for keeping your Columnstore performance at the maximum speed. The maintenance solution will do all the necessary things for you while providing a way the way you want it to operate.
Niko Neugebauer works at OH22 as a BI Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about Data Platform and Community.
Founder of the Portuguese SQL Server User Group, the main organiser of the first SQLSaturday outside of North America – #78 Portugal, Niko presented at a lot of events such as PASS Summit, SQLRally, SQLBits, SQLSaturdays around the world.
He loves sharing and is an author of blog series with 80+ posts on the Columnstore Indexes, plus the free & open-sourced CISL library helping to work with Columnstore Indexes.