SQL Server has always had a number of anti-patterns that didn't make any sense to application developers. Why shouldn't I be able to use scalar function? Or why can't I put a large number of rows in a table variable? SQL Server 2019 and Azure SQL Database have eliminated a number of these anti-patterns. In this session you will learn about how these changes can improve your application performance, and change your application development patterns. You will also learn about potential gaps where your application may not benefit from the changes to the database engine.