Performance was a topic that grabbed my interest as a new engineer at Microsoft, and it remains my primary focus now. Most performance issues issues can be resolved by understanding how indexes work, knowing how to configure a server, and writing good queries. The ability to gather data from SQL Server is also key; we need to be able to identify the root cause of our problems as soon as possible.
SQL Server 2019 has added new capabilities we should all be familiar with. There are improvements in performance from memory grant feedback, delayed compilation for table variables, and TempDB contention reduction. There are also new in-memory options, and new platform choices including Azure SQL Database Edge. This is a great time to invest in updating your knowledge of SQL Server.