Becoming an Azure SQL DBA - Advancing the Role of the SQL Server DBA

This half-day workshop delivered by Microsoft Azure SQL product group is optimized for SQL Server DBAs that want to learn how their role evolves in Azure and what are the skills that will make them heroes of digital transformation in their organizations.

You will learn how Azure SQL automates many common tasks and offers business continuity capabilities out of the box; what are the areas with shared responsibility; what remains solely in realm of DBA and what's the unique new value DBA can bring.

The topics include high availability, disaster recovery, backup and restore, performance tuning and troubleshooting, cost optimization, observability, security, compliance, connectivity, integration with Microsoft Fabric and other Azure services.

Return ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR

In this 20-minute demo session, you will learn how to soar your data to new heights by allowing online database replication and bidirectional failover between SQL Managed Instance and SQL Server 2022. With your choice of primary, you will be flying your data supersonic between these two destinations using the link feature.

The feature allows you to connect your data across hybrid environments and clouds to achieve near real-time database replication between SQL Servers 2016-2022 and Managed Instance, including the industry’s first bidirectional data movement and online failover (Disaster Recovery) between SQL Server 2022 and SQL Managed Instance.

This session will show you the latest and most exciting updates to the feature, that will enhance its flight capabilities, such as for example the ability to create the link from SQL Managed Instance to SQL Server 2022 and get a copy of your data, reverse migrate online, set up a transparent connection routing, and many more.

You can decide to pilot your primary data on either Azure SQL Managed Instance or SQL Server, and offload baggage, such are R/O workloads, reporting, analytics and backups, for example, to the secondary. Even if you have migrated to Azure SQL Managed instance, you still have the option to return to SQL Server 2022 at any time - just set up the link and fly back supersonic.

Modern models of managing database fleets in Azure PaaS.

SaaS model is taking cloud application business by the storm and, as of 2023, according to Gartner research, the SaaS industry is worth approximately $195 billion, and it keep on growing. Learn how Azure PaaS first-class offerings are addressing SaaS model revolution. Discover some new and not-so-new Azure PaaS offerings can help you improve the management of SaaS applications, virtualize your environment and improve your overall management of the solutions at scale.

With the primary goal of these offering being focused on dramatic simplification of provisioning and management of database fleets of all sizes (including rebalancing for lowering the financial impact), join the Product Group in learning the current state of affair and helping us shape the future of this area.

Meet the PG: Azure SQL Managed Instance

Come and meet the Product team for Azure SQL Managed Instance. Discover & discuss the newest additions to the platform, get your questions answered and let us know what Azure SQL MI is missing to enable your business to achieve more.

Discover what's new in Azure SQL Managed Instance through an exciting Demo Party!

Stay ahead of the curve and discover in a single comprehensive session packed with a punch about the latest innovations we’ve built into the Azure SQL Managed Instance straight from the engineering product group. Get excited about uncovering new frontiers of technology innovation enabling new platform capabilities, tools for capturing and comparing performance, achieving new platform performance capabilities, being more flexible with greater data mobility across instances, as well as technologies that enable hybrid connectivity, authentication across hybrid platforms, enhance security, enable new programmability and new disaster recovery capabilities – we shall cover it all. Learn how these technological frontiers can help you and how you can apply them in your own work environment. 

Azure SQL Managed Instance Deep Dive by Microsoft Product Group

Join us for an advanced session on Azure SQL Managed Instance, a fully managed SQL Server Database engine that provides industry-leading performance and security. We’ll cover all product areas, including a deep dive into High Availability Disaster Recovery (HADR), security, networking/connectivity, patching, hardware generations rollout, hybrid setups, and SQL features. This session is designed for professionals of all levels who are looking to deepen their understanding of Azure SQL Managed Instance. The content will be presented by the product group, the team leading and defining the product. Whether you’re a database administrator, BI developer, data engineer, or IT manager, this session will provide valuable insights and practical tips to help you get the most out of Azure SQL Managed Instance.

Ask the Expert - Group A (Thurs 13:40 to 14:00)

Got a problem? Don't know who to call? Bring it to SQLBits and get it solved by our panel of experts!

More information can be found here:
https://sqlbits.com/news/ask-the-experts-at-the-experts-lounge/

