Azure's best-kept secret is now a part of Synapse! Watch this episode of Data Exposed with Henning Rauch to learn how telemetry data can be analyzed using Azure Synapse Data Explorer. It comes with an amazing real-world IoT scenario. [01:04] Azure Synapse Data Explorer[01:26] Key pillars of Azure Synapse Data Explorer[02:02] Scenarios[03:12] The solution[04:31] Demo[08:23] HighlightsResources:IoT analytics with Azure Data ExplorerAzure Synapse Data Explorer documentationAzure Synapse Data Explorer preview announcement blog

Learn about best practices of loading data to Azure SQL Database, how to efficiently utilize log generation rate and various techniques to efficiently load data into Azure SQL Database in this episode of Data Exposed with Denzil Ribeiro. [00:43] Data loading overview[03:05] Demo[16:32] Mistakes to be aware of

Join us for an introduction to the latest release of SQL Server and learn about all its new capabilities from cloud-connected to built-in query intelligence. [00:50] What's new[01:42] The next step for SQL Server[02:13] SQL Server 2022[05:09] Query Store and Intelligent Query Processing[07:09] Industry-leading database engine[08:37] Data lake virtualization and object storage[10:13] Extending T-SQL[11:47] Getting started Resources:Learn more about SQL Server 2022​Register to apply for the SQL Server 2022 Early Adoption Program and stay informed Watch technical deep-dives on SQL Server 2022SQL Server 2022 YouTube Playlist

Flexible Server is a new, next-generation option in the Azure Database for PostgreSQL managed service. Hosted on Linux OS, Flexible Server delivers superior out-of-box performance, zone resilient HA, customer-managed maintenance windows, plus a developer-friendly experience. Join this episode with Sunil Agarwal to learn more about why people are excited about the PostgreSQL managed service on Azure and the newly GA'd Flexible Server option. [00:32] Introductions[01:00] Flexible Server for Azure Database for PostgreSQL Overview[04:43] Getting started with Flexible Server Resources:What is Flexible Server in Azure Database for PostgreSQL? - Microsoft Tech Community Bringing the best of Azure and PostgreSQL innovation to developers - Microsoft Tech Community Azure Database for PostgreSQL - Flexible Server | Microsoft Docs

Data engineering is one of the most involved, dull, and repetitive tasks in the data industry today. Bringing up the subject is a sure way to instantly clear the room at a party or make your friends groan in despair. The work includes a lot of complicated tools, many, many lines of code, and a not-insignificant amount of gnashing of teeth. But what if I told you there is a way to quickly, easily, and cheaply do both data engineering and data exploration on most data without even having to import it into a database? What if I told you that Azure Synapse has a just about magical tool that can instantly connect to flat files and make them available as nice, well-behaved tables? I'm talking about Azure Synapse serverless pools, a great tool for both initial exploration and surprisingly complex data engineering. I'll walk you through what it is, how to set it up, and give you a few examples of basic data exploration, as well as a tad more complex data engineering. Oh, and did I mention you can actually store the end result in several different formats as well...?[00:56] Azure Synapse Serverless Pools Overview[01:54] Demo[11:05] Getting started Resources:Andy Cutler's blog on serverless poolsAndy Mallon's blog on bucketing with T-SQLAbout Alexander Arvidsson:Alexander is a principal solutions architect at Attollo in Sweden. Nobody really knows what it means to be a principal solutions architect, but he spends his days speaking, teaching courses or helping clients of all shapes and sizes to take better care of their data.He has spent the last 25 years toying with data, databases and related infrastructure services such as storage, networking and virtualization, occasionally emerging from the technical darkness to attend a Star Wars convention somewhere in the world.He is a frequent international speaker, Data Platform MVP, podcaster, Pluralsight author, blogger and a Microsoft Certified Trainer, focusing on the Microsoft data platform stack.About MVPs:Microsoft Most Valuab

Did you know that Jupyter Notebooks can be automated? Join this episode with Julie Koesmarno to see an example of how you can use automate diagnostic notebooks automatically executed as an issue is assigned to you. We will be using Azure serverless architecture to illustrate this example. You will learn how you can leverage Azure Logic Apps and API that is available for executing Jupiter Notebook from command lines. [01:30] Automating Diagnostic Notebooks Overview[03:10] Demo[08:02] ArchitectureResources:Troubleshooting SQL Server made easy via Notebook

In this episode of Data Exposed with Julie Koesmarno, we will give you a sneak peek of what's new in Azure Data Studio. In this demo, Notebook view simplifies the workflow for your notebook consumers. At Microsoft, we continuously strive to come up with practical ideas that help our customers. With that, we have also been experimenting with converting a couple of highly used SQL Server docs to Notebooks.[00:58] Notebook Views overview[03:05] Demo[05:27] SQL Docs to Notebooks[07:33] Getting startedResources: Troubleshooting SQL Server made easy via Notebooks – seeking your feedback

Looking for a cross-platform Oracle schema conversion solution? Join Alexandra Ciortea, Alexander Ivanov, and Anna Hoffman to learn about the new experience we are building in Azure Data Studio. This feature is currently available in Insiders build of Azure Data Studio and will soon be available in the mainstream as well.[00:25] Introduction[01:15] What is DSCT[02:41] Demo[10:09] What to know when getting started[11:39] Scenarios[12:38] Roadmap Resources:Azure Data Studio – InsidersMigrating to SQL series playlist

Are you looking to modernize your on-premises databases to Azure SQL? Join Alexandra Ciortea, Raymond Truong, Wenjing Wang, and Anna Hoffman to understand how you can size your Azure SQL target accordingly, based on the current performance and business requirements. We will walk you through several approaches and models that can suit your needs.[00:40] Introductions[00:58] What is DMA[01:38] What is an SKU[02:23] SKU recommendation console application[03:43] Demo[12:34] How data is collected[14:10] Demo[20:11] How to migrate Resources:Download Microsoft Data Migration Assistant v5.5Identify the right Azure SQL Database, Azure SQL Managed Instance or SQL Server on Azure VM SKU for your on-premises databaseRun Data Migration Assistant from the command line

In this episode of Data Exposed: MVP Edition, Javier Villegas will describe the concept of SQL Server Failover Cluster Instances (FCI) covering how we can use them for High Availability purposes using Azure Virtual Machines and the different Azure Storage options. Recently introduced in Azure VMs, SQL FCIs allows to easily migrate HA workload from on-premises environments to the cloud with the added benefit of application compatibility.[00:30] About Javier Villegas[01:20] Failover cluster overview[05:36] SQL Server Failover Cluster Instances in Azure[09:09] Demo: Created shared disc in Azure portal[11:42] Getting startedAbout Javier Villegas:Javier Villegas is IT Director (DBA & BI Services) at Mediterranean Shipping Company with more than 20 years of experience working with SQL Server, Including Azure SQL.His specialization is Administration, Performance Tuning, High Availability and Disaster Recovery.Javier is a Microsoft MVP Data Platform since 2016 and MCT.He is a frequent speaker in technical conferences and events such as SQL Saturdays, PASS Virtual Groups, PASS Marathons, 24 Hours SQL PASS , vOpen , GroupBy ,DataPlatformGeeks , Data Saturdays and Azure Global Bootcamps.He is one of the group leaders of SQL Argentina Community and Microsoft Azure Data Advisory Board Member. 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 a 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 experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and the quest for knowledge. Above all and in addition to their amazing technic