| Session Title | Abstract | Watch Now |
|---|---|---|
| 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 |
SQL Server Education (by the geeks, for the geeks)