Why do you need subnets? What addresses can we use? And what is the difference between a /16 and a /24 subnet anyway? Virtual Networks and subnets can be daunting in Azure, yet they are fundamental to so many resource types. In this session we'll cover everything you need to know to get started with creating your own virtual network are carving it up into subnets of various sizes to meet your needs. So next time you need to create a subnet to join your Azure SQL VM to, you'll know exactly how to plan for this and implement accordingly.
The video is not available to view online.
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 video is not available to view online.
With more and more deployments of SQL Server becoming hybrid or cloud native, how do you need to think about availability? This session will give you the foundation on how to approach availability in the new world.
The video is not available to view online.
Cloud migration projects are often massive projects with sprawling scopes. Don't you want some help sorting through this enormous pile of work? Join an experienced cloud migration consultant for a targeted walkthrough of their cloud migration success checklist so you can make sure your project gets off to a good start and reaches a successful completion.
The video is not available to view online.
Want to avoid downtimes or big blocking operations when managing indexes on busy systems? In this session, we will talk about some common problems that can lead to unexpected downtimes and how we could avoid them.
The video is not available to view online.
Migrating from On-Prem SQL Server to Azure SQL Managed Instance requires a set of pre-requirements that can become much easier if we can validate and repeat the steps needed. No matter if it's an Offline or Online migration, dbatools can make your life easier.
The video is not available to view online.
We cloud solutions architects from Microsoft, will be demonstrating all the use cases with demos of the newly available (currently in public preview) Azure SQL Managed Instance Link. We will talk about all the available migration tools like DMA, DMS, Azure Migrate, ADS and why you may want to use MI Link to migrate on-prem SQL Server to Azure SQL Managed Instance as compared to other available migration tools.
The video is not available to view online.
So you’re the data person in your company and you need to look to the sky. Maybe you've been wanting to do it for a while, maybe it's a mandate coming from the top. What are the steps you need to think about? Where do you even start? What are the risks? How can you begin to wrap your head around all the different things you have to coordinate? Companies don't just need the IDEA that they should move to cloud, but a guide on how-to-do it. This session will not only give you that guide to get you going, but a foundation to take to your bosses to show just how awesome you really are.
The video is not available to view online.
Security is given too little attention in the database environment and many times more rights are given than are necessary. Especially with CROSS DATABASE access, the goal is often overshot. Learn how to securely access data in other databases without breaking the bank.
The video is not available to view online.
Join me in this session to explore the Log Replay Service. Learn how to use it to take control and customise your own migration projects to solve some of the challenges of migrating large databases to Azure SQL managed instance.
The video is not available to view online.
If you care about your database performance, then make sure you take care of your statistics. Join this session to learn why it is so important, and how to do it right.
The video is not available to view online.
Customers would be able to understand what exactly Polybase is, why it's useful, what are the use cases and finally how to use this feature of SQL Server. Polybase have been around for quite some time, since SQL Server 2016, however, the awareness and the way it virtualises the data may not have been understood well for some customers.
The video is not available to view online.
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.
The video is not available to view online.
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 video is not available to view online.
You know Microsoft handles patches and updates for your OS and SQL but what does that really mean? When does that maintenance occur, what might happen and do I have any control? Let's answer these questions and more in 20 minutes.
The video is not available to view online.
How to design data strategy and choose the right database for modern cloud applications.
The video is not available to view online.
Join me on a journey through the different offerings in Azure Arc and how they can benefit you as a data professional!
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
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.
Join us, as we explore the capabilities of Azure Arc-enabled SQL Managed Instances.
An overview of VNets, Service Endpoints & Private Endpoints for Azure SQL DB & Managed Instance
DBA/Developer Toolset to get you out of that hole and save you some time
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.
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 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
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.
Even in a cloud provider or virtualized, you still need to worry about the infrastructure supporting SQL Server. This session will cover what that means in the modern world.
Introduction of areas for partitioning for Beginners
Learn what's new in Microsoft Defender for Cloud for data store
Do not be afraid to move your onprem SSIS packages to Azure. Come and learn how lift and shift them to the cloud
Scaling SQL Servers is complex and is more relevant today as the transactional and data growth rates continue to grow. In this session, we will talk about what it takes to scale SQL Server to meet the peak workload.
There are several different data platform solutions for use within your application. Selecting the right option can make the difference between a well-performing application and a poorly performing one; not to mention the cost aspect of choosing the wrong solution.
Do you want to get the current 232 suggested best practices from the Microsoft SQL Server Team and evaluate your environments? In this all demo session (Yes, no slides), I will show you both the "what" and "how" to do the same using the SQL assessment API and Azure Data Studio 'SQL Assessment' extension.
In this session, we'll set you on the right path towards high availability and disaster recovery for common data architectures in the cloud by the end of this session.
Let us walk you through our steps to triage and troubleshoot issues as they come in to make sure things get fixed in the right order at the right time and we all stay sane.
Best practice checks to optimize costs, increase the performance, and reliability of all your Azure VM's and Azure SQL DB's.
The video is not available to view online.
Best practice checks to optimize costs, increase the performance, and reliability of all your Azure VM's and Azure SQL DB's.
The video is not available to view online.
This session is specifically designed to inform you, the DBA, about the tools and language I’m giving your developers in order for them to communicate their needs.
The video is not available to view online.
Discover & 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.
The video is not available to view online.
In this session, we'll cover the 10 most common tasks a DBA needs to learn to manage in Azure SQL as well as they currently manage their On Prem installs.
In this session, you'll learn about an end-to-end scenario that takes customers through the application migration process, and how that relates to the data migration.
Learn the tools and techniques you can use to create governance and insights around your Azure spend
We will deep dive into the architecture of Hyperscale and its various components. We will dive into scaling aspects and the new application patterns it enables and also diagnostics that enable bottleneck identification.
Learn what to use when for various flavors of Azure SQL
Learn to make better analytic solutions by following current thoughts on data modeling.
The video is not available to view online.
In this session you’ll learn the real-world ins and outs of how we successfully migrated customers to Azure data platform.
The session takes you through the most critical considerations for moving your on-premise data and databases into the Azure cloud, with a focus on the steps leading to the migration and immediately afterwards.
Unfortunately, disasters can affect cloud technologies and if you are't prepared for it, the results can be painful. Let's discuss ways to implement Azure SQL disaster recovery techniques to help protect your data!
Learn about internals of the Failover Groups as a BCDR feature recommended for the critical database workloads that must survive region-wide outages and recover instantaneously.
The video is not available to view online.
In this session, we will discover how to utilize common machine learning approaches for daily SQL Server DBA tasks.
<<12>>