In this session, we will see what brings us some newly introduced MS SQL functions and syntax's like COMPRESS, STRING_SPLIT, STRING_AGG, DROP IF EXISTS (a.k.a. DIE), UTF8 Support, and many more. How are they performing compared to some old solutions? Accompanied by multiple examples, this session will show you many interesting topics.