SQLBits 2023
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.
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.
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.
Speakers
Niko Neugebauer's previous sessions
Azure SQL MI & Fabric Fusion: A speed-session
We'll take the flight showcasing how data housed in Azure SQL Managed Instance can be dynamically exposed and utilized through Microsoft Fabric. This session will demonstrate the seamless altitude transition from the operational data platform of Azure SQL MI to the analytical skies of Microsoft Fabric, ensuring a smooth integration that leverages the best of both worlds for your business needs. Pilots of data – ready your instruments for this quick cruise that will equip you with the navigational know-how to soar above the rest, utilizing Azure SQL MI and Microsoft Fabric in tandem. Fasten your seatbelts; we're cleared for takeoff into the realm where data agility meets cloud efficiency.
Fly at Mach-speed with Azure SQL Managed Instance
Discover the future of SQL Managed Instance in our session! Learn about best-in-class storage tech and new capabilities for the unmatched price/performance and scalability.
Discover what's new in Azure SQL Managed Instance through an exciting Demo Party!
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.
Advancing the DBA's Role in the Cloud: In the Cockpit of Azure SQL Managed Instance
Join us to learn how DBA role has evolved from on-premises SQL Server DBA to Azure SQL DBA and what does it mean to you. You will learn how existing on-premises DBA responsibilities map to new DBA role in Azure, what are the new shared responsibilities in Azure, and opportunities for skill development helping you become Azure SQL DBA superstar.
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.
Secure networking with Azure and Azure SQL Managed Instance
Database migrations to the cloud must respect the existing networking and security systems already in place. Learn how Azure SQL Managed Instance combines its managed-service PaaS benefits with on-prem and hybrid⁄mixed scenarios. Modern features further leverage the benefits of the cloud to bring new value.
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
Azure SQL Managed Instance Roadmap
Learn more about the next wave of innovation coming to Azure SQL Managed Instance at this session hosted by the engineers from the product group.
Batch Execution Mode on the Rowstore
Learn in 75 Minutes what Batch Execution Mode is, when & how it will affect your workloads (in upcoming SQL Server 2019 & Azure SQLDB) on the traditional Rowstore Indexes.
Columnstore killed the OLAP Star-Did it really?
With increasing speed in relational query execution classical analytical solutions get challenged more and more. Why loose time for processing data into multi-dimensional databases? Why analyze outdated data if you can have fresh data instead?
Understanding & Solving Columnstore Problems
Dive deep into Columnstore Indexes and discover their advantages and some of the limitations.
Look into some of the Columnstore Indexes myths, understand more complex concepts of Batch Mode & Query Processing with another depth.
Getting Your Data into NodeXL
If you work with an amazing visualisation plugin NodeXL you might have asked yourself the question - how do I get my custom data for getting those great visualisation for analysis.
This session will show you a couple of ways of how to get it done.
ETL Patterns with Clustered Columnstore Indexes
Join me for an hour of playing with different ETL patterns by using Clustered Columnstore Indexes. Using different Hardware might lead you to different conclusions,and the size of the workload is always the paramount of your performance.Loading data first and then creating a Clustered Columnstore or creating Clustered Columnstore and than loading - join me to find the answers!
Dynamic MSBI content generation
In the ideal world, all information and structures are static, but in the real world almost everything is dynamic, and changes are constant. This session reviews different methods for generating MSBI content (SSIS, SSRS) dynamically.
Dr. Dani Ljepava
techcommunity.microsoft.com/t5/user/viewprofilepage/user-id/182256
Dr. Dani Ljepava's previous sessions
Return ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR
The demo showcases new capabilities of setting up hybrid link from SQL Managed Instance to SQL Server 2022, reverse migrating online, setting up transparent connection routing, and more. You can decide if your primary is either Azure SQL Managed Instance or SQL Server. Use it a Disaster Recovery solution, or for offloading R/O workloads on the secondary. Learn how to take advantage of the best integrated hybrid experience between SQL Server and SQL Managed Instance.
Discover what's new in Azure SQL Managed Instance through an exciting Demo Party!
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.
Advancing the DBA's Role in the Cloud: In the Cockpit of Azure SQL Managed Instance
Join us to learn how DBA role has evolved from on-premises SQL Server DBA to Azure SQL DBA and what does it mean to you. You will learn how existing on-premises DBA responsibilities map to new DBA role in Azure, what are the new shared responsibilities in Azure, and opportunities for skill development helping you become Azure SQL DBA superstar.
Modern models of managing database fleets in Azure PaaS.
Discover how Azure PaaS offerings can help you improve the overall management of SaaS applications, virtualize your environment and improve the overall management of the solutions at scale.
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.
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.
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.
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