Join Rob and Ben for a fun filled hour from the community for the community as they invite a concatenation of community experts on stage and let them show us what their favorite data platform feature is and why!
The video is not available to view online.
. In this session, we will discuss some of the new capabilities introduced to get the most out of your databases, like Configurable Retry Logic to make your applications more resilient out-of-the-box, or various security-related improvements that have been added. We’ll also discuss new specific capabilities, like support for Azure SQL temporal tables in EF 6 and all the performance improvements that have been introduced.
The video is not available to view online.
In just 20 minutes We are going to entertain you with 10 cool things about Azure SQL Managed Instance that you might not know, but that can be extremely useful
Learn how to design for speed, concurrency, and correctness and avoid common database development pitfalls.
Some types of data are a very bad fit for a database. Join me to see how to survive with a database full of data that should not be stored there. I will demonstrate how to deal with billions of rows of logs without trashing the database, how to store millions of pictures effectively and how to deal with dynamic attributes in a sensible way.
Come get your questions answered live on stage by members of the Microsoft engineering team. This will be a fun and interactive session hosted by Bob Ward. We will take questions live from the audience plus those who are connected virtually.
A short intro to Lambda Architectures - what they mean, what they are, and how you can use them in your solutions
The video is not available to view online.
In this 100% demo session, I will show you kql magic, kql kernel, and the recently released Azure Monitor Logs extension for Azure Data Studio to consume event logs of the Azure SQL database.
Understand the automatic performance changes in Azure SQL and SQL Server
In this session, you'll learn how to deploy Azure Arc-enabled data services, connect, perform point-in-time restores, use the high availability features, and monitor the services.
The video is not available to view online.
In this session we will introduce Azure Container Apps and understand how it can be used as a simple and cost-effective way to host applications in Azure
Welcome to Azure DevOps trio, a tale about how a development team and an operations team have to bond together and start using Azure DevOps for Data Platform deployments.
The video is not available to view online.
Azure SQL DB and SQL Server introduced ground-breaking query performance enhancements under the Intelligent Query Processing family in the past few years. These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale, while remaining adaptive to the constantly changing world of data! Now join us to find about what's coming next in this new intelligent database world with SQL Serevr 2022 and Azure SQL!
The video is not available to view online.
In this session we will give you an overview of Azure SQL availability and resiliency capabilities. You'll receive a deep dive on architectures, configurations, and our industry leading SLAs which will help you get the right level of availability and resilience your databases need.
The video is not available to view online.
You will be challenged with a case study to design a solution using Azure SQL Database capabilities. At the end of this session, you will better understand the possibilities to migrate on-premises databases to Azure SQL Database. You will learn how to synchronize data across different environments and get more insights on how to troubleshoot issues in Azure SQL Database. This is a hands-on, open discussions and team work kind of session (not a traditional slideshow).
The video is not available to view online.
In this session we will share how real-world customers are using Azure SQL in their solutions to store and query trillions of IoT events in near real-time.
The video is not available to view online.
How to build a data platform in Azure
The video is not available to view online.
Find out everything you need to know to get started with Azure Cosmos DB in 20 minutes or less.
Your Azure Cosmos DB solution's performance and bill depends on partitioning and indexing. Please join me as I share how partitioning and indexing works in Azure Cosmos DB
In this session, join the live audience of a session that is being live streamed from the conference! You'll receive the latest updates containing all things SQL Server and Azure SQL. This not-to-miss session will include demos, special guests, and a sneak peak at the future!
The video is not available to view online.
DBA/Developer Toolset to get you out of that hole and save you some time
Are you trying to increase uptime locally or for disaster recovery but your network is terrible? Join the club. This session will discuss different techniques, their pros and cons, as well as considerations for availability when your network is flaky at best.
Azure SQL performance capabilities, how to configure and maintain your Azure SQL for higher performance. We will explore various monitoring tools and pick few scenarios for deeper troubleshooting. In this demo centric session, we will tune our database and find an optimal ground to manage cost. We will generate Power BI powered database score card for trend analysis.
How you can improve performance by splitting up large operations in chunks
The video is not available to view online.
Automate checking your database security model
Learn how to and why you should protect your data with Row Level Security in SQL Server and Power BI.
Two consultants, two different companies, two data professionals passionate about performance tuning. Do we like the same things? Do we have the same approach to problems? Topics will include: Trace Flags, DMVs, DBCC commands, Community Scripts and Intelligent Query Processing Features. We will talk about the features and solutions we agree on, and discuss where we disagree.
What do index rebuilds and defrags really do?
How to write stored procedures that have a high likelihood of performing well and are easy to troubleshoot.
This talk will focus on the key concepts of Amazon RDS for SQL Server and how to deploy database resources quickly and efficiently. Giving you the core knowledge to get started with SQL Server in the AWS Cloud.
This session will show you how to develop your code with .Net and C# using the latest Microsoft tools to launch quickly in the cloud while ensuring you meet the requirements of security, performance, and availability of your application. You will learn how to ensure your application is optimized with Azure SQL Database including Serverless and Hyperscale tiers, Azure Active Directory, retry and error handling, connection abstraction, automated indexing, and Intelligent Query Processing.
In this session, you will learn how to solve common security requirements for new or existing applications using Azure SQL Database and Azure SQL Managed Instance. We will cover Authentication and Authorization, Data Protection, Auditing and Security Management. After completing this session, you will understand how to meet specific security compliance standards and best practices.
In this session, we’ll go deep into the internal behavior of SQL Server CPU, including the internal and external memory pressure, worker thread management, and how to troubleshoot CPU problems.
The video is not available to view online.
Learn how enhancements to the SQL Server optimizer improve performance without code changes.
SQL Server 2022 is here! In this session, I’ll go over all the new capabilities in SQL Server 2022 including how to connect with Azure for disaster recovery, near real-time analytics, and security. I will show you innovations in the database engine for security, performance, and availability including SQL Server Ledger and Intelligent Query Processing.
In this Session MVP Frank Geisler and first time speaker Timur Dudhasch will give an introduction to Bicep for the Cloud DBA. As more and more systems are migrated to the cloud and as the sheer number of systems rises continuously Frank and Timur will demonstrate how to ease the process of creating and maintaining resources in the cloud via bicep
Everything you need to get started with PowerShell.
Hybrid Transactional Analytical Processing solve the age old problem of integrating operational processes with analytical capabilities within a single system. Find out what they're and how they deliver value
In this session, we'll see an end-to-end demo of how we can build a Jamstack site in Azure, using Azure Static Web Apps and Azure Functions, and taking advantage of well-known and less known features of Azure SQL that will make you – the developer – productive and efficient as never before. From Graph Models to JSON, from REST to GraphQL, this code-heavy demo packed session will show all you need to build end-to-end modern, scalable, solutions. CI/CD included.
One of the best ways to learn is through visualizations. In this session I'll teach you how to learn various aspects of SQL, ground to cloud, through architectures. We will cover scenarios including HADR, security, and scale using architecture design patterns across SQL Server, Azure SQL, and Azure Arc including new ways to attach SQL Server 2022 to Azure.
The video is not available to view online.
In this session, you will learn where data lives in a computer system, and the key performance metrics used to understand the health and performance of your storage subsystem.
Discover one of the most exciting and most discussed cloud-connect features connecting SQL Server to Azure SQL Managed Instance for near real-time data replication. The link supports scenarios of near real-time analytics, offloading R/O workloads, minimum downtime migrations, and disaster recovery in Azure. I will show you innovations made in this space, technology behind the scenes, some tips and tricks, live demos, and I’ll talk about the feature future.
The video is not available to view online.
For over 30 years, Microsoft has been leading the charge with innovations in the database spaced based on YOUR feedback and requirements. In this session, learn about the more recent innovations and customers, and how we're aiming to build the best operational database on the planet, anywhere you are. Database services covered include SQL Server, Azure SQL, Cosmos DB, Azure Database for PostgreSQL, MySQL, and MariaDB, and Azure Arc.
Come learn about all the latest innovations for SQL Server 2022 and Azure SQL directly from the Microsoft engineering team. This 2-part session will go into some detail for some of the new scenarios planned for Microsoft's flagship RDBMS.
The video is not available to view online.
Come learn about all the latest innovations for SQL Server 2022 and Azure SQL directly from the Microsoft engineering team. This 2-part session will go into some detail for some of the new scenarios planned for Microsoft's flagship RDBMS.
The video is not available to view online.
Quickly and easily migrate databases and associated logins using dbatools.
How to create a roadmap to migrate to Azure, best practices, and using Azure Migrate to start, & customer stories
Are you looking to move your SQL Server workloads to Azure but don't know where to start? Join us in this demo filled session to hear about our latest migration tooling innovations, that simplifies your decision making and execution through new migration tools. No matter which stage of the migration journey you are in, these tools will help you with your database migration projects by providing seamless tooling support across discovery, assessment, cost estimates, and database migrations.
The video is not available to view online.
Query store hints enables changing query plan shapes without modifying application code. We will look at a few poor performance scenarios and use query store hints to improve performance of the application. Become an instant hero  having query store hints in your toolkit.
The video is not available to view online.
<<12>>