Shows - Data-Exposed


What is exciting in Flexible Server for PostgreSQL on Azure[MP4] [0:14:45] [2021/10/29]
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,…


Using Azure Synapse Serverless Pools for Data Engineering[MP4] [0:12:37] [2021/10/27]
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…


Automating Diagnostic Notebooks with Azure Serverless Architecture[MP4] [0:11:22] [2021/10/22]
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…


Notebook Views in Azure Data Studio[MP4] [0:08:35] [2021/10/15]
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.…


Migrating to SQL: Introduction to Database Schema Conversion Toolkit (DSCT) (Ep. 9)[MP4] [0:14:00] [2021/10/08]
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…


How to find the right Azure SQL SKU for your SQL workloads[MP4] [0:21:54] [2021/10/01]
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…


SQL Server Failover Cluster Instances in Azure[MP4] [0:13:47] [2021/09/29]
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…


New Microsoft Learn Modules: Azure SQL IoT and Azure Arc-enabled data services[MP4] [0:11:26] [2021/09/24]
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…


How to Use Citus to Shard Postgres, for Performance & Scale[MP4] [0:11:18] [2021/09/17]
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…


Using Query Store Hints to Optimize Memory Grants, Improving Performance[MP4] [0:14:47] [2021/09/10]
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…


Azure SQL VM: Using PerfInsights to Evaluate Resource Health and Troubleshoot (Ep. 5)[MP4] [0:17:06] [2021/09/03]
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…


Managing SQL Server Agent Jobs with Notebook Jobs in Azure Data Studio[MP4] [0:14:36] [2021/09/01]
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…


Migrating to SQL: New Conversion Reports in SSMA (Ep. 7)[MP4] [0:14:15] [2021/08/27]
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…


Azure SQL VM: Get the best price-performance for your SQL Server workloads on Azure VM[MP4] [0:09:30] [2021/08/20]
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…


Azure SQL VM: Use Azure Monitor Metrics to Track VM Cache Health (Ep. 3) [MP4] [0:10:48] [2021/08/13]
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…


Azure SQL VM: Automate Management with the SQL Server IaaS Agent extension (Ep. 2)[MP4] [0:10:48] [2021/08/06]
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…


Azure SQL VM: Caching and Storage Capping (Ep. 1)[MP4] [0:16:33] [2021/07/30]
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…


SQL Server on Linux Storage Secrets[MP4] [0:11:22] [2021/07/28]
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,…


Scale Out Your Databases with Azure SQL Hyperscale Named Replicas[MP4] [0:21:47] [2021/07/23]
In this episode of Data Exposed with Davide Mauri, get an overview of the newly released feature for Azure SQL Hyperscale Database: Named replicas. Named replicas allow for incredible scalability,…


Using SQL Data Sync for Bidirectional Data Replication in SQL Server and Azure SQL DBs[MP4] [0:17:40] [2021/07/16]
SQL Data Sync lets you synchronize the data you select bi-directionally across multiple databases, both on-premises and in the cloud. In this Data Exposed episode with Mara-Florina Steiu, we will…


Five Practical Tips to Limitless Data Integration Using Azure Data Factory[MP4] [0:19:58] [2021/07/09]
Azure Data Factory (ADF) is a fully managed, easy-to-use, serverless data integration solution to ingest all your on-premises, hybrid, and multi-cloud data In this episode with Wee Hyong Tok, you will…


Track and Record Data Changes with Change Data Capture (CDC) in Azure SQL[MP4] [0:15:32] [2021/07/02]
Change data capture (CDC) records insert, update, and delete activity that applies to tables in SQL Server, Azure SQL Managed Instance or Azure SQL Databases. In this Data Exposed episode with…


Performance Tuning on Azure SQLDB and Readable Secondaries[MP4] [0:11:36] [2021/06/30]
Whether it's for reporting and offloading queries from production, there are things you need to keep in mind when using a Geo Replicated Azure SQL Database Readable Secondary. Discuss with MVP Monica…


Azure SQL Database Ledger - The power of blockchain with the simplicity of SQL[MP4] [0:17:14] [2021/06/25]
In this episode of Data Exposed with Jason Anderson, learn what the ledger feature of Azure SQL Database is and where using ledger can help enable digital trust in your data. There will also be some…


Migrating to SQL: Get Started with Azure SQL Readiness Assessments and Migrations from Azure Data…[MP4] [0:16:34] [2021/06/18]
In this episode with Rajesh Setlem, learn about the new integrated assessment and migration experience for Azure SQL from Azure Data Studio as well as how easy it is to get started.[01:00] Azure SQL…


Query Store Hints in Azure SQL Database[MP4] [0:16:21] [2021/06/11]
In this episode of Data Exposed, Joe Sack, Principal Group Program Manager of SQL Server engine and SQL Hybrid, and Anna Hoffman, Data & Applied Scientist, talk about a new way in Azure SQL…


How to Set up Azure Monitor for SQL Insights[MP4] [0:16:10] [2021/06/04]
SQL insights is a comprehensive solution for monitoring any product in the Azure SQL family. Learn about how to set up Azure Monitor for SQL insights with Alain Dormehl, Senior Program Manager at…


Migrating to SQL: Enabling Automatic Conversions for Partitioned Tables (Ep.5)[MP4] [0:14:08] [2021/05/28]
Looking for a way to preserve your Oracle partition strategy while modernizing Azure SQL? SQL Server Migration Assistant's new automatic partition conversion allows you to retain your current…


Disaster Recovery Options for Azure SQL Databases[MP4] [0:16:54] [2021/05/26]
Planning a proper disaster recovery solution is a critical piece of any infrastructure design, even when working in the cloud solutions like Azure SQL Database. Thankfully, the Azure architecture…


Migrating to SQL: Validate Migrated Object Using SSMA (Ep. 4)[MP4] [0:14:22] [2021/05/21]
Worried about your data validation post-migration to SQL Server or Azure SQL? Join us in this episode with Alexandra Ciortea and Xiao Yu to learn how you can create your leverage SQL Server Migration…


Migrating to SQL: Introduction to SSMA (Ep. 3)[MP4] [0:16:20] [2021/05/14]
Looking to leave Oracle behind? Watch the episode of Data Exposed with Alexandra Ciortea to find out how to ease into the migration journey by automating Oracle migrations to SQL Server or Azure SQL…


Migrating to SQL: Discover and Assess SQL Server Data Estate Migrating to Azure SQL (Ep.2)[MP4] [0:16:25] [2021/05/12]
Are you planning your SQL Server data estate migrations to Azure? Your first step is to discover and assess your SQL Server data estate and understand the Azure SQL readiness. Join Venkata Raj…


Migrating to SQL: Cloud Migration Strategies and Phases in Migration Journey (Ep. 1) [MP4] [0:13:17] [2021/05/07]
Understand the various cloud migration drivers, migration strategies, and various phases in the migration journey in this episode of Data Exposed with Venkata Raj Pochiraju. He'll also introduce…


Understanding the Benefits of Intelligent Query Processing[MP4] [0:09:37] [2021/04/30]
In this episode of Data Exposed with Kate Smith, she'll take you through the basics of why query processing matters, what it does, and how Intelligent Query Processing makes your workloads faster and…


Storage 101 for Azure SQL and SQL Server Engineers[MP4] [0:19:26] [2021/04/28]
Why is storage so important for Data Engineering? Learn how storage impacts the performance of your database solution. In this episode with MVP Argenis Fernandez, we will go over the basics of I/O,…