1. SQL and Databases: Ola Hallengren, Kay Sauter
2. Microsoft Fabric and Related Technologies: Devang Shah, Niels Nagle
3. Power BI and Data Visualization: Reid Havens, Kristoffer West, Kerry Kolosko
4. Azure and Cloud Technologies: Dani Ljepava

Advancing the DBA's Role in the Cloud: In the Cockpit of Azure SQL Managed Instance

With modernization of SQL Server workloads in Azure the role of DBA is advancing accordingly. Modernizing workloads in Azure might present challenges for DBA’s in determining which of the existing responsibilities to retain, which ones to delegate to Microsoft, and how to identify where to invest regained free time for maximum effect .

This session aims to clarify the advancement of the DBA role from on-premises SQL Server DBA to Azure SQL DBA. You will learn how your responsibilities from on-premises DBA map to Azure, and which new emerging opportunities await you in the cloud. On the example of fully managed PaaS service Azure SQL Managed Instance, one of the most compatible destinations for SQL Server workloads in Azure, you will learn which aspects of database systems are now fully or partially managed by Microsoft , what are the shared responsibilities between DBA and Microsoft , and opportunities for new skill development helping you become Azure SQL DBA superstar. The session will also provide guidance on the best practices and point out some of the most common pitfalls encountered in the redefined DBA role in Azure. The session will be delivered by SQL Managed Instance engineering product group.

There and back again: SQL Server 2022 <-> Managed Instance

In just 20 minutes you will see a demo of bidirectional database failover between SQL Server 2022 and Managed Instance, using the link feature.

The feature provides never-before possible hybrid connectivity and near real-time database replication between SQL Servers 2016-2022 and Managed Instance, including industry’s first bidirectional data movement and online failover (Disaster Recovery) between SQL Server 2022 and SQL Managed Instance

Need to move back from Azure to SQL Server on-premises, or anywhere else? No problem, use it all in reverse and replicate your online and near real-time from Managed Instance back to SQL Server 2022.

The Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance

In this session we’ll deep-dive into the link feature, a revolutionary new hybrid capability bridging the SQL Server and Managed Instance that provides the ultimate freedom of movement between the two.

The feature provides never-before possible hybrid connectivity and near real-time database replication between SQL Servers 2016-2022 and Managed Instance, including industry’s first bidirectional data movement and online failover (Disaster Recovery) between SQL Server 2022 and SQL Managed Instance.

You don’t even need to migrate to the cloud to use it – remain running on your existing SQL Server and use the modern Azure services by offloading R/O workloads and analytics to the cloud. When ready to migrate, use it as the best possible minimum downtime migration option in Azure.

Need to move back from Azure to SQL Server on-premises, or anywhere else? No problem, use it all in reverse and replicate your online and near real-time from Managed Instance back to SQL Server 2022.

Embark with us on the innovation journey and hear directly from the Microsoft SQL engineering product group on how we’ve started this as an internal project codename Chimera to what became the link feature.

What will you learn?
- Learn about revolutionary new hybrid capabilities between SQL Server and Managed Instance, what it means to you and how you can use it. Understand best practices in leveraging the new capabilities in your environment.

- Learn how to use Azure for analytics and R/O workloads and without actually migrating to Azure from your SQL Server.

- Learn how to use MI link as an insurance policy for reverse-migrations, and as a foundation of your multi-cloud strategy.

- Understand the innovation philosophy and journey in building new revolutionary capabilities and what’s coming directly from people who walked this path.

Meet the PG: Azure SQL Managed Instance

Come meet the team that builds Azure SQL Managed Instance, Dani Ljepava & Niko Neugebauer. Plenty of time to ask questions & get guidance on getting to MI.

Azure SQL MI End-to-end Demo Party for DBAs and Devs

Join us for a pure, demo-driven journey of a dozen incredible features for Azure SQL Managed Instance showing you the greatest and latest innovations enabling Database Administrators and Developers to achieve more.

Whether you’re a DBA, Azure Administrator, Developer, Business Intelligence developer, or of course any other data professional, these demos will show how you can achieve more with the exciting features that are available to you. Some of the topics we will cover are hybrid scenarios, performance and scale, application compatibility, workload modernization, compliance, data mobility/migration & business continuity/disaster recovery - and several more - in this fast-paced, demo-only session.

A day with SQL Managed Instance

Spend a whole day with the Azure SQL Managed Instance Product Group to discover how to provision, connect, configure, tune, monitor, troubleshoot and manage your instances and databases, to get the very best out of them. 
 
