25 episodes

Data Exposed is all about data; relational and non-relational, on-premises and in the cloud, big and small. Get the inside scoop and join us as we demonstrate features, discuss the latest news and share our love for data technology including SQL Server, Azure Data Services like SQL DB, Cosmos DB, SQL DW, Data Factory, Databricks and more!

Data Exposed - Channel 9 Microsoft

    • Technology
    • 5.0 • 1 Rating

Data Exposed is all about data; relational and non-relational, on-premises and in the cloud, big and small. Get the inside scoop and join us as we demonstrate features, discuss the latest news and share our love for data technology including SQL Server, Azure Data Services like SQL DB, Cosmos DB, SQL DW, Data Factory, Databricks and more!

    • video
    How to Deploy Azure Arc Data Services Anywhere

    How to Deploy Azure Arc Data Services Anywhere

    In this episode of Data Exposed with Tolga Tekin, learn about the ability to deploy Azure Arc Data services via Kubernetes to any hardware platform. [00:55] What is Azure Arc[02:20] Azure data services anywhere at a glance[03:28] On-premises vs Azure[04:02] Azure Arc-enabled data services architecture[06:07] Management capabilities comparison by deployment model[08:22] Customer scenarios with Azure Arc[09:53] Example - managing different infrastructures at different locations[11:51] Getting started Resources:Azure Arc enabled SQL Server (preview)

    • 13 min
    • video
    Build SQL Database Projects Easily in Azure Data Studio

    Build SQL Database Projects Easily in Azure Data Studio

    In this episode with Drew Skwiers-Koballa, you will be introduced to a new experience for database development with the SQL Database Projects extension for Azure Data Studio. Whether you are familiar with SQL Server Data Tools (SSDT) or new to SQL projects, you can start editing and building SQL projects in Azure Data Studio on Windows, macOS, and Linux. [00:00] Introduction[01:22] SQL Database Projects[02:02] Azure Data Studio Notebook Concepts[03:35] SQL Database Projects extension for Azure Data Studio Demo[08:54] Getting started tipsResources:SQL Database Projects extension (Preview)Download and install Azure Data Studio

    • 10 min
    • video
    Infrastructure as Code and Azure – A Match Made in the Cloud (Part 2)

    Infrastructure as Code and Azure – A Match Made in the Cloud (Part 2)

    In the second part of this two-part series, Hamish Watson shows us how to use infrastructure as code to deploy an Azure Kubernetes systems cluster. To learn about the many ways to deploy an Azure SQL database, watch part one. [00:55] Demo: Deploying Azure Kubernetes systems cluster[07:50] Get started on AzureAbout Hamish Watson:Hamish Watson is a Microsoft Data Platform MVP and VMware Expert with a passion for efficient database and application deployment using DevOps methodologies. He has 20+ years of IT experience in managing and deploying large scale databases on SQL Server technologies. He has been managing SQL Server since SQL Server 2000 and pragmatic approaches to delivering business value to clients is his career passion. Educating and helping others learn is a driver for Hamish and he is a Director-At-Large on the PASS Board, international speaker, and a repeat guest lecturer at a local university.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 experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram

    • 9 min
    • video
    Azure SQL Capacity Planning: Scenarios

    Azure SQL Capacity Planning: Scenarios

    Capacity planning plays a critical role in migrating an existing application or designing a new one. In the final part of this three-part series with Silvano Coriani, we'll review various Azure SQL capacity planning scenarios, as well as review best practices and recommendations on what to use when. Part One - Azure SQL Capacity Planning: OverviewPart Two - Azure SQL Capacity Planning: DTU or vCore? [01:26] Greenfield development scenario[05:42] Existing applications on-prem or other clouds scenario[07:42] On-prem demo[12:01] Changes in existing Azure SQL DB apps scenario Resources:Choose between the vCore and DTU purchasing modelsvCore model overviewService tiers in the DTU-based purchase modelMigrate Azure SQL Database from the DTU-based model to the vCore-based modelQuery Performance Insight for Azure SQL DatabaseTroubleshoot with Intelligent Insights

    • 15 min
    • video
    Understanding Global VNet Peering Support for Azure SQL Managed Instance

    Understanding Global VNet Peering Support for Azure SQL Managed Instance

    To provide customers with an easier network configuration, all newly created virtual clusters will be enabled for access over global virtual network peering connections, now in general availability. This enables customers to pair managed instances in failover group configuration, in an easy and performant way, by simply connecting virtual networks in different regions. By utilizing global virtual network peering for your managed instances, you will save time through easy network configuration and offload your gateways from database replication traffic. Review this new feature and more in this episode with Srdan Bozovic. [00:42] Why Global VNet Peering Support is Important[01:39] Auto-failover group connectivity architecture[03:52] Take advantage of Global VNet Peering Support Resources:Virtual network peeringAuto-failover groups

    • 6 min
    • video
    Announcing Major Performance Improvements for Azure SQL Managed Instance

    Announcing Major Performance Improvements for Azure SQL Managed Instance

    In this episode of Data Exposed with Vladimir Ivanovic, he announces a set of major performance improvements for Azure SQL Managed Instances, which enable customers to migrate their more performance-hungry database workloads to Azure SQL Managed Instance. These improvements are automatically enabled for all existing and future Azure SQL Managed Instances at no extra charge, making Azure SQL Managed Instance the best fully-managed database platform for mission-critical workloads.[00:58] Azure SQL Managed Instance Performance Improvements[01:45] Improved log rate for SQL MI General Purpose[02:40] Improved log rate for SQL MI Business Critical[03:55] Pricing[04:30] Opportunities[05:22] Improvements are available now!Resources:Azure SQL Managed Instance Resource LimitsService Tier Characteristics

    • 6 min

Customer Reviews

5.0 out of 5
1 Rating

1 Rating

Top Podcasts In Technology

Listeners Also Subscribed To