How to Parameterize Notebooks for Automation in Azure Data Studio[MP4] [0:13:46] [2021/04/23]
Jupyter Notebooks bring a wonderful capability to hand someone a single file that contains both code, and instructions on how to run that code. This is great and can be used in many different ways,…


Use Helm Charts from Windows Client Machine to Deploy SQL Server 2019 Containers on Kubernetes[MP4] [0:25:28] [2021/04/16]
Helm is the package manager for Kubernetes itself. Learn with Amit Khandelwal on Data Exposed how you can use Helm from your Windows machine to deploy SQL Server 2019 containers on Kubernetes all in…


Get Started with Accessing Azure Data Explorer using Apache Spark for Azure Synapse Analytics[MP4] [0:11:15] [2021/04/09]
In this episode of Data Exposed, Manoj Raheja shows us how to seamlessly integrate with Azure Data Explorer from Apache Spark for Azure Synapse Analytics.[01:13] Azure Data Explorer Overview[02:52]…


Get Started with the New Database Migration Guides to Migrate Your Databases to Azure [MP4] [0:12:29] [2021/04/07]
Database migrations often involve multiple phases, steps, and tools based on various scenarios and workload requirements. To help you migrate your databases to Azure, we have published a set of new…


Granular Permissions for Azure SQL Dynamic Data Masking[MP4] [0:08:42] [2021/04/02]
In this episode of Data Exposed with David Trigano and David Brookler, learn how you can leverage new capabilities in Dynamic Data Masking, help your organization prevent unauthorized access to…


Easy Ways to Refresh Tabular Models[MP4] [0:14:15] [2021/03/31]
In this episode with Gaston Cruz, he'll show you the options to process Azure Analysis Services models (Semantic Layer) connecting to an Azure SQL DB as a data source (using SSDT), and then create an…


How to Enable AD Authentication for SQL 2019 Containers in Less than 5 Minutes[MP4] [0:19:59] [2021/03/26]
We all know one of the most important and secure methods of authentication in SQL Server is through AD authentication. Learn today in this episode of Data Exposed with Amit Khandelwal how to enable AD…


What's New in Azure SQL Auditing[MP4] [0:09:59] [2021/03/19]
Azure SQL Auditing recently announced two new destinations now Generally available, and a new capability called Azure SQL Auditing of Microsoft support operations. In this episode, Anna Hoffman and…


How to Run SQL Assessment Checks in Azure SQL MI[MP4] [0:10:31] [2021/03/12]
SQL Assessment API provides a mechanism to evaluate the configuration of your SQL Server for best practices. The API is delivered with a ruleset containing best practice rules suggested by SQL Server…


How to Create Operational Analytics with Window Functions in Azure SQL - Part 3[MP4] [0:16:26] [2021/03/06]
Running complex aggregations and analytical functions on real-time operational databases is a powerful capability in Azure SQL. In the last part of this three-part series with Silvano Coriani, we will…


Optimize Existing Databases and Applications with Operational Analytics in Azure SQL - Part 2 [MP4] [0:20:52] [2021/02/26]
You don't necessarily need to change your data models and applications to run operational analytics workloads on Azure SQL. In part two of this three-part series with Silvano Coriani, we will explore…


How to Deploy Azure SQL Anywhere Using Azure Arc for Data Services[MP4] [0:14:09] [2021/02/24]
Join Data Platform MVP Ben Weissman as he explores Azure Arc for Data Services, Microsoft's solution to deploy services like Azure SQL to any cloud – including private clouds – using Kubernetes. He…


How Azure SQL Enables Real-time Operational Analytics (HTAP) - Part 1[MP4] [0:08:53] [2021/02/19]
Azure SQL enables hybrid transactional/analytical workloads for real-time operational analytics scenarios through a mix of in-memory and columnar database technologies. In the first episode of this…


Protect Your SQL Anywhere Using Azure Defender for SQL[MP4] [0:09:12] [2021/02/12]
SQL assets are critical resources and contain the most precious information a company owns, which makes them one of the preferred targets for attackers. Protecting them across the environments can be…


Testing App Cloud Readiness for Failover Resiliency with SQL Managed Instance[MP4] [0:14:56] [2021/02/05]
In this episode with Dani Ljepava, we will show you how to manually trigger a planned failover on SQL Managed Instance to test your applications for fault tolerance and will talk about best practices…


A Tour of SQL Workshops[MP4] [0:10:52] [2021/01/29]
Join Anna Hoffman and Buck Woody as they take a tour of the incredible learning resource the Microsoft Engineering team has put together. From labs to full hands-on workshops and much more, you'll…


SQL Server 2019 Always Encrypted: The Searchable Encryption![MP4] [0:19:25] [2021/01/27]
Always Encrypted in SQL Server 2019 is now in its second iteration which has added the ability to do pattern matching searches on encrypted data with the use of a technology called secure enclaves. …


Azure SQL Connectivity Performance Tips & Tricks[MP4] [0:10:42] [2021/01/22]
Azure SQL provides several connectivity options to cover different application scenarios. It is important to understand that they may have implications related to security and performance. In this…


Simplify Authentication with Managed Identities for Azure Resources[MP4] [0:09:22] [2021/01/15]
Managed Identities for Azure Resources can be leveraged to provide applications running on Azure Services with password-free access to Azure SQL databases and simplifying aspects like credential…


How to Troubleshoot Elastic Jobs in Azure SQL Database[MP4] [0:11:52] [2021/01/08]
In this episode of Data Exposed, Kate Smith shows us how to run and monitor Elastic Jobs using both PowerShell and T-SQL. [01:01] Demos More episodes in the Elastic Jobs for Azure SQL Series:Elastic…


Running & Monitoring Elastic Jobs in Azure SQL Database Using PowerShell and T-SQL[MP4] [0:13:03] [2020/12/31]
In this episode of Data Exposed, Kate Smith shows us how to run and monitor Elastic Jobs using both PowerShell and T-SQL. [01:33] PowerShell Demo[09:43] T-SQL Demo More episodes in the Elastic Jobs…


How to Create Elastic Jobs in Azure SQL Database Using T-SQL[MP4] [0:09:43] [2020/12/30]
In this episode of Data Exposed, Kate Smith walks us through the process of how to create Elastic Jobs for Azure SQL using T-SQL.[01:00] Demo[07:35] Where to create jobs[08:47] Advantages of using…


How to Create Elastic Jobs in Azure SQL Database Using PowerShell[MP4] [0:10:27] [2020/12/24]
In this episode of Data Exposed, Kate Smith walks us through the process of how to create Elastic Jobs for Azure SQL using PowerShell.[00:51] Why use PowerShell[01:47] DemoMore episodes in the Elastic…


The A to S of Azure Data Studio[MP4] [0:24:59] [2020/12/23]
With Azure Data Studio turning/turned 3, it is maturing just like a fine wine. Azure Data Studio is a game-changer for all Data Professionals. Join Warwick Rudd as he shows you what Azure Data Studio…


Understanding High-Performant, Hybrid Data Integration Using Azure Data Factory[MP4] [0:23:08] [2020/12/18]
Learn how you could load data into Azure from 90+ source connectors in Azure Data Factory. Azure Data Factory is a serverless data integration service that supports hybrid (on-premise/…


Azure SQL from the Edge to the Cloud[MP4] [0:10:40] [2020/12/16]
SQL Server started as a departmental database engine. It is now a modern data platform and a force in the industry. In this episode of Data Exposed with Bob Ward, learn how Microsoft is innovating SQL…


Use Azure Pipelines for Azure SQL Deployments[MP4] [0:25:53] [2020/12/11]
Many organizations have complex security and deployment requirements. In the second of this two-part series with Arvind Shyamsundar, we show you how to leverage Azure Pipelines features like…


How to Automate Disaster Recovery in SQL Server On-Prem[MP4] [0:19:01] [2020/12/09]
Are you prepared if a tornado filled with sharks destroys your primary data center? You may have backed up your databases, but what about logins, agent jobs or extended events? Join Chrissy LeMaire in…


Getting Started with DevOps for Azure SQL[MP4] [0:23:58] [2020/12/04]
"Databases-as-Code" is an important principle in improving predictability in developing, delivering, and operating Azure SQL databases. In the first part of this two-part series with Arvind…


Top Reasons Your On-premises SQL Server Instance Can Benefit from Azure[MP4] [0:10:59] [2020/12/02]
Learn how to leverage SQL Server on Azure virtual machine to improve your elasticity and business continuity for your on-premises SQL Server instances. Discover how the new benefits allow you to…


Top Reasons To Rehost your SQL Server on Azure Virtual Machines[MP4] [0:08:27] [2020/11/26]
Running SQL Server on Azure Virtual Machines provides a suite of free manageability capabilities that are available only on Azure, and which make it easier to run in a cost-effective, secured, and…


Azure SQL Database: Improving Performance Tuning with Automatic Tuning[MP4] [0:08:19] [2020/11/25]
One of the performance benefits of using Azure SQL Database is the ability for Azure SQL Database to automatically add and remove indexes from the database, based on the workload that is running…


New Software Assurance Benefits for SQL Server on Azure Virtual Machines[MP4] [0:10:39] [2020/11/20]
In this episode with Amit Banerjee, you will review new Software Assurance core benefits for high availability and disaster recovery can make running SQL Server on Azure virtual machine cheaper than…


Using Kusto Query Language (KQL) in Azure Data Studio[MP4] [0:11:48] [2020/11/18]
Azure Data Studio – a cross-platform client tool with hybrid and poly cloud capabilities - now brings KQL experiences for modern data professionals. In this episode with Julie Koesmarno, she will show…


What is Azure Arc Enabled SQL Managed Instance[MP4] [0:11:46] [2020/11/13]
In this episode of Data Exposed with Vin Yu, we'll introduce Azure Arc enabled SQL Managed Instance and provide an overview of its capabilities. We'll also share how you can get started with Azure Arc…


Leveling Up Your Azure SQL Database Deployments[MP4] [0:10:55] [2020/11/11]
The Basic, Standard, and Premium service tiers fulfill a lot of customers' needs. For some customers, though, the General Purpose, Business Critical, and Hyperscale service tiers offer additional…


What is Azure Arc Enabled PostgreSQL Hyperscale?[MP4] [0:09:14] [2020/11/06]
In this episode with Jean-Yes Devant, we'll introduce Azure Arc enabled PostgreSQL Hyperscale and provide an overview of its capabilities. We'll also share how you can get started with Azure Arc…


Understanding Backup Storage Redundancy in Azure SQL[MP4] [0:06:12] [2020/11/03]
Database backups are an essential part of any business continuity and disaster recovery strategy because they protect your data from corruption or deletion. In this episode of Data Exposed with Uros…


Understanding Azure Arc Enabled SQL Server[MP4] [0:20:01] [2020/10/30]
In this episode of Data Exposed with Sasha Nosov, learn how Azure Arc allows you to leverage Azure Services for your existing database applications hosted on-premises or in other public clouds,…


Creating Your First Azure SQL Database[MP4] [0:09:26] [2020/10/28]
You need to ensure that you are getting the maximum value and performance from your Azure SQL Database for minimum cost. Learn the differences between the Basic, Standard, and Premium tiers of Azure…


How to Assess Readiness of SQL Server Data Estate Migrating to Azure SQL[MP4] [0:16:09] [2020/10/23]
With many organizations trying to migrate to Azure, one of the critical and most important tasks is to assess existing on-premise SQL Server instances and identify the right target Azure SQL. Data…


How to Deploy Azure Arc Data Services Anywhere[MP4] [0:13:08] [2020/10/21]
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…


Build SQL Database Projects Easily in Azure Data Studio [MP4] [0:10:00] [2020/10/16]
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…


Infrastructure as Code and Azure A Match Made in the Cloud (Part 2)[MP4] [0:09:58] [2020/10/14]
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…


Azure SQL Capacity Planning: Scenarios [MP4] [0:15:39] [2020/10/08]
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…


Understanding Global VNet Peering Support for Azure SQL Managed Instance[MP4] [0:06:20] [2020/10/07]
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.…


Announcing Major Performance Improvements for Azure SQL Managed Instance[MP4] [0:06:38] [2020/10/02]
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…


Infrastructure as Code and Azure A Match Made in the Cloud (Part 1)[MP4] [0:11:59] [2020/09/30]
In the first part of this two-part series with Hamish Watson, we will look at the various methods available to deploy an Azure SQL database including PowerShell, Azure CLI and Terraform. Creating…


How to Secure Azure SQL Database by Setting Minimal TLS Version[MP4] [0:08:20] [2020/09/25]
In this episode with Rohit Nayak, we will cover the Minimal TLS Version setting for SQL Database. Customers can use these features to enforce a TSL version at the logical server level to meet their…


Hybrid Disaster Recovery Scenarios for SQL Server[MP4] [0:16:19] [2020/09/23]
In the conclusion to this two-part series with Allan Hirt, learn how Azure can be used to create disaster recovery solutions for your on premises Microsoft SQL Server instances and databases through…


How to Shut Off Public Connectivity to Azure SQL Database[MP4] [0:08:01] [2020/09/18]
In this episode with Rohit Nayak, we will cover the Deny Public Network Access setting for SQL Database. Customers can use this setting to block all public access via firewall rules and exclusively…


An Introduction to Microsoft Hybrid SQL Server Solutions[MP4] [0:14:27] [2020/09/16]
In the first episode of this two-part series with Allan Hirt, learn how to leverage on premises infrastructure for Microsoft SQL Server deployments while also taking advantage of the benefits of Azure…


Azure SQL Edge: Demo, Renewable Energy[MP4] [0:10:59] [2020/09/11]
In the final episode of this three-part series, Vasiya Krishnan walks us through a demo that shows us how to use Azure SQL Edge to build smarter renewable resources. For an introduction to Azure SQL…


Analyzing your Data Lake with Power BI and Azure Synapse[MP4] [0:10:59] [2020/09/09]
Azure Synapse has many features to help analyze data, and in this episode, Ginger Grant will review how to query data stored in a Data Lake not only in Azure Synapse but also visualize the data in…


Azure SQL Edge: Industry Use Cases & Customer Success[MP4] [0:09:48] [2020/09/04]
In part two of this three-part series, Vasiya Krishnan shares an example of how customers are using Azure SQL Edge as well as use cases. For an introduction to Azure SQL Edge, watch part one. [00:43]…


Deploying SQL Server 2019 in Kubernetes[MP4] [0:07:23] [2020/09/02]
Are you thinking about running SQL Server in Kubernetes and don't know where to start...are you wondering what you really need to know? If so, then this Data Exposed episode is for you. When deploying…


What is Azure SQL Edge[MP4] [0:06:48] [2020/08/28]
In part one of this three-part series, Vasiya Krishnan introduces Azure SQL Edge and its features that make it the optimized database engine for IoT Scenarios. In part two, Vasiya will review customer…


Learn How to Deploy SQL Server 2019 in Containers in Just Minutes[MP4] [0:11:45] [2020/08/26]
Containers are taking over, changing the way systems are developed and deployed...and that's not hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just…


Azure SQL Capacity Planning: DTU or vCore?[MP4] [0:15:54] [2020/08/21]
Capacity planning process plays a critical role in migrating to an existing application or designing a brand new one. In the second part of this three-part series with Silvano Coriani, learn about the…


Improve Query Performance by Managing Statistics in Azure SQL[MP4] [0:11:12] [2020/08/19]
Within Azure SQL maintenance tasks such as backups and integrity checks are handled for you, and while you may be able to get away with automatic updates keeping your statistics up-to-date, sometimes…


Azure SQL Capacity Planning: Overview[MP4] [0:09:20] [2020/08/14]
Whether migrating an existing application or designing a brand new one, capacity planning process plays a critical role. Learn how to navigate across Azure SQL Database options like hardware…


SQL Server 2019 Improves Scalar UDF Performance[MP4] [0:15:04] [2020/08/12]
Microsoft added several features to SQL Server 2019 that can improve performance without changes to code. One of these is T-SQL Scalar UDF Inlining. The use of UDFs is a red flag when tuning queries,…


Learning How to Transition Your SQL Server Skills to Azure SQL[MP4] [0:05:55] [2020/08/07]
Are you interested in learning how to translate your existing SQL Server expertise to Azure SQL including Azure SQL Database and Azure SQL Managed Instance? In this episode, Bob Ward, Anna Hoffman,…


How Resumable Indexes in SQL Server 2019 Makes Your Job Easier[MP4] [0:15:16] [2020/08/05]
Microsoft continues to push the envelope on feature capabilities with every release of SQL Server. One of the more prominent features that was released with Microsoft SQL Server 2019, is the ability…


Azure SQL Automated Backups (Part 2)[MP4] [0:16:29] [2020/07/31]
In the last part of this two-part series, Shreya Verma takes a deeper dive into backup options by showing us point-in-time, long-term retention, and geo restore demos. To learn about the different…


How to Use .NET Interactive Jupyter Notebooks in Daily Work-Life[MP4] [0:10:11] [2020/07/29]
Jupyter Notebooks are best known as tools for Data Scientists to display Python, Spark or R scripts. A Jupyter Notebook enables you to share words, images, code AND code results. .NET interactive…


Azure SQL - Automated Backups (Part 1)[MP4] [0:12:20] [2020/07/24]
In part one of this two-part series, Shreya Verma discusses the different backups options (point-in-time restore, long-term retention) Azure SQL provides and how to effectively manage them. [01:26]…


Benchmarking SQL Server and Azure SQL with WorkloadTools[MP4] [0:14:04] [2020/07/22]
Lifting and shifting your application to the cloud is extremely easy, on paper. The hard truth is that the only way to know for sure how it is going to perform is to test it. Benchmarking on-premises…


Azure SQL Bootcamp (LIVE with Bob Ward & Anna Hoffman)[MP4] [0:00:41] [2020/07/18]
August 17 - 20 [Click here for iCal Invite] Along with launching new content in August, we're also hosting a LIVE bootcamp over the course of four days where you can learn Azure SQL from Anna Hoffman…


Azure SQL and IoT [MP4] [0:12:34] [2020/07/17]
IoT is almost always associated with NoSQL database. This is quite understandable as its flexibility and specialization are great for ingesting IoT data. But what if that flexibility and performance…


The Benefits of Advanced Threat Protection in Azure SQL Database[MP4] [0:06:34] [2020/07/15]
One of the major benefits of Azure SQL Database is that the Azure platform provides additional protection for your database against SQL Injection attacks and Data Exfiltration, amongst other threats.…


Why Azure SQL is Best for Developers - Part 2 [MP4] [0:09:08] [2020/07/10]
In the second part of this two-part series, we discuss why Azure SQL is the best database in the cloud for developers, dive deeper into architectures, and review customer case studies to truly…


Big Data Clusters in a Nutshell[MP4] [0:13:41] [2020/07/08]
Join Ben Weissman on a tour through the possibilities of Big Data Clusters (BDC). He will give a brief overview about the general architecture and components of a BDC, followed by a demo where he will…


Why Azure SQL is Best For Developers - Part 1[MP4] [0:13:25] [2020/07/03]
Azure SQL has a lot of built-in features that make it the best database in the cloud for developers. In this first part of this two-part series, we'll discuss what those features are and which kinds…


Elastic Jobs in Azure SQL Database - Part 2[MP4] [0:09:15] [2020/06/26]
In the second part of this two-part video series, Kate Smith discusses what two things you should understand before beginning with Azure SQL Database Elastic Jobs: Idempotence, and Credentials. She…


Elastic Jobs in Azure SQL Database - Part 1 [MP4] [0:04:42] [2020/06/19]
In the first part of this two-part video series, Kate Smith gives an introduction to what Azure SQL Database Elastic jobs are, and when you should consider using them, as well as what products support…


Azure SQL Zone Redundant Configuration for High Availability[MP4] [0:05:54] [2020/05/29]
In this video, Emily Lisa and Anna Hoffman discuss how to make a database zone redundant in Azure SQL, and the High Availability benefits of the zone redundant configuration. [00:47] What is an…


Private Link for Azure SQL Database - Part 2[MP4] [0:18:01] [2020/05/21]
In the second part of this two-part video segment, Rohit Nayak dives deeper into the new capabilities for Azure SQL Database for Private Endpoints. Watch the first episode to understand what Private…


Private Link for Azure SQL Database - Part 1[MP4] [0:10:01] [2020/05/15]
In the first part of this two-part video segment, Rohit Nayak explains what Private Endpoint for Azure SQL Database is and how it relates to the overall connectivity story for Azure SQL. Additional…


Drive higher utilization of Azure HDInsight clusters with Autoscale[MP4] [0:13:00] [2020/05/08]
Are you looking to gain more control of the costs of operating your growing Azure HDInsight clusters? Are you interested in driving higher utilization of your Azure HDInsight clusters? If yes, then…


Auto-failover groups in Azure SQL[MP4] [0:07:06] [2020/05/01]
In this video, Anna Hoffman and Jeroen ter Heerdt discuss and show how to create auto-failover groups in Azure SQL using PowerShell notebooks and a Java application. This video was based on a…


Load data from Azure Blob storage into Azure SQL[MP4] [0:06:53] [2020/04/24]
In this video, Anna Hoffman and Jeroen ter Heerdt discuss and show one way for loading data from Azure Blob storage into Azure SQL Database. For more info, see…


Updating connection policies for Azure SQL[MP4] [0:06:25] [2020/04/17]
In this video, Anna Hoffman and Jeroen ter Heerdt discuss and show the connection policy options available and why you might choose one over the other. For more info, see:…


Intro to Azure CLI for Azure SQL[MP4] [0:05:14] [2020/04/11]
In this video, Anna Hoffman and Jeroen ter Heerdt discuss and show how you can get started with Azure CLI and the Azure Cloud Shell with respect to Azure SQL. For more info, see…


Intro to PowerShell notebooks for Azure SQL[MP4] [0:05:15] [2020/04/04]
In this video, Anna Hoffman and Jeroen ter Heerdt discuss and show PowerShell notebooks and Azure SQL inside Azure Data Studio. Learn how you can leverage PowerShell notebooks and other CLI tools in…


SQL Server Licensing: High Availability / Disaster Recovery Azure VM | Data Exposed[MP4] [0:04:46] [2020/03/27]
In this video, you will learn how to deploy recommended HADR architectures using SQL Server on Azure Virtual Machines with an optimal TCO using your Software Assurance Benefits.[00:00] Intro[00:31]…


SQL Server Licensing: High Availability / Disaster Recovery hybrid | Data Exposed[MP4] [0:05:52] [2020/03/20]
In this video, you will learn how to deploy recommended HADR architectures using Azure as a DR center with the best TCO using Software Assurance.[00:00] Intro[00:31] Licensing for HA/DR when using…


SQL Server Licensing: High Availability / Disaster Recovery on premises | Data Exposed[MP4] [0:06:11] [2020/03/13]
In this video, you will learn how to deploy recommended HADR architectures with the best TCO using Software Assurance.[00:00] Intro[00:32] Reminder of benefits for HA/DR[01:11] Common scenarios[02:14]…


SQL Server Licensing: High Availability / Disaster Recovery Benefits | Data Exposed[MP4] [0:06:09] [2020/03/06]
In this video, you will learn how you can get a better TCO for recommended SQL Server HADR architectures with your Software Assurance benefits. [00:00] Intro[00:30] Deploying SQL Server in High…


SQL Server Licensing: Big Data Clusters | Data Exposed[MP4] [0:09:02] [2020/02/28]
In this video, you will learn about how to license a Big Data Cluster in SQL Server 2019. The video also talks about the Software Assurance benefits that are available for Big Data Cluster…


How To: Creating a Persistent Log Buffer in SQL 2019[MP4] [0:09:00] [2020/02/19]
Persistent Log Buffers, sometimes referred to as tail of log caching, uses persistent memory to persist the database log buffer, eliminating bottlenecks that may occur on busy systems waiting for the…


Learn how to create your first SQL Notebook[MP4] [0:06:19] [2020/02/14]
You may have heard about SQL Notebooks in Azure Data Studio, now you can get started creating your very first SQL notebook. In this video, you will learn how to use text and code cells to build an…


Spark in Big Data Clusters | Data Exposed[MP4] [0:06:32] [2020/02/06]
We'll talk about what is Spark and using it in Big Data Clusters.More info: https://docs.microsoft.com/en-us/sql/big-data-cluster/tutorial-data-pool-ingest-spark?view=sql-server-ver15 [00:00]…


Big Data Cluster High Availability | Data Exposed[MP4] [0:11:54] [2020/01/30]
In this video we are going through the high availability options you have for the mission critical services running within the SQL Server Big Data Clusters. Find out more here: High AvailabilityHigh…


Accelerated Database Recovery | Data Exposed[MP4] [0:08:12] [2020/01/28]
In this video, we'll discuss Accelerated Database Recovery, and how it can solve many availability challenges with no operational or application changes. Find out more about ADR in our documentation. …


It's just SQL: CLR in Azure SQL Database Managed Instance[MP4] [0:05:57] [2020/01/24]
With the Common Language Runtime (CLR) hosted in Microsoft SQL Server (called CLR integration), you can author stored procedures, triggers, user-defined functions, user-defined types, and user-defined…


How to connect to Azure SQL Database from Azure Data Studio[MP4] [0:02:43] [2020/01/17]
Want to get started with Azure Data Studio (https://docs.microsoft.com/en-us/sql/azure-data-studio/download) but don't know where to begin? In this video, Anna Hoffman shows you how to get connected…


Deployment options for Azure SQL Database[MP4] [0:24:17] [2020/01/10]
Learn more about the deployment options for Azure SQL Database. More information: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-technical-overview [00:00] - Introduction[00:41] -…


It's just SQL: Collations in Azure SQL Database Managed Instance[MP4] [0:04:12] [2020/01/03]
You're probably familiar with Collations in SQL Server, but how do Collations change in Azure SQL Database Managed Instance? In this video, Anna Thomas and Colin Murphy cover a brief overview of…


What is SandDance?[MP4] [0:09:00] [2019/12/20]
In this video you will learn what is SandDance and how it provides unit visualizations of the data. Find out more.


Introducing SandDance: Data Visualization in Azure Data Studio[MP4] [0:07:26] [2019/12/19]
SandDance provides data visualization in the context of the data you are operating in and gives you interactive data exploration where you can quickly find pattern, trends and anomalies from the data.…


Query HDFS data inside SQL Server big data cluster[MP4] [0:07:16] [2019/12/12]
In this video, you will see how to use PolyBase in SQL Server 2019 big data cluster to query data from HDFS and join the data with other tables in the database. Read more about configuring PolyBase to…


Querying Data from Big Data Cluster Data Pool[MP4] [0:05:19] [2019/12/10]
In this session, we'll be covering how you can query data from Big Data Cluster Data Pools. Learn more about Data Pools.


Overview: Big Data Cluster Compute Pool[MP4] [0:05:35] [2019/12/06]
In this session, we'll be covering an overview of compute pools in Big Data Clusters. Learn more about Compute Pools.


Overview: Big Data Cluster Security[MP4] [0:13:51] [2019/12/03]
In this session, we'll be covering an overview of security features in Big Data Clusters. More information on security in big data clusters.


SQL Server 2019 Revealed Book[MP4] [0:06:52] [2019/11/26]
Bob Ward joins us to talk about his new book - SQL Server 2019 Revealed. Find it here: https://www.apress.com/us/book/9781484254189


Discovering, classifying, labeling & protecting SQL data now available for all[MP4] [0:14:00] [2019/11/22]
Learn all about the new data classification capabilities built into Azure SQL Database. Data Classification enables discovering, classifying, labeling & protecting the sensitive data in your…


Big Data Cluster Administration[MP4] [0:13:02] [2019/11/14]
In SQL Server 2019 Big Data Clusters, we ensure that management services embedded with the platform provide fast scale and upgrade operations, automatic logs and metrics collection, enterprise grade…


Introduction to Azure Data Studio Notebooks[MP4] [0:04:56] [2019/11/12]
Did you know Azure Data Studio has a rich notebook experience? Whether you need a Python, Pyspark, or a fully integrated SQL kernel, you can start creating and editing your notebooks from anywhere in…


Overview: Intelligent Query processing in SQL Server 2019[MP4] [0:05:42] [2019/11/07]
SQL Server 2019 introduces ground-breaking query performance enhancements under the Intelligent Query Processing family. To learn more, check out our documentation.These make up the latest on…


How (and When) To: Memory Optimized TempDB Metadata[MP4] [0:07:03] [2019/11/06]
Memory-Optimized TempDB Metadata is one of the new In-Memory Database features in SQL Server 2019. In this video, learn how to detect the TempDB metadata contention that this feature is intended to…


It Just Runs Faster: SQL Server 2019 TempDB Improvements[MP4] [0:08:23] [2019/11/05]
TempDB has historically been a major point of contention when it comes to scalability of highly-concurrent workloads in SQL Server. In this video, we'll review some of the most common pain points with…


SQL Server 2019 in Containers[MP4] [0:06:52] [2019/11/02]
SQL Server 2019 in containers are a fast way to get started with SQL Server 2019, and can be used throughout your data estate from development to production. SQL Server in containers are great because…


Introducing Data Virtualization[MP4] [0:06:16] [2019/11/02]
One of the most eagerly anticipated features in SQL Server 2019 is data virtualization. This video gives you a practical overview of the technology so that you can quickly get started with this…


Big Data Clusters deployment overview [MP4] [0:08:52] [2019/11/02]
Learn what options you need to consider for a successful deployment of a big data cluster and what are the end to end steps of a BDC deployment workflow. To learn more, check out our documentation:…


Unify your data lakes with HDFS tiering[MP4] [0:07:03] [2019/11/01]
HDFS Tiering is Microsoft's latest contribution to the Apache HDFS open source project. In this video, you will learn how to use the HDFS tiering feature in SQL Server big data clusters, to seamlessly…


Mark Russinovich on Azure SQL Database Edge, Hyperscale and beyond[MP4] [0:06:37] [2019/10/31]
Listen to Microsoft's CTO of Azure, Mark Russinovich talk about intelligent cloud, intelligent edge. Mark explains how we're building for edge scenarios with investments like Azure SQL Database Edge,…


Introducing SQL Server 2019[MP4] [0:13:04] [2019/10/29]
SQL Server 2019 is the latest version of the versatile and venerable SQL Server. This latest version continues to redefine SQL Server from a traditional relational database system to a data platform…


Mark Russinovich on future of Azure and databases | Data Exposed[MP4] [0:05:37] [2019/10/24]
Listen to Microsoft's CTO of Azure, Mark Russinovich, on the history and future of databases in Azure. Mark touches on Azure SQL Databases, Cosmos DB, and even blockchain databases. More resources:…


It's just SQL: Native Backup and Restore[MP4] [0:06:02] [2019/10/17]
Come see how easy it is to restore an existing SQL Database to Azure SQL Managed Instance. More information: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance.


Its just SQL: Restoring a database to Azure SQL DB from backup[MP4] [0:04:27] [2019/10/11]
In this video, Jeroen ter Heerdt shows how to restore a database to Azure SQL from a BACPAC file. Read more about importing an Azure SQL Database from BACPAC.


How to manage R packages in Azure SQL Database with sqlmlutils[MP4] [0:03:35] [2019/10/10]
Currently, Azure SQL Database has ML Services with R available in preview. In this video, Anna Hoffman gives a brief overview of how you can use an open source package called sqlmlutils to easily…


Benefit from SQL VM Resource Provider when self-installing SQL Server on Azure[MP4] [0:24:52] [2019/10/03]
In this video, we will talk how Azure SQL VM service helps migrating and modernizing of SQL workloads. We will explain and demo the benefits of the new SQL VM Resource Providers for self-installed SQL…


How to switch an existing Azure SQL Database from Provisioned Compute to Serverless[MP4] [0:02:08] [2019/09/26]
Once you're ready to switch a workload over to the serverless model, it is very easy to do. Watch Anna Thomas switch over a database she uses for demos to the serverless compute tier in this quick…


How to switch an existing Azure SQL Database to Hyperscale[MP4] [0:04:52] [2019/09/19]
Hyperscale is a new tier for Azure SQL Database. In this video Anna Thomas and Jeroen ter Heerdt cover how to switch an existing Azure SQL Database to this new, scalable, tier. More information about…


Docs on Azure SQL Database Machine Learning Services[MP4] [0:11:08] [2019/09/06]
Overview of the new documentation on Azure SQL Database Machine Learning Services (Preview). More resources: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-quickstart-r-create-script…


Demo Vnet Firewall Rules for SQL Database[MP4] [0:13:32] [2019/08/29]
This session does a deep dive into one of the network access controls for Sql Database i.e. setting up Vnet firewall rules to restrict access from a specific Vnet and subnet. Read more about Vnet…


Azure SQL unified Azure portal experience[MP4] [0:07:38] [2019/08/21]
The new centralized experience brings together SQL Server offerings inside of Azure, including databases, managed instances, and SQL VMs. We now have a centralized location for discovering, creating,…


Data Exposed | SQL Database Connectivity Explained[MP4] [0:19:04] [2019/08/15]
This session explains the basics of how connectivity works for SQL Database and how you can use network access controls to securely access SQL Database. Note: At 7:33 during the video, it is said that…


A conversation about SLA for Azure SQL Database[MP4] [0:20:52] [2019/08/08]
When data is the lifeblood of your business, you want to ensure your databases are reliable, secure and available when called upon to perform. Service level agreements (SLA) set an expectation for…


Exploding Bill of Materials using Graph Shortest Path [MP4] [0:12:24] [2019/08/01]
In this demo, we will show how you can explode a Bill of Materials using Graph Shortest Path function, introduced with SQL Server 2019 CTP3.1, to find out which BOMs/assemblies a given product/part…


Data Migration Assistant[MP4] [0:11:44] [2019/07/26]
Learn how you can leverage our Data Migration Assistant tool to get the Azure SQL Database readiness at scale.More information:…


Data Migration life-cycle[MP4] [0:13:23] [2019/07/20]
Understand the cloud migration journey, strategy, Leverage Data migration tools and Azure Database Migration Service for successful database migrations to Azure Data.More information:Database…


Azure Databricks introduces R Studio Integration[MP4] [0:20:51] [2018/08/01]
In this episode we talk to Yatharth Gupta, Principal Program Manager for Azure Databricks, about the newly introduced integration with R Studio. For data scientists looking at scaling out R-based…


Azure Data Factory new features and integration with Azure Databricks[MP4] [0:16:18] [2018/08/01]
Azure Data Factory went into General Availability with new features, alongside a cool new UI, giving users the ability to orchestrate and monitor pipelines in intuitive ways. What's even more…


Introducing ML Services 9.3 in Azure HDInsight[MP4] [0:13:41] [2018/08/01]
In this episode, we chat with Katherine Kampf, PM on Azure Big Data team, about the newly introduced ML Services in Azure HDInsight. ML Services includes highly scalable, distributed set of algorithms…


mssql-cli, an open source and cross-platform CLI for SQL Server[MP4] [0:16:03] [2018/05/04]
This week's episode of Data Exposed welcomes Abhi Abhishek to the show! Abhi is a Software Engineer in the SQL Server engineering group focusing on SQL Tools. Today he is in the studio to talk about…


AtScale on Azure HDInsight[MP4] [0:09:48] [2018/01/31]
Azure HDInsight is a fully-managed cloud service that makes it easy, fast, and cost-effective to process massive amounts of data. Use the most popular open-source frameworks such as Hadoop, Spark,…


Dataiku DSS on Azure HDInsight for Data Science[MP4] [0:07:49] [2018/01/31]
Azure HDInsight is a fully-managed cloud service that makes it easy, fast, and cost-effective to process massive amounts of data. Use the most popular open-source frameworks such as Hadoop, Spark,…


H20.ai on Azure HDInsight[MP4] [0:04:11] [2018/01/24]
Azure HDInsight is a fully-managed cloud service that makes it easy, fast, and cost-effective to process massive amounts of data. Use the most popular open-source frameworks such as Hadoop, Spark,…


Cask CDAP on Azure HDInsight[MP4] [0:04:32] [2018/01/24]
Azure HDInsight is a fully-managed cloud service that makes it easy, fast, and cost-effective to process massive amounts of data. Use the most popular open-source frameworks such as Hadoop, Spark,…


StreamSets on Azure HDInsight[MP4] [0:07:06] [2018/01/17]
Azure HDInsight is a fully-managed cloud service that makes it easy, fast, and cost-effective to process massive amounts of data. Use the most popular open-source frameworks such as Hadoop, Spark,…


Creating custom applications on Azure HDInsight[MP4] [0:07:58] [2018/01/17]
Azure HDInsight is a fully-managed cloud service that makes it easy, fast, and cost-effective to process massive amounts of data. Use the most popular open-source frameworks such as Hadoop, Spark,…


How to use Tableau with SQL Server, R and Python[MP4] [0:19:04] [2018/01/13]
How to use Tableau with SQL Server, R and Python BlogTableau Solutions on AzureMML Server BlogStart a FREE Azure Trial


Extending Azure HDInsight to install open source components[MP4] [0:05:49] [2018/01/10]
Seamlessly integrate with the most popular Big Data solutions with a single-click. Easily extend your cluster capabilities with applications, edge nodes, and customize using script actions. In this…


Azure HDInsight Application Platform Overview[MP4] [0:07:31] [2018/01/10]
Azure HDInsight is an Apache Hadoop distribution powered by the cloud. This means that it handles any amount of data, scaling from terabytes to petabytes on demand. Spin up any number of nodes at any…


Track and remediate potential database vulnerabilities with SQL Vulnerability Assessment[MP4] [0:13:29] [2017/11/09]
This week's episode of Data Exposed welcomes Ronit Reger to the show! Ronit is a Senior PM on the SQL product team focusing on SQL security and data privacy, and today she is in the studio to talk…


Introducing the new Import Flat File Wizard in SSMS 17.3[MP4] [0:11:29] [2017/10/18]
This week's episode of Data Exposed welcomes Alan Yu to the show! Alan Yu is a PM in the SQL Server engineering group focusing on SQL Tools, and today he is in the studio to talk about the latest SQL…


Enterprise HDInsight Monitoring with Operations Management Suite[MP4] [0:26:58] [2017/09/12]
This week's episode of Data Exposed Scott welcomes Ashish Thapliyal to the show. Ashish is a Senior PM on the HDInsight team and is in the studio today to discuss monitoring HDInsight for the…


TDE with Bring Your Own Key Support in Azure SQL DB and DW[MP4] [0:19:34] [2017/08/29]
This week's episode of Data Exposed Scott welcomes Rebecca Zhang to the show. Rebecca is a PM on the SQL Server team and is in the studio today to discuss encryption at rest with key hierarchy in…


SQL Server 2017 Adaptive QP[MP4] [0:23:48] [2017/08/10]
This week's Data Exposed show welcomes Joe Sack into the Channel 9 studio. Joe is a Principal PM on the SQL Server team, and is in the Channel 9 studios today to show us the awesome Adaptive Query…


SQL Server 2017 Built-in Diagnostics[MP4] [0:26:42] [2017/08/08]
Bob Ward and Parikshit Savjani (Parik) are in the Data Exposed Channel 9 studio today to talk about and show off the best built-in diagnostics in the industry. It's Bob Ward, so of course we're…


Connecting On-premises Hadoop to Azure Data Lake Store[MP4] [0:18:58] [2017/08/01]
This week's Data Exposed show welcomes Cathy Palmer into the Channel 9 studio to show how to connect an on-premises Hadoop cluster to Azure Data Lake Store in 3 easy steps! [01:38] - Azure Data Lake…


Azure SQL Database Elastic Pools and Elastic Jobs[MP4] [0:24:22] [2017/07/25]
This week's episode of Data Exposed Scott welcomes two awesome individuals, Torsten Grabs and Morgan Oslake (Principal PM in the SQL product group), to talk about the great topic of Azure SQL Database…


Spark Performance Tuning - Part 4[MP4] [0:26:38] [2017/07/18]
This week's Data Exposed show welcomes back Maxim Lukiyanov to talk more about Spark performance tuning with Spark 2.x. Maxim is a Senior PM on the big data HDInsight team and is in the studio today…


Setting up SQL Server High-Availability between Windows and Linux with SQL Server 2017[MP4] [0:25:52] [2017/07/13]
Tobias and Slava are back in the studio in this awesome video to show high-availability with SQL Server 2017 between Windows and Linux. After spending a few minutes discussing the background, thought…


SSMS: Your one-stop-shop for SQL Server Performance Troubleshooting[MP4] [0:31:18] [2017/07/11]
Today's guest on the Data Exposed show is Pedro Lopes, a PM in the SQL Server TIGER team, and he's in the studio today to show off some of the things his team has been working on over the last year to…


Spark Performance Tuning - Part 3[MP4] [0:33:08] [2017/07/08]
This week's Data Exposed show welcomes back Maxim Lukiyanov to talk more about Spark performance tuning with Spark 2.x. Maxim is a Senior PM on the big data HDInsight team and is in the studio today…


Power BI Embedded with the JavaScript SDK[MP4] [0:17:29] [2017/06/29]
Ran and Arina are back in the studio (actually, they never left :D ) to follow up on their first video to discuss the PowerBI JavaScript SDK. This SDK is a client-side API allows you to communicate…


Spark Performance Tuning - Part 2[MP4] [0:35:03] [2017/06/28]
This week's Data Exposed show welcomes back Maxim Lukiyanov to talk more about Spark performance tuning with Spark 2.x. Maxim is a Senior PM on the big data HDInsight team and is in the studio today…


Setting up and Getting Started with Power BI Embedded[MP4] [0:23:07] [2017/06/23]
Today's Data Exposed show welcomes Ran Breuer and Arina Hantsis to the studio. Both Ran and Arina are Software Engineers on the Power BI team, and have flown in from Israel to talk about how to get…


TPC-H Benchmarking with SQL Server on Linux[MP4] [0:28:12] [2017/06/16]
Tobias and Slava are back in the studio to showcase the work they have been doing on the TPC-H benchmarking. As normal, no slides, all demo, and Slava and Tobias spend nearly 30 minutes show us how…


Spark Performance Tuning - Part 1[MP4] [0:26:44] [2017/06/02]
This week's Data Exposed show welcomes back Maxim Lukiyanov to kick off a 4-part series on Spark performance tuning with Spark 2.x. Maxim is a Senior PM on the big data HDInsight team and is in the…


Understanding the U-SQL Batch Job Execution Lifetime[MP4] [0:30:20] [2017/05/16]
Saveen Reddy, Principal PM Manager in the Big Data team, is back in the Channel 9 studios for the week's Data Exposed show to talk about U-SQL batch query execution. This is awesome, because Saveen…


What Is New in U-SQL for March '17[MP4] [0:16:21] [2017/05/02]
Once again the Data Exposed show welcomes back Michael Rys, Principal PM in the Big Data group, to give us an update of U-SQL. At the [01:25] mark Michael lists the features in U-SQL that have been…


MSSQL Extension for VS Code[MP4] [0:29:51] [2017/04/26]
This week's episode of Data Exposed welcomes Kevin Cunnane to the show to talk about the Big Data Partner Program. Pranav is a Senior Software Engineering Manager in the SQL Server tools team. No…


Debugging C# user code in a U-SQL query locally[MP4] [0:13:15] [2017/04/06]
I LOVE videos like this, and so will you. Short, but powerful with no slides and all demo. Saveen Reddy, Principal PM Manager in the big data team at Microsoft comes in to show how easy it is to debug…


App Compatibility with SQL Server on Linux[MP4] [0:25:07] [2017/04/04]
This week's episode of Data Exposed welcomes Vin Yu to the show! Vin is a PM in the SQL Server engineering group focusing on SQL Server on Linux, and today he is in the studio to talk about and demo…


SQL tools for Linux, Mac OS, and Windows[MP4] [0:24:28] [2017/02/08]
This week's episode of Data Exposed is another episode I am extremely excited about! With all of the great work being done on SQL Server, it is a pleasure to welcome Sanjay Nagamangalam to the show!…


R Services in SQL Server 2016[MP4] [0:21:18] [2017/02/01]
This week's Data Exposed show is one I have been waiting to do for a long time. I'm excited to have Umachandar Jayachandran, or UC, in the studio today to talk about R services in SQL Server 2016, a…


Big Data Partner Program[MP4] [0:13:19] [2017/01/25]
This week's episode of Data Exposed welcomes Pranav Rastogi the show to talk about the Big Data Partner Program. Pranav is a Principal PM in the Big Data team and he looks after the Hadoop ecosystem…


Memory Optimizing Temporary Data Structures[MP4] [0:38:44] [2017/01/18]
Our man Jos is back again, and this time he is talking about memory optimizing temporary data structures. And true to form, Jos brings in the whiteboard and spends 35 minutes walking us through how to…


HDInsight Compliance[MP4] [0:15:31] [2017/01/11]
Today's Data Exposed show welcomes Alice Kupcik, a Senior PM in the Big Data team, to talk about compliance in Azure HDInsight. Building on the HDInsight security show published recently with Saurin…


Introducing the Database Experimentation Assistant[MP4] [0:19:17] [2016/12/02]
In the Channel 9 studios this week is Harini Gupta, a Senior Program Manager on the SQL Server SEALS team, and Dinek Kothottil, a Senior Engineering Manager on the SQL Server SEALS team. Both Harini…


Data Migration Assistant 2.1 Update[MP4] [0:24:44] [2016/11/30]
The things the SQL engineering team can do in a month! We're excited to welcome back to the Data Exposed show Akash Verenkar, a Senior Engineering Manager in the SQL team, and brings with him today…


SQL Server Columnstore Indexes Scripts Library[MP4] [0:37:02] [2016/11/23]
It is an honor and privilege to welcome to the show Niko Neugebauer, a Data Platform MVP from Portugal who was in town for the Microsoft MVP Summit, and we were lucky enough to get him into the Data…


Optimizing HBase Performance in HDInsight[MP4] [0:24:35] [2016/11/04]
This week's episode of Data Exposed welcomes Ashish Thapliyal to the show to talk about how to get better performance from your HBase in HDInsight. Ashish is senior PM in the Big Data HDInsight group…


More with SQL Server on Linux[MP4] [0:18:53] [2016/11/02]
In this SQL on Linux follow-up episode of Data Exposed, Scott welcomes back Tobias Ternstrom and Slava Oks to the show us more of SQL Server on Linux. Linux. Again, no slides, just pure demos. Last…


Latency and Durability with SQL Server 2016[MP4] [0:27:11] [2016/10/25]
Data Exposed is pleased to welcome Jos de Bruijn back, and today he is back to talk specifically about In-memory OLTP in SQL Server 2016. Jos is a Senior PM on the SQL team and today dives right in…


First Look at the new SQL Server Data Migration Assistant[MP4] [0:19:28] [2016/10/12]
In this episode of Data Exposed, Scott welcomes to the show Shamik Ghosh, Senior PM and Akash Verenkar, Senior Software Engineering Manager, both of whom are on the Data Migration team in the Data…


SQL Server 2016 In-memory OLTP[MP4] [0:30:07] [2016/09/20]
Data Exposed has had Jos de Bruijn in the studio a couple of times, and today he is back to talk specifically about In-memory OLTP in SQL Server 2016. Jos is a Senior PM on the SQL team and today…


U-SQL Updates - What's New and What's Changed[MP4] [0:24:25] [2016/09/13]
The Data Exposed show welcomes back Michael Rys, Principal PM in the Big Data group, to give us an update of U-SQL. At the 1:25 mark Michael discusses some of the new features in U-SQL since the…


SQL Server 2016 with StretchDB, Temporal, and AlwaysEncrypted[MP4] [0:15:04] [2016/08/23]
It's a pleasure to welcome Anthony Van Gemert to the Data Exposed show today. Today's show is a real treat as Anthony, a PM in the SQL Server engineering team, spends the entire show in 1 awesome demo…


Accelerating SQL Server 2016 peformance with Persistent Memory in Windows Server 2016[MP4] [0:20:56] [2016/08/11]
In this episode of Data Exposed, Scott welcomes Lindsey Allen, SQL Server Partner Group PM, and Tobias Klima, Windows Storage PM, to the show to discuss how persistent memory in Windows Server 2016…


SQL Server 2016: It's Just Faster[MP4] [0:15:22] [2016/08/09]
This week's episode of Data Exposed welcomes back Bob Ward and newcomer Bob Dorr to the show. Bob Ward, Principle PM Architect in the SQL Server group, and Bob Dorr, Principle Software Engineer in the…


JSON in Hadoop and Hive[MP4] [0:23:17] [2016/06/14]
In this episode of Data Exposed Scott welcomes Rashim Gupta to the show. Rashim, a Senior Program Manager in the SQL Server Big Data group is in the studio today to show us how to query JSON in Hadoop…


SQL Server 2016 General Availability Announcement with Rohan Kumar[MP4] [0:10:59] [2016/06/02]
In this special episode of Data Exposed we welcome Rohan Kumar to make the exciting announcement that SQL Server 2016 is generally available as of today! In this brief but exciting 10 minute video,…


BI on HDInsight with AtScale[MP4] [0:25:15] [2016/04/23]
Today's episode of Data Exposed Scott welcomes to the show Joshua Klahr, VP Product at AtScale. AtScale bridges the gap between business users and their data by making Business Intelligence on top of…


PolyBase Scale-out Groups in SQL Server 2016[MP4] [0:19:44] [2016/03/23]
In this episode of Data Exposed Scott welcomes to the show Casey Karst, a Program Manager in the SQL Server group, to talk about PolyBase scale-out groups in SQL Server 2016. Building on this show…


SQL Server 2016 and JSON Support[MP4] [0:38:07] [2016/03/15]
In this episode of Data Exposed Scott welcomes to the show Jovan Popovic to the show, Program Managers in the SQL Server group. Today Jovan is in the studio all the way from the Microsoft offices in…


Giving Hadoop a Microsoft-class UI with HDInsight and Datameer[MP4] [0:24:24] [2016/03/02]
In today's episode of Data Exposed, Scott welcomes Andrew Brust to the show. Andrew is Senior Director of Market Strategy and Intelligence at Datameer, whose product turns HDInsight into a…