SQLServerGeeks Virtual Symposium – SQL Server 2019 & Azure SQL – May 2020 – Recordings

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