Azure SQL and SQL Server for Developers - Immersion Workshop

From the Classroom to the Boardroom – Azure SQL DB through Demos

Join us to learn about Azure SQL DB exciting features in form of demos, yes you heard it right, no slide only Demos.

Building SaaS solutions on Azure SQL Database

Azure SQL Database is powering some of the largest SaaS solutions on the planet sporting millions of tenants. It does that through a combination of multiple multi-tenancy models that support different requirements and use cases. from few users to millions. In this session, we'll dig deeper into some examples of real-world architectures implemented by 1st party and 3rd party solution providers like Microsoft Dynamics 365 and others, and see how these can be applied to your own scenarios.

Practical Azure SQL for the Modern Developer

Come learn how to take advantage of everything Azure SQL can offer to a developer

SQL Server in Windows Azure Infrastructure as a Service

Ewan Fairweather and Silvano Coriani from the SQL CAT team will take you on a tour of the new features that make up the Windows Azure Virtual Machines and Virtual Networks running SQL Server 2012 in a Virtual Machine.

The Cloud Workshop for the SQL Professional

Are you thinking, exploring, migrating, or have migrated from SQL Server to Azure? Come translate your SQL Server skills to the cloud in an interactive, hands-on workshop. (In-person only)

Welcome to the world of SQL Copilots

Microsoft is building a new experience of an AI companions called Copilot that are transforming how people work, write code, and solve problems faster. In this session come learn the latest innovations in SQL Copilot technology including GitHub Copilots for developing code and assisting with the T-SQL language. In addition you will get the latest look at Copilot technology to assist you in using and managing SQL in Azure. We will have plenty of demos in this session so come in and get ready to learn the new world of AI companions with SQL.

Come see your SQL Perfmon in the cloud

Come learn the latest innovations for monitoring technologies for SQL Server and Azure SQL

The Microsoft Data Leadership Panel

TBD

SQL Server and Windows Server Better together on Azure

Join us to learn how you can reap more technical and business benefits by running Windows Server and SQL Server on Azure. In this session you will get a first look at Windows Server vNext and innovative technologies for SQL Server including new monitoring and AI experiences.

Debugging SQL Server

Have you ever thought about how Microsoft uses the Windows Debugger with SQL Server? In this session I'll show you some advanced scenarios and how we debug SQL Server using a combination of the debugger along with instrumentation in the engine and other tools. This is an extremely deep level session and not for the feint of heart. You will get the best out of this session if you already have a solid understanding of the SQL Server engine.

The SQL Leadership Panel

Bring all your questions about the strategy and future of Microsoft SQL to the leadership team of Microsoft in a panel hosted by Bob Ward, Principal Architect at Microsoft

SQL Server 2022 and the Wheel of Power

Come learn about the latest major release of SQL Server and the "wheel of power" with capabilities across hybrid, built-in query intelligence, core database engine, data virtualization, and T-SQL. This is one of the most power-packed set of new capabilities in a SQL Server major version ever and this session is the one you will want to attend to learn about all of them.

SQL Server 2022 hidden gems

SQL Server 2022 has many new capabilities for the database engine across security, performance, and availability. In this demo-heavy session learn about new enhancements that you may not be familiar with that have real practical value. You will learn how these new features work and understand how they can solve real-world problems.

The Kingdom of AdventureWorks Calls for Aid

The Kingdom of Adventure works has been besieged by Monsters from the Cave of Despair – Can the able Party of Engineers save the Kingdom from the horrors of security attacks, degraded performance, stability and resiliency using the power of the Microsoft Intelligent Data Platform? Come to see how they battle the foe with data and analytics, and what the Campaign holds for our trustworthy band of heroes!

Platform Innovations with SQL Server 2022 + Intel

Get ready for a journey through the cutting-edge platform advancements in SQL Server 2022! In this must-attend session, our Microsoft and Intel subject matter experts will take you on a tour of the latest platform innovations, demonstrating the new capabilities and solutions that are driving the next generation of database administration. Discover how Intel technologies are powering the SQL Server experience and hear about the latest hardware advancements from Intel that are shaping the future of the platform space. We'll dive into the backup compression improvement enabled by SQL Server 2022 and Intel® QuickAssist Technology (QAT). You'll learn how this integration allows for offloading of compute overhead, reduction of CPU usage, improvement of backup completion times, and reduction of storage consumption. We will also discuss the latest Intel hardware and where we are going next with SQL Server and Intel technologies. We will also cover Intel AVX-512 (Advanced Vector Extensions 512-bit) technology designed to accelerate the performance certain computing tasks, allowing the processor to perform multiple operations in parallel. SQL Server 2022 can leverage AVX-512 instructions to improve the performance of certain query operations by offloading compute-intensive operations to the processor. By utilizing AVX-512, SQL Server can take advantage of the improved parallelism and faster performance offered by modern processors, providing customers with faster query execution times and improved overall performance by offloading some of the work from the CPU to the processor. Don't miss your chance to be at the forefront of the platform revolution and discover the latest advancements in SQL Server and Intel technologies!

Introducing SQL Server 2022

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.

How to Build Secure, Scalable, and Highly Available Applications with Azure SQL Database

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.

SQL Server 2022: The hybrid data platform

SQL Server has included capabilities to connect to the cloud for years. SQL Server 2022 moves hybrid to the next level with features to connect you to Azure for disaster recovery, near real-time analytics, and security. Come take a deep dive in this session for all the existing and new hybrid capabilities of SQL Server. See how to easily setup a managed disaster recovery site in the cloud with Azure SQL Managed Instance.

AMA with the Microsoft Engineering team hosted by Bob Ward

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.

SQL Server 2019: The Modern Data Platform

SQL Server 2019 represents the next evolution of the leading database platform in the industry. In this session, we will cover the complete set of features and capabilities in SQL Server 2019.

Inside SQL Server on Kubernetes

In this session, we will dive deep into the Kubernetes platform and how SQL Server containers can be deployed, managed, and configured. This session assumes a fundamental knowledge of both SQL Server and containers.

SQL Server to Azure SQL: Performance and Availability

Translate your existing SQL Server performance and availability skills and apply them to Azure SQL.

Inside SQL Server 2019

Come learn all the new capabilities of SQL Server 2019 directly from the Microsoft engineering team. This session will provide the strategy behind SQL Server 2019 as well as a deep dive into all the new features and how they can help you modernize your data estate with SQL Server.

Inside SQL Server Containers

Containers are the new virtual machines. They present a new way to deploy, manage, and run SQL Server never possible before. This session will present an internal view of how Docker containers work, how SQL Server runs in them, and how they work in environments such as Kubernetes

Inside SQL Server 2019 Polybase

SQL Server 2019 expands on the Polybase feature from SQL Server 2019 by providing a robust data virtualization solution to reduce the need for ETL and data movement. Come learn how new data connectors work with sources like Oracle, MongoDB, CosmosDB, Terradata, and HDFS.

Experience SQL Server on Linux and Containers

SQL Server 2017 is all about choice. Choice for developers to run on Windows, Linux, or Containers. In this session we will show you the experience of running SQL Server on Linux and Containers including a behind the scenes of how we built it.

Experience SQL Server 2017: The Modern Database Platform

Looking to upgrade your SQL Server? This session will discuss all the new features and capabilities of SQL Server 2017 including SQL Server on Linux, Docker Containers, Graph Database, Python, Adaptive Query Processing, Automatic Tuning, and HADR.

Adaptive query processing in SQL databases

Come learn about the new adaptive query processor in SQL Server 2017 and Azure SQL Database. We will discuss how this feature works, how it can benefit your application and queries, and the future of intelligent query processing.

SQL Server 2016 It Just Runs Faster

Come take a deep dive and behind the scenes look at why SQL Server 2016 "Just Runs Faster" with little or no application changes.

Keep Your Environment Always On with SQL Server 2016

The Microsoft Tiger team will showcase the environments that help you keep your environment Always On

Deploying SQL Server with Microsoft Azure Virtual Machine

Many customers are looking toward Cloud technologies to reduce operational and capital expenditures. A popular choices today for SQL Server customers is to deploy in the Microsoft Azure Virtual Machine environment. Come to this session and learn how

Windows Azure SQL Database Troubleshooting

While knowledge of SQL Server troubleshooting still applies to the Windows Azure SQL Database service, there are new and different features, methods, and tools that are unique to cloud database computing. Come learn about these new techniques.

The 10 things every developer must absolutely know about Azure SQL

The engine powering Azure SQL and SQL Server databases has been around for 30 years and has evolved a lot during that time. In this session we'll see many of this "little" but yet incredibly useful features and knowledge bits, with a lot of demos and a lot of lateral thinking.

My application is fully concurrent and async. What about the database?

Let's look at how concurrency works inside the database. If you want to create a truly scalable solution, this knowledge is needed as much as knowledge about threads and synchronization mechanisms in your favorite language.

Jamstack Foundations: Building Scalable API from the Ground Up

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.

Practical Azure SQL for the Modern Developer

Come learn how to take advantage of everything Azure SQL can offer to a developer

Temporal Snapshot Fact Table

Snapshots without snapshots...is that possible? Take a "Classic" snapshot fact table, add some temporal data theory and you'll get a new fact table than can store snapshot data without doing snapshots. A life saver when you have a lot of data.

Connecting the dots of Azure SQL DevOps

Come to this session to learn how to use tools and platforms like VS Code, Azure Data Studio, GitHub and Azure DevOps for a modern, secure, and easy-to-use database DevOps experience for Azure SQL. We will use demos to show how to implement a project / declarative approach. You will leave with a solid understanding of the broader landscape as well as specific techniques that you can implement immediately.

The SQL Leadership Panel

Bring all your questions about the strategy and future of Microsoft SQL to the leadership team of Microsoft in a panel hosted by Bob Ward, Principal Architect at Microsoft