Data Exposed (Audio) - Channel 9

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...

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...

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...

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]...

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]...

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 –...

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...

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...

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...

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]...

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...

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...

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...

When migrating your SQL Server workloads to Azure VM, there are literally hundreds of different VM sizes to choose from. Hopefully, you've seen our videos on sizing so you have an idea of the methodology we recommend to choose the right size, but what if you have a new SQL Server workload that you don't have metrics for? Where should you start? In part 4 of this eight-part series, we will highlight the Edsv4-series VMs and show you why we think they are the best VMs for your SQL Server...

Azure Monitor is a technology used to collect telemetry data from your Azure and on-premises environments. You can use Azure Monitor to improve performance and support the stability of your applications by identifying issues quickly. Azure Monitor includes Azure Metrics and Azure Logs to store telemetry data and track data in real-time and for historical analysis. Azure Metrics track values collected at regular intervals and can be used to describe the health of your resources at a...

In part two of this seven-part VM series, learn how to easily manage your Azure SQL virtual machines using the SQL IaaS Agent Extension with Pam Lahoud. Whether you are using an Azure Marketplace image or a custom image with a self-installed SQL Server, the SQL IaaS Agent Extension offers a number of features to discover and manage your SQL Server VMs quickly and easily through the Azure Portal. [00:44] What is SQL Server IaaS Agent Extension [01:30] Demo [05:23] Set-up [09:28] Getting...

Optimizing Virtual Machine storage is one of the most critical areas to focus on when architecting for performance with SQL Server on Azure Virtual Machines (VM). Virtual machines have input/output operations per second (IOPS) and throughput performance limits based on the virtual machine type and size as well as storage. In part one of this seven-part VM series, we'll cover how capping occurs at the virtual machine and storage levels and how caching can help remove the impact of these...

SQL Server object disks on Windows Server can be expanded at any time with no issues, but Linux doesn't quite work like that by default. In a situation where you run out of space, you're out of luck, unless you know some secrets about Linux. The mysterious Linux Logical Volume Manager must be used before you put anything on the disks to properly set up the disks so you can expand them in a pinch in the future. In this episode with David Klee, we're going to walk through how to use this...