Database migrations often involve multiple phases, steps, and tools based on various scenarios and workload requirements. To help you migrate your databases to Azure, we have published a set of new Azure Database Migration Guides and a Hub page that provides scenario-based migration content and "How To" guides depending on your source database and target database platforms. In this episode with Mohamed Kabiruddin, he will walk you through the new migration hub page to easily navigate to the content you need based on your scenario, how to use the relevant database migration guides, and how to provide feedback to Microsoft for any specific content. [01:07] Migrations Process Flow[02:54] Azure Database Migration Guides Overview[08:08] Customer Case Studies[09:47] How to provide feedback[11:08] Getting startedResources:New Migration Hub pageAzure Migration Center

In this episode of Data Exposed with David Trigano and David Brookler, learn how you can leverage new capabilities in Dynamic Data Masking, help your organization prevent unauthorized access to sensitive data, and gain control by masking it to a non-privileged user at different levels of your database. [01:45] What is Dynamic Data Masking[02:14] Demo using Azure Portal[04:01] Demo using SQL Server Management Studio (SSMS) Resources:Dynamic data masking

In this episode with Gaston Cruz, he'll show you the options to process Azure Analysis Services models (Semantic Layer) connecting to an Azure SQL DB as a data source (using SSDT), and then create an architecture using a Service Principal account to process the model (DB, Tables, Partitions) in an automatic way deploying an Azure Logic Apps, and then calling from Azure Data Factory to trigger the process. Finally, he'll conclude by showing you the advantages of using a live connection from Power BI to connect to AAS models. [00:35] About Gaston Cruz[01:43] Architectures[04:20] Demo[12:30] Adding other data sources Resources: Gaston's YouTube ChannelAAS REST API official doc

We all know one of the most important and secure methods of authentication in SQL Server is through AD authentication. Learn today in this episode of Data Exposed with Amit Khandelwal how to enable AD authentication for a SQL container and log in using an AD account all in less than 5 minutes using a tool called adutil.[02:41] What is Adutil (Preview)? And why are we talking about it?[04:47] Setup[08:30] Demo: Enable AD authentication for SQL 2019 containers Resources:Tutorial: Configure Active Directory authentication with SQL Server on Linux containersIntroducing adutil - A tool to ease configuration of AD authentication for SQL on Linux/ContainersTutorial: Configure Active Directory authentication with SQL Server on Linux using adutil

Azure SQL Auditing recently announced two new destinations now Generally available, and a new capability called Azure SQL Auditing of Microsoft support operations. In this episode, Anna Hoffman and David Trigano will cover all these new capabilities that allow you to capture any operations done against your SQL assets on Azure at scale.[00:50]​ Announcements[03:30] Demo: Enabling Azure SQL Auditing and Auditing of Microsoft support operations[05:30]​ Demo: Deploy Azure SQL Auditing at scale with Azure Sentinel [07:18]​ Demo: Log analytics[08:50]​ Getting startedResources: Auditing for Azure SQL Database and Azure Synapse Analytics

SQL Assessment API provides a mechanism to evaluate the configuration of your SQL Server for best practices. The API is delivered with a ruleset containing best practice rules suggested by SQL Server Team. This ruleset is enhancing with the release of new versions but at the same time, the API is built with the intent to give a highly customizable and extensible solution. So, users can tune the default rules and create their own ones. The API can be used to assess SQL Server versions 2012 and higher and Azure SQL Managed Instance. In this episode with Aaron Nelson, we'll show you the basics of the SQL Assessment PowerShell commands, and how you can run the assessments for your Azure SQL Managed Instances as well as your on-prem SQL Server instances. [01:23] Intro to SQL Assessment checks[02:19] Demo: SQL Assessment checks[09:08] Getting started Resources:SQL Server Samples

You don't necessarily need to change your data models and applications to run operational analytics workloads on Azure SQL. In part two of this three-part series with Silvano Coriani, we will explore Azure SQL capabilities to optimize your databases for mixed workloads on real-time data. [01:47] Traditional Analytical Architecture[03:10] Minimizing Data Latency for Analytics[04:42] Operational Analytics: Nonclustered Columnstore Index (NCCI)[06:19] Demo: Operational Analytics with Nonclustered Columstore Index[10:35] Operational Analytics: Columnstore on In-Memory Tables[14:45] Demo[18:45] Getting startedMore episodes in this Operational Analytics Series:How Azure SQL Enables Real-time Operational Analytics (HTAP) - Part 1How to Create Operational Analytics with Window Functions in Azure SQL - Part 3 Resources:Get started with Columnstore for real-time operational analyticsSample performance with Operational Analytics in WideWorldImportersT-SQL Window Functions: For data analysis and beyond, 2nd EditionReal-Time Operational Analytics:Memory-Optimized Tables and Columnstore IndexDML operations and nonclustered columnstore index (NCCI) in SQL Server 2016Filtered nonclustered columnstore index (NCCI)

Azure SQL enables hybrid transactional/analytical workloads for real-time operational analytics scenarios through a mix of in-memory and columnar database technologies. In the first episode of this three-part series with Silvano Coriani, we will explore Azure SQL capabilities to run a mix of transactional and analytical queries on the same underlying data store. [00:49]​ Different type of workloads[03:59]​ Hybrid transaction/analytical processing[04:45]​ Enable HTAP: real-time operational analytics[07:00]​ Coming up More episodes in this Operational Analytics Series:How to Optimize Existing Databases & Applications with Operational Analytics in Azure SQL - Part 2How to Create Operational Analytics with Window Functions in Azure SQL - Part 3Resources:Get started with Columnstore for real-time operational analyticsSample performance with Operational Analytics in WideWorldImportersT-SQL Window Functions: For data analysis and beyond, 2nd EditionReal-Time Operational Analytics:Memory-Optimized Tables and Columnstore IndexDML operations and nonclustered columnstore index (NCCI) in SQL Server 2016Filtered nonclustered columnstore index (NCCI)

SQL assets are critical resources and contain the most precious information a company owns, which makes them one of the preferred targets for attackers. Protecting them across the environments can be challenging and requires multiple skills to deploy, manage, and remediate those precious resources. In this episode with David Trigano, you will learn how Azure Defender for SQL protects your SQL anywhere and offers capabilities to discover misconfigurations and raise alerts in case of usual activities across every flavor of SQL you are using today, in any environment. [01:09] What is Azure Defender for SQL[02:00] Where is Azure Defender for SQL supported[02:40] Demo[08:24] Getting started Resources:Introduction to Azure Defender for SQLAzure Security Center

In this episode with Dani Ljepava, we will show you how to manually trigger a planned failover on SQL Managed Instance to test your applications for fault tolerance and will talk about best practices for your applications to achieve tolerance to transient faults typical for the cloud environments. Transient faults in the cloud (for example software patching, security updates, failover, and similar) include a momentary loss of network connectivity, temporary unavailability of a service, or timeouts when service is busy. These faults are often self-correcting due to which your applications need to be able to handle such occurrences with the appropriate retry logic. While migrating legacy apps to the cloud or developing new cloud-born apps, it is strongly advised to ensure that your applications follow the best practices disclosed in this episode helping you build cloud-ready apps.[00:46]​ About Dani Ljepava[01:30]​ Transient errors in the cloud[02:50]​ Cloud Ready Apps[04:07]​ Understanding failover as part of HA on SQL MI[06:00]​ Demo: User-initiated failover on SQL Managed Instance[11:35] How to check if failovers occurred[12:35]​ Best practicesResources:User-initiated manual failover on SQL Managed Instance