Ranging from setting up basics’ aspects with the help of the Azure Portal, but also diving into the automation aspects, this unique Azure Workshop will help you learn not only the necessary basics of Azure SQL Managed Instance, but will provide you with the knowledge of how to achieve more. 

Learn, Build, Migrate and Tune – all within a single day with Azure SQL MI Product Group. 

Become successful through understanding and making the best out of the Azure SQL Managed Instance, Microsoft PaaS offering that is most compatible with SQL Server running either on-premises or in IaaS.  

Meet the PG: Managed Instance with Dani Ljepava and Niko Neugebauer

Meet the PG: Managed Instance with Dani Ljepava and Niko Neugebauer

What's New in Azure SQL MI

Let us review the latest and the greatest investment that Microsoft has made into the Azure SQL Managed Instance, the product that serve as the best target for the existing SQL Server migration into Azure PaaS.
We shall review the newest functionalities from the last 12 months and dive into Log Replay Service, Manual Failovers and much more.

Unlock New Value in the Cloud with Azure SQL Managed Instance​

Join us for a journey through the past, present and future of Azure SQL Managed Instance, where we will dive deep into the latest innovations to help you modernize your SQL Server-based apps at scale. The service has significantly evolved since its initial launch with new hybrid capabilities like the link feature, which connects SQL Servers hosted on-premises or any other cloud.

Learn more about the unlimited storage available to you via ADLS Virtualization, support for legacy applications with Windows Authentication, and the latest Query Processor innovations. Discover why SQL Managed Instance has leading price-performance for mission critical workloads compared to any other cloud, making it the best destination for SQL Server in the cloud.

Link feature for Managed Instance

With the link feature for Managed Instance, we’ve advanced the hybrid connectivity between SQL Server and Azure to the next level. Innovations in this space allow near real-time replication of data between older and current versions of SQL Server to Azure SQL Managed Instance. Scenarios such are real-time analytics and offloading workloads to Azure are possible for all versions supported. See how to easily setup replication between SQL Server and Managed Instance and exercise some of these scenarios. Hear about the technology behind the scenes, best practices for using, monitoring and maintaining the link. Learn on how to get engaged with the product group and participate in shaping the future of the feature.

Feedback Link https://sqlb.it/?7365

10 Cool Things about SQL MI

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

feedback link https://sqlb.it/?7167

Becoming an Azure SQL DBA – Advancing the Role of the On-Premises SQL Server DBA (half-day workshop)

This learning pathway takes you on the journey of advancing the DBA role from supporting databases on-premises to supporting them in the cloud (Azure VM, Azure SQL DB and Azure SQL Managed Instance) through a comprehensive series of sessions. Modernizing workloads in Azure introduces challenges for DBAs in determining which of the existing responsibilities to retain, which are shared with, or fully delegated to Microsoft, and where to invest newly found free time to develop new cloud skills and excel as an Azure SQL DBA superstar.

In this series we will delve into understanding Azure SQL architecture and will compare it to on-premises environments, mapping the responsibilities of a traditional SQL Server DBA to Azure SQL DBA. We will identify shared, delegated and new responsibilities across various areas. These will include High Availability, BCDR, backup and restore, tuning and troubleshooting performance, monitoring, alerting, security, compliance, connectivity, and more. Discover how to leverage cloud elasticity, automation, cost optimization, management at scale, and utilize advanced Azure services such are failover groups and online database operations. Advance your skills learning about seamless integration with a myriad of Azure services helping your productivity, such are Fabric, Microsoft Copilot for Azure AI and others.

PASS Data Community Summit 2024

A day with SQL Managed Instance (full-day workshop)

Spend a whole day with the Azure SQL Managed Instance Product Group to discover how to provision, connect, configure, tune, monitor and troubleshoot and manage your instances and databases, to get the very best out of them.

Ranging from setting up basics’ aspects with the help of the Azure Portal, but also diving into the automation aspects, this unique Azure Workshop will help you learn not only the necessary basics of Azure SQL Managed Instance, but will provide you with the knowledge of how to achieve more.

Learn, Build, Migrate and Tune – all within a single day with Azure SQL MI Product Group.

Become successful through understanding and making the best out of the Azure SQL Managed Instance, Microsoft PaaS offering that is most compatible with SQL Server running either on-premises or in IaaS.

PASS Data Community Summit 2022