Session TitleAbstractWatch Now
Start Modernizing your workloads at scale with Managed Instance by Danimir Ljepava & Vladimir IvanovicSQL 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. Watch Now
10 Reasons why Azure SQL is the best Database for Developers by Davide MauriTo steal a quote from Python that perfectly applies here, Azure SQL is “batteries included.” It’s got everything you need. Lots of things have changed from when SQL Server was released to the market decades ago, and even more from when Azure SQL was made available in the cloud. In this session we'll see what Azure SQL offers to the modern developer and how each of the following features can help in reducing application complexity and increasing development efficiency. Along with relational features, an amazing number of post-relational features like JSON and Graph support, columnar storage and in-memory lock-free structures are available to developers to leave to the database the burden to efficiently manipulate and crunch data, so that they can focus on design architectures, implementing the business logic in the most clean and elegant way possible. Having all such features all available for one scalable database is unique in the market. Come learn how to take advantage of everything Azure SQL can offer to a developer Watch Now
Availability Groups Clustering without WSFC or Pacemaker – from Premises to Cloud by Connor CoxIn this session, you will learn how to use one simple tool from DH2i to easily deploy highly available SQL Server Availability Groups—across Windows and Linux—between on-premises and cloud environments Watch Now
Azure SQL: What to use when by Anna HoffmanIn this session, you'll learn from a member of the Microsoft Product Group the different options for your SQL deployments in Azure. After this session, you should be able to: Articulate the key differentiators between SQL Server on-prem, in an Azure VM, in Azure SQL DB (Single database, Elastic Pools, and Managed instance) Explain the different service tiers within Azure SQL DB/MI, and evaluate what is best for your workloads and business requirements (Serverless, Hyperscale, General Purpose, Business Critical, etc) Watch Now
DataPlatformGeeks Virtual Symposium - SQL Server 2019 - Opening Note by Ruchi Tushir Watch Now
Deploying SQL Server in Kubernetes by Anthony NocentinoAre you thinking about running SQL Server in Kubernetes and don’t know where to start…are you wondering what you really need to know? If so, then this is the session for you! When deploying SQL Server In Kubernetes key considerations include data persistency, Pod configuration, resource management, and high availability/disaster recovery scenarios. In this session, we’ll look closely at each of these elements and learn how to run SQL Server in Kubernetes. Watch Now
Design your backend APIs with Azure SQL Database and GraphQL by Silvano CorianiGraphQL is getting significant traction as an alternative to traditional REST APIs in developing flexible and efficient solution backends, thanks to the natural approach in expressing the shape and form of the data needed by your consuming layers. In this session we will show how to implement a GraphQL API accessing Azure SQL Database instances through familiar data access libraries and ORMs like Entity Framework Core. Watch Now
Fixing SQL Server Databases Corruption by Amit ShuklaDuring this Session we will discuss about most common corruption issues in SQL databases, and how to fix these corruption issues. Watch Now
SQL Access to SaaS/Cloud Data through PolyBase by Jerod Johnson Watch Now
SQL Server 2019 Big Data Clusters: Make SQL Server your Data Hub for everything by Ben WeissmanIn 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? Watch Now
SQL Server 2019 Intelligent Query Processing – Part 2 by Satya Ramesh Watch Now
SQL Server 2019 Intelligent Query Processing – Part 1 by Amit Bansal Watch Now
SQL Server by Example by Bob WardSometimes 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. Watch Now
SQL Server Ground to Cloud by Buck WoodyIn this session you'll learn topics ranging from the newest technical features in SQL Server to its implementation in all the platforms it runs on. You'll learn not only specific technologies, but how to assemble them into a complete solution based on customer needs and requests. We'll explain the latest improvements in SQL Server, how to work with the Big Data Clusters feature, and then learn about the ways you can leverage SQL in Microsoft Azure - all with a focus on how to extrapolate what you have learned to create other solutions for your organization. You'll also get an introduction to "What to Use When" - explaining how to create your own solutions. Watch Now
SQL Titbits for the Inexperienced by Erland SommarskogThis session is directed to you who have been using SQL left-handedly a year or so. You have learnt to write the basic queries, but there are still some gaps in your SQL knowledge, and overall SQL is a little confusing to you. This session aims at filling some of these gaps by covering a few titbits about SQL and give you some tips that will be useful to you. This includes really basic things as what GO really is and the traps you can run into with NULL values. You will also learn a little about data types and how you should use UNION. Finally, I will talk about CTEs, temp tables and table variables and you will get some ideas what to use when. Watch Now
Top 5 Query Tuning Tricks by Amit Bansal Watch Now
User Defined Functions – From SQL 2000 – SQL 2019 by Uwe RickenUser 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. Watch Now
Low RTO Restores – A Revolutionary Approach by Mike Salins Watch Now
Metadata Management: The Hero in Unleashing Enterprise Data’s Value by Arun Nagalingam Watch Now
Persistent Memory and Hybrid Buffer Pool – The good, bad and ugly by Thomas GrohserSQL Server 2019 has a new feature called Hybrid Buffer Pool. The ability of placing database files into "Memory" that does not lose its content in case of a power outage. This session will explore how this feature evolved from previous features and when it makes sense to use this feature and when not to use it. Watch Now
Real Life Machine Learning projects advanced linear regression considerations by Damian WideraI would like to show you the concept of linear regression in real life implementation. The algorithm is simple but has more advanced concepts like Lasso and Ridge regularization, model selection and R squared adjusted. This is easy to understand because I will gently introduce the math that is behind this so the algorithm will never be a mystery for you!You will be able to implement the algorithm right away after the meeting! Watch Now
Art of Feature Engineering For Machine Learning by Sandip PaniThe most challenging area of machine learning are Data acquisition, Feature extraction, Feature Selection.Almost in all data science project, 80% of time people spend in Data acquisition and Feature engineering.There is no silver bullet to do feature engineering, We have several tools and we will how to use them in this session. Watch Now
Getting Started with Azure Synapse Analytics by Warner ChavesWhat started as Azure SQL Data Warehouse, has now evolved into an all-encompassing analytics development service. Microsoft took the power of the MPP database engine of SQL DW and added more powerful capabilities, full big data integration as well as an integrated authoring experience. Watch Now
Building Analytics Solutions Faster with Azure Synapse Analytics by Saveen ReddyMany Analytics POCs fail simply due to the complexity of even basic tasks. Now as enterprises move from traditional data warehousing to incorporating big data the challenges have multiplied. This session will should how Azure Synapse bridges the world of data warehousing and big data into a unified whole and how that accelerates time-to-insight in practical terms. Watch Now
Azure Digital Twins in a Nutshell by Mihail MateevDigital twins make it possible to simulate, analyze and test scenarios digitally, before implementing changes in the real world.There are already huge advantages in being able to digitally monitor and control physical objects near or far and at any time. It also possible to explore and experiment further on these objects by building virtual models of them.Digital twins allow engineers to work with objects in ways that would be impossible in the real world. Nowadays, Microsoft Azure offers this capability on its Internet of Things (IoT) platform with Azure Digital Twins. This technology enable spaces and individual devices to be modelled and let users develop scalable, reusable structures that can combine digital and physical data.This presentation is about Azure Digital Twins: the main business benefits and technical advantages. Presentation demonstrate the key features of technology the context of Microsoft Azure with real use cases and live demos. Watch Now
How does Azure Cosmos DB work under the hood by Hasan SavranIf you are interested in learning more about Spatial Data but don’t know where to start, this session is for you. We will begin by focusing on what Spatial Data is through examples and interactive demo’s. The goal is to show how Spatial Data can improve your professional experience and serve as an asset to your business.I will introduce you to Spatial Data in the SQL server and show how to import data into SQL Server. We will focus on demonstrations of the SQL Server 2016 and JSON functions used to create geoJSON objects from Spatial Data. Next we will cache these objects by using In-Memory tables with the help of SQL Server 2017. Please join me as we explore how to use SQL server to handle your Geospatial data needs. Watch Now
Distinct Count for Power BI by Philip SeamarkReport measures that use distinct count can often be the slowest metric in any BI tool. This session will explain why this is the case and walk through a series of way to speed up these calculations in Power BI. Watch Now
Power BI Paginated Reports by Peter MyersPower BI paginated reports are optimized for printing, or PDF generation. They provide you with an ability to produce highly formatted, pixel-perfect layouts. Watch Now
7 Things you should know about Azure Data Factory by Wee-Hyong TokAzure Data Factory, a service built for all data integration needs and skill levels. Using Azure Data Factory, you can easily construct ETL and ELT processes code-free within the intuitive visual environment, or write your own code. Azure Data Factory enables you to integrate data sources using more than 90+ natively built and maintenance-free connectors, and ingest and transform data using at scale. With Azure Data Factory, you focus on your data and how you want to ingest and transform the data. The serverless integration service does all the magic for you to scale, transform the data, get your data to where it is needed for business insights and more! In this session, Shirley and Wee Hyong will share with you the top 7 things that you should know about Azure Data Factory to get started, and how you can use it in your organizations for all your data integrations needs. Watch Now
Discover Content Moderator by Stefano TempestaContent Moderator is a machine-assisted content moderation service and human review tool for images, text and videos. With Content Moderator you can detect potential offensive images, filter possible profanity and moderate adult and racy content in videos. Content Moderator also checks for personally identifiable information (PII).This session shows how to moderate content uploaded in your web site, filter out unwanted images through machine-learning based classifiers, custom lists and optical character recognition, and how to detect undesirable text in a variety of languages. Watch Now
Self-Service AI in Power BI Desktop by Markus Ehrenmueller-JensenAI is everywhere – and now even included in Power BI Desktop. Sometimes AI might be very apparent when you enrich your data with predictions by explicitly calling an Azure Machine Learning web service in Power Query. Sometimes it might be hidden in a nice little context menu when Power BI is automagically explaining the reason of a difference or a change over time in your data to you. Watch Now
Creating a photorealistic avatar using generative adversarial networks by Sebastiano GalazzoHaving an overview on how getting started with Microsoft Azure Machine Learning Studio we will start understanding generative deep learning algorithms.Focusing on autoencoders, will be journey from the biginning (Of the speaker experience), mistakes and tips learned along the path showcasing several convolution flows. Watch Now
Introduction to AI and Cognitive Services for Developers and Information Workers by Prashant G BhoyarArtificial Intelligence and Machine Learning are the new buzzwords in the industry. Microsoft's vision is to make AI accessible to every enterprise, data scientist, developer, information worker, consumer and device everywhere in the world. AI has a big role to play in the enterprise space. The field of AI is progressing at a rapid pace. Without understanding the concepts behind these advanced technologies, developers and administrators will struggle to evaluate the potential impact of new tools and solutions. In this session, we will break down the concepts behind existing technologies, outline various tools available today, and discuss the direction of AI and ML for Developers. We will cover how developers, Power Users, and Information workers can take advantages of the Microsoft's AI and Cognitive Services offerings to build real-life enterprise solutions. Watch Now