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 • 2 Ratings

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
    Azure Synapse Data Explorer for Log & Telemetry Management

    Azure Synapse Data Explorer for Log & Telemetry Management

    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

    • 9 min
    • video
    Data Loading Best Practices on Azure SQL Database

    Data Loading Best Practices on Azure SQL Database

    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

    • 18 min
    • video
    Introduction to SQL Server 2022 (Ep.1)

    Introduction to SQL Server 2022 (Ep.1)

    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

    • 13 min
    • video
    What is exciting in Flexible Server for PostgreSQL on Azure

    What is exciting in Flexible Server for PostgreSQL on Azure

    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

    • 14 min
    • video
    Using Azure Synapse Serverless Pools for Data Engineering

    Using Azure Synapse Serverless Pools for Data Engineering

    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

    • 12 min
    • video
    Automating Diagnostic Notebooks with Azure Serverless Architecture

    Automating Diagnostic Notebooks with Azure Serverless Architecture

    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

    • 11 min

Customer Reviews

5.0 out of 5
2 Ratings

2 Ratings

Top Podcasts In Technology

You Might Also Like