DPG Virtual Symposium – SQL Server 2019 & Azure SQL
Sometimes there is no better way than to learn by example. In this session, you will learn key capabilities of SQL Server and Azure SQL by seeing demonstrations. This session is all about fewer slides and more demos! This session will show you demonstrations on topics such as containers, Kubernetes, performance, availability, and data virtualization. Additionally, you will walk away with all the resources you need to try out everything you see on your own time.
In the realm of data storage and processing, there are two major technologies which we deal with every day. On one side, we have relational data that is stored inside SQL Server, and on the other side, non-relational or very large datasets that do not fit the relational model which are stored on big data clusters like Hadoop or Spark. This introduces challenges when having to combine datasets across both these technologies. SQL Server was never built to process huge datasets in a distributed fashion or to handle non-relational data very well, meaning that in many cases you would have to resort to bringing your relational data into Hadoop or Spark clusters. SQL Server 2019 has the answer with Big Data Clusters: it combines SQL Server with HDFS and Spark! In this session we are going to explore the capabilities of the exciting new feature. How does it work and how can we work with datasets that are non-relational?
User Definied Functions (UDF) came first with SQL Server 2000. While developers welcomed the introduction of features, they became a DAB nightmare. This session start with the very basics of User Definied Functions (SCALAR, MULTI-LINE, INLINE) and shows the problems of functions when they gets used in queries. SQL Server 2019 came with lots of improvements have been made to speed up queries which are using UDF. The second part of the session treat the great improvements of execution of functions and show ways to reach new records in the execution of your queries with UDF.
SQL Managed Instance is the latest fully managed deployment option in Azure SQL Database that enables frictionless migration and easy modernization in the cloud for SQL Server applications running on-premises. Managed Instances offer close to 100% compatibility with the latest SQL Server, native virtual network (VNet) integration that addresses common security concerns of enterprise customers, and full set of PaaS capabilities enabling easy app modernization after migration to cloud. Come and learn why Managed Instance is the best PaaS destination for all SQL Server workloads and how to start your cloud modernization at scale now, using Azure SQL Database Managed Instances.