Advertise on podcast: Data Exposed - Channel 9

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

Looking for the next Microsoft Learn modules to complete? Bob Ward, Buck Woody, and Anna Hoffman give you a run-down of Microsoft Learn, the learning paths they've launched, and the two new Microsoft Learn modules - Azure SQL IoT and Azure Arc-enabled data services - they've been working on that are now live. Start learning today![00:33] Introductions[00:52] SQL Workshops[02:05] About Microsoft Learn[02:38] Microsoft Learning Path - Build serverless, full stack applications in Azure[03:28] Microsoft Learning Path - Azure SQL Fundamentals[05:11] Microsoft Learn Module - Introduction to Azure Arc-enabled data services[07:26] Microsoft Learning Path - Azure Arc[08:33] Microsoft Learning Module - Deploy IoT Solutions with Azure SQL Database[09:43] Getting startedResources:Microsoft LearnSQL Server and Azure SQL Labs and WorkshopsMicrosoft Learning Path - Build serverless, full stack applications in AzureMicrosoft Learning Path - Azure SQL FundamentalsMicrosoft Learn Module - Introduction to Azure Arc-enabled data servicesMicrosoft Learning Path - Manage hybrid infrastructure with Azure ArcMicrosoft Learning Module - Deploy IoT Solutions with Azure SQL DatabaseAzure Arc Jumpstart

If you're looking to scale your Postgres database, the Citus open-source extension to Postgres makes sharding simple. And Citus is available on Azure as a managed service, too. Join Claire Giordano on the Citus team to learn about how Citus uses the Postgres extension APIs to shard Postgres—and the best way to get started with Citus. [01:24] What is Citus[03:40] What applications sharding Postgre with Citus[05:34] How large can a Citus cluster get?[07:45] When to use Citus[08:45] Getting statedResources: Citus open source repo on GitHubGetting Started with Citus resourcesCitus on Azure documentationCitus monthly newsletterVideo: How Citus Distributes PostgreSQL

Query store hints enables changing query plan shapes without modifying application code. In this episode of Data Exposed with Denzil Ribeiro, we will look at an example of improving the performance of bulk loading data using query store hints. [00:30] Introduction Denzil Ribeiro[01:40] Memory Grants Overview [02:49] Demo[13:05] Getting Started Resources:Performance impact of memory grants on data loads into Columnstore tables

It is important to ensure that your Azure Virtual Machine is meeting the performance and stability standards you have established in your organization. PerfInsights can help identify and report on your Azure SQL VM health and provide references to how administrators can mitigate the risks. PerfInsights is a self-help diagnostics tool that can be run through the portal or as a standalone tool that collects diagnostic data, produces analytic reporting, summarizes system information, and produces a system log output that can help troubleshoot virtual machine performance problems in Azure for various scenarios including SQL Server, Windows OS, Linux, Azure storage, and more. PerfInsights allows administrators to run quick analysis, produce a benchmark result, analyze slow virtual machines, analyze Azure files, and perform advanced scenarios including xperf, network tracing, storport tracing, perf counter traces, and diskspeed benchmarks. In part five of this seven-part series, we will analyze PerfInsights captures to review SQL Server findings, review storage analysis against Azure storage thresholds, resource reporting, and will review the system summary information that can make it a lot easier to document your Azure SQL Virtual Machine environment. [00:58] PerfInsights Overview[02:20] Demo[15:48] Getting started Resources:Advanced performance analysis: https://aka.ms/perfinsights/advancedAzure Files analysis: https://aka.ms/perfinsights/azurefilesQuick performance analysis: https://aka.ms/perfinsights/quickPerformance analysis: https://aka.ms/perfinsights/vmslowBPCheck - SQL Best Practices and Performance checks: http://aka.ms/BPCheckPremium storage disk sizes: https://docs.microsoft.com/en-us/azure/virtual-machines/premium-storage-performance#premium-storage-disk-sizesAzure SQL Virtual Machine Reimagined Series: https://aka.ms/azuresqlvmyt

As database professionals, we all know how to manage SQL Server Agent jobs using SQL Server Management Studio (SSMS), TSQL, and PowerShell. With Azure Data Studio and SQL Server Agent extension, we have new tools to create, maintain and manage SQL Agent jobs using Notebook. These are called Notebook Jobs. Once you successfully execute a Notebook job manually or via schedule, each run's results are saved into a separate Notebook, which you can easily share with others. In this episode of Data Exposed: MVP Edition, Taiob Ali will walk you through every step of Notebook Jobs.[00:31] About Taiob Ali[01:34] Benefits of SQL Server Agent Jobs[04:50] Demo[T012:30] Getting Started Resources:Github About Taiob Ali:Taiob Ali, Microsoft Data Platform MVP, is an accomplished technical leader with a proven record of success. During his last 15 years, he has worked with the Microsoft Data Platform and MongoDB, both on-premises and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare. Taiob has hands-on experience managing large database projects, including massive data migration, intricate process design, testing and deployment, performance tuning, and long-term capacity planning. Taiob is currently working at "GMO LLC" as Database Solutions Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual chapters, Data Saturdays, and Azure conferences. He is a board member of New England SQL Server User Group, founder of 'Database Professionals Virtual Meetup Group', and organizer of Boston Data Saturday. 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 al

Reports have never looked so great! The new features in SQL Server Migration Assistant help you easily identify automatically converted objects and estimate the effort associated with manually converted objects. Incorporate your findings into your migration process and accelerate your journey to Azure SQL. [00:30] Introductions[01:46] Importance of SSMA reports[02:42] Demo: Challenges that led to enhancements[06:58] Demo: New, enhanced reports Resources:SQL Server Migration Assistant - SQL Server | Microsoft DocsAzure Database Migration Guides | Microsoft DocsMigrating to SQL series playlist