Looking for a way to preserve your Oracle partition strategy while modernizing Azure SQL? SQL Server Migration Assistant's new automatic partition conversion allows you to retain your current partition model even when there is no direct type mapping. Dive into this significant time-saving feature in this episode of Data Exposed with Alexandra Ciortea and Xiao Yu.[01:45] New feature - Automatic Conversions for Partitioned Tables[03:05] Demo[12:25] Getting started Resources:SQL Server Migration AssistantSQL Server Migration Assistant for Oracle (OracleToSQL)Download Microsoft SQL Server Migration Assistant for OracleAzure Database Migration Guides

Planning a proper disaster recovery solution is a critical piece of any infrastructure design, even when working in the cloud solutions like Azure SQL Database. Thankfully, the Azure architecture provides a solution that with only clicks of the mouse a DR plan can be implemented. In this episode with MVP John Morehouse, we'll take a look at how easy it is to set up and configure a disaster recovery solution for Azure SQL Database. [00:37] About John Morehouse[01:27] Demo: Backups[04:42] Demo: Active geo-replication [10:39] Demo: Failover groups[15:20] Getting startedResources:BackupsActive Geo-replicationAuto Failover groups About John Morehouse:John Morehouse is currently a Consultant with Denny Cherry & Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, 2016 Idera Ace, Friend of Red Gate, Sentry One PAC member & Community Ambassador. John has a passion around speaking, teaching technical topics and giving back to the technical community as much as possible. He is a user group leader, SQL Saturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQL Saturday's as well as other conferences. If you want to find John, you can find him on Twitter (@sqlrus) or on his blog, https://sqlrus.com.About MVPs:Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical exper

Worried about your data validation post-migration to SQL Server or Azure SQL? Join us in this episode with Alexandra Ciortea and Xiao Yu to learn how you can create your leverage SQL Server Migration Assistant (SSMA) Tester to verify that converted objects work the same way and that all data was transferred properly. We will also share the enhancements which enable validation for Azure SQL targets and streamline the setup process. [02:00] SQL Server Migration Assistant Overview[04:26] Validate Migrated Objects Using SSMA Demo[08:20] Backup Management Feature Demo Resources:SQL Server Migration AssistantSQL Server Migration Assistant for Oracle (OracleToSQL)Download Microsoft SQL Server Migration Assistant for OracleAzure Database Migration Guides

Looking to leave Oracle behind? Watch the episode of Data Exposed with Alexandra Ciortea to find out how to ease into the migration journey by automating Oracle migrations to SQL Server or Azure SQL using SQL Server Migration Assistant. Customers looking to migrate from other database systems to Azure experience challenges in schema conversion, data movement. Microsoft SQL Server Migration Assistant (SSMA) is a suite of 5 tools designed to automate heterogeneous database migration to Azure SQL and SQL on-premises from Oracle, DB2, MySQL, Microsoft Access, and SAP ASE. [01:01]​ Challenges[02:16]​ SQL Server Migration Assistant Demo[14:40] Converting Statements Demo Resources:SQL Server Migration AssistantSQL Server Migration Assistant for Oracle (OracleToSQL)Download Microsoft SQL Server Migration Assistant for OracleAzure Database Migration Guides

Are you planning your SQL Server data estate migrations to Azure? Your first step is to discover and assess your SQL Server data estate and understand the Azure SQL readiness. Join Venkata Raj Pochiraju to get a sneak-peak into how you can leverage our Azure Migrate Service can provide comprehensive discovery and assessment of your SQL Servers migration to Azure Cloud that helps your migration planning.[01:00] End to end SQL Server migrations at scale using Azure Migrate (public preview)[02:32] User workflow[03:58] Demo[15:17] Getting started Resources:Database Migration guideAzure MigrateTutorial: Discover servers running in VMware environment with Azure MigrateTutorial: Assess SQL instances for migration to Azure SQL

Understand the various cloud migration drivers, migration strategies, and various phases in the migration journey in this episode of Data Exposed with Venkata Raj Pochiraju. He'll also introduce various database migration tools and services that Microsoft builds to help you in the migration journey. [01:14] Migration planning and execution[05:39] Application Portfolio Rationalization (MSIT)[08:57] Migration Investiments[12:01] Getting Started Resources:Database Migration GuidesAzure MigrateTutorial: Discover servers running in VMware environment with Azure Migrate: Discovery and assessmentTutorial: Assess SQL instances for migration to Azure SQL

In this episode of Data Exposed with Kate Smith, she'll take you through the basics of why query processing matters, what it does, and how Intelligent Query Processing makes your workloads faster and more efficient.[01:10] What is Query Processing[03:47] Query Processing vs Intelligent Query Processing[07:16]​ Getting started[08:14]​ Benefits of Intelligent Query Processing Resources:The Positive Impact of Intelligent Query Processing - Microsoft Tech CommunityIntelligent query processing in SQL databases

Jupyter Notebooks bring a wonderful capability to hand someone a single file that contains both code, and instructions on how to run that code. This is great and can be used in many different ways, one of which is to help new team members get up to speed. But what happens when you need to do the same thing as one of your existing Notebooks, but now you need to do it at scale? What if you could take your existing Notebook and add parameters for things like Server name & Database? In this episode with Aaron Nelson, take a look at how new features in Azure Data Studio can help you take your Notebooks to the next level of re-usability. [00:58]​ Notebooks overview[02:54]​ Create a Parameterized Notebook- Demo[03:51]​ SQL-on-Linux instance in a Docker container - Demo[09:00]​ Export Power BI Workspace Assets with PowerShell - Demo[12:22]​ Getting started Resources:Parameterization of Notebooks in Azure Data Studio - Azure Data Studio | Microsoft DocsUse Invoke-ExecuteNotebook to build a SQL-on-Linux instance in a Docker container, by calling Invoke-ExecuteNotebook to execute the Notebook, and passing in the sa_password & digits for the name/port number to the Notebook as a parameter

Helm is the package manager for Kubernetes itself. Learn with Amit Khandelwal on Data Exposed how you can use Helm from your Windows machine to deploy SQL Server 2019 containers on Kubernetes all in less than 5 minutes.[01:36] What is Helm[02:48] What do I need to get started?[05:20] Demo[24:00] Getting startedResources:Deploy SQL Server on Azure Kubernetes Service cluster via Helm Charts - on a windows client machineGithub

In this episode of Data Exposed, Manoj Raheja shows us how to seamlessly integrate with Azure Data Explorer from Apache Spark for Azure Synapse Analytics.[01:13] Azure Data Explorer Overview[02:52] Azure Data Explorer connector for Azure Synapse[05:20] Demo[09:20] Getting started Resources:Connect to Azure Data Explorer using Apache Spark for Azure Synapse AnalyticsGitHub (Sample Code)