DPG Virtual Symposium – SQL Server 2019 & Azure SQL
SQL Server by Example by Bob Ward
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.
SQL Server 2019 Big Data Clusters: Make SQL Server your Data Hub for everything by Ben Weissman
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 Defined Functions – From SQL 2000 – SQL 2019 by Uwe Ricken
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.
Start modernizing your workloads at scale with Managed Instance by Dani Ljepava & Vladimir Ivanovic
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.

DataPlatformGeeks Virtual Symposium – SQL Server 2019 – Welcome Note By Amit Bansal

DataPlatformGeeks Virtual Symposium – SQL Server 2019 – Opening Note by Ruchi Tushir

SQL Server by Example by Bob Ward

SQL Server 2019 Intelligent Query Processing – Part 1 by Amit Bansal

SQL Server 2019 Big Data Clusters: Make SQL Server your Data Hub for everything by Ben Weissman

User Defined Functions – From SQL 2000 – SQL 2019 by Uwe Ricken

Start modernizing your workloads at scale with Managed Instance by Dani Ljepava & Vladimir Ivanovic

SQL Access to SaaS/Cloud Data through PolyBase by Jerod Johnson
DPG Virtual Symposium 2020 – Azure Analytics & Artificial Intelligence

Introduction to AI and Cognitive Services for Developers & Information Workers by Prashant G Bhoyar

Power BI Paginated Reports by Peter Myers

Creating A Photorealistic Avatar Using Generative Adversarial Networks by Sebastiano Galazzo

Self Service AI in Power BI Desktop by Markus Ehrenmueller Jensen

Discover Content Moderator by Stefano Tempesta

7 Things You Should Know About Azure Data Factory by Wee Hyong Tok

Distinct Count For Power BI by Philip Seamark

How does Azure Cosmos DB Work Under The Hood? by Hasan Savran