One of the primary components of Azure Synapse Analytics is the Synapse SQL Pool which is the back-end SQL data store that is used to host your traditional data warehouse. When you first connect through SQL querying tools, it has the look and feel of a familiar SQL database. However, after further investigation you quickly begin to realize there are quite a few differences. For the those experienced with SQL Server this can take some time to adapt since since many of the tools, techniques, or scripts you have grown accustomed to just do not work. In this session, I want to take what you already know and love about traditional SQL Server and compare it to what Synapse SQL Pool offers to assist in your transition. I will walk you through several of the differences and show you what I wish I knew when I started using SQL Pools. We will look at the unique way architecture and use-cases play a role in defining some of these differences and then go into the details of how T-SQL, security, performance tuning, and monitoring vary from what you may be used to. By the end of this session, you will understand key differences and be ready to get started using Synapse SQL Pools immediately.