Start Modernizing your workloads at scale with Managed Instance by Danimir 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. | Watch Now |
10 Reasons why Azure SQL is the best Database for Developers by Davide Mauri | To steal a quote from Python that perfectly applies here, Azure SQL is batteries included. Its 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 Cox | In this session, you will learn how to use one simple tool from DH2i to easily deploy highly available SQL Server Availability Groupsacross Windows and Linuxbetween on-premises and cloud environments | Watch Now |
Azure SQL: What to use when by Anna Hoffman | In 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 Nocentino | Are you thinking about running SQL Server in Kubernetes and dont 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, well 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 Coriani | GraphQL 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 Shukla | During 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 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? | 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 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. | Watch Now |
SQL Server Ground to Cloud by Buck Woody | In 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 Sommarskog | This 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 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. | Watch Now |
Low RTO Restores A Revolutionary Approach by Mike Salins | | Watch Now |
Metadata Management: The Hero in Unleashing Enterprise Datas Value by Arun Nagalingam | | Watch Now |
Persistent Memory and Hybrid Buffer Pool The good, bad and ugly by Thomas Grohser | SQL 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 Widera | I 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 Pani | The 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 Chaves | What 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 Reddy | Many 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 Mateev | Digital 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 Savran | If you are interested in learning more about Spatial Data but dont know where to start, this session is for you. We will begin by focusing on what Spatial Data is through examples and interactive demos. 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 Seamark | Report 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 Myers | Power 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 Tok | Azure 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 Tempesta | Content 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-Jensen | AI 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 Galazzo | Having 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 Bhoyar | Artificial 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 |