Modernize Your Applications with Azure SQL Managed Instance

Columbus GA SQL Users Group

In this session we will examine the benefits and capabilities of Azure platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) based solutions for SQL based workloads with focus on the new PaaS offering: Azure SQL Managed Instance.  For customers looking to bring existing applications to Azure we will cover the nearly 100% SQL Server compatible, platform-as-a-service offering known as Azure SQL Managed Instance. This offering removes blockers that previously forced customers to only consider IaaS based solutions for existing applications. With Azure SQL Managed Instance, instance-level SQL Server capabilities can now be migrated to Azure (e.g. SQL CLR integration, SQL Server Agent jobs, cross database querying, and more) without changing your existing application!  Additionally, with Azure SQL Managed Instance you gain access to Azure-only benefits such as Advanced Threat Detection, VNETs with support for private IP addresses, controlled service updates, and new monitoring capabilities for your application workloads.  Using private IP based VNETs, customers will be able to completely isolate their database tier from the public internet and join it to their other cloud VNETs or on-premises networks where their application resides. Controlled Service Updates allow customers to run their test environment deployed in a regular Azure public cloud subscription, where you can validate and apply updates on your terms in a scheduled manner to production.  We will compare and contrast Azure SQL Database, Azure SQL Data Warehouse, SQL Server on IaaS, and the new platform-as-a-service offering with Azure SQL Managed Instance. This workshop will focus on the following key Azure Managed Instance capabilities and scenarios: • Migrating SQL Server and non-Microsoft database systems, such as Oracle, with the Database Migration Service. The Database Migration Service automates and streamlines migration efforts reducing down time to minutes. • How to leverage the built-in management features such as integrated patching, updates, database backups and high availability. • How to take advantage of the built-in Intelligent optimization capabilities of the SQL Database Advisor tool, Automatic Tuning and plan correction with Query Store, and SQL-engine capabilities of Adaptive Query Processing. These capabilities reduce the overhead of database management and maximizes performance. We will also discuss non-clustered index tuning and maintenance, and more. • How to monitor Azure-based global scalability and availability with automatic backups, point-in-time restores, and leveraging Active Geo-Replication to control readable secondary databases in a globally distributed environment. With Active Geo-Replication we will illustrate how to enable global read-scale capabilities while also removing reporting bottlenecks on the primary. • We will cover high availability solutions with auto-failover with global-scale load balancing. • We will cover advanced security capabilities of Transparent Data Encryption, SQL Threat Detection, Always Encrypted, Row Level Security, Dynamic Data Masking, and Multi-Factor Authentication. • We will walk through monitoring with OMS to identify risks across the pillars of your application solution as well as setting up and reacting to alerts and events. • We will demonstrate key database management and monitoring strategies with SSMS, SQL Operations Studio, and Power BI. This workshop is focused on helping you learn and prepare for your own migration efforts. We will concentrate on what you as the database administrator and database developer need to know in order to migrate your applications to Azure, tune and monitor your solutions, troubleshoot common issues, and take advantage of the best Azure has to offer for Azure-based SQL solutions.  Prepare to push the boundaries of what your data-intensive applications are capable of in Azure!

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Modernize Your Applications with Azure SQL Managed Instance

More events from Columbus GA SQL Users Group

Discover more events from Columbus GA SQL Users Group, from Science & Tech to other experiences you might love.

Modernize Your Applications with Azure SQL Managed Instance

More events from Columbus GA SQL Users Group

Discover more events from Columbus GA SQL Users Group, from Science & Tech to other experiences you might love.

More Science & Tech events

Browse more Science & Tech events with different dates, prices, and formats to find your next great experience.