Select Page

New Data Exposed episode: It’s just SQL: Restoring a database to Azure SQL DB from backup

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

New Data Exposed episode: How to manage R packages in Azure SQL Database with sqlmlutils

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 connect and add/remove packages to Azure ... continue reading

New Data Exposed episode: Benefit from SQL VM Resource Provider when self-installing SQL Server on

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 Server on Azure IaaS. Follow ... continue reading

New Data Exposed episode: Switching an existing Azure SQL DB from Provisioned Compute to Serverless

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 video. Learn more ... continue reading

New Data Exposed episode: How to switch an existing Azure SQL Database to Hyperscale

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 Hyperscale. Follow Anna Thomas and ... continue reading

New Data Exposed episode: Restoring a database to Azure SQL DB from backup

In our 'It's just SQL' series we highlight how Azure SQL is very similar to what you are used to with SQL Server. In this video, Jeroen ter Heerdt shows how to restore a database to Azure SQL from a ... continue reading

New Data Exposed episode: Docs on Azure SQL Database Machine Learning Services

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 and https://docs.microsoft.com/en-us/azure/sql-database/sql-database-tutorial-predictive-model-prepare-data. Follow Anna Thomas and David Peter Hansen on Twitter at https://twitter.com/analyticanna and https://twitter.com/DavidPeterH ... continue reading

New Data Exposed episode: SQL Database Connectivity Explained

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. Read more at the following links: Connectivity Architecture: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connectivity-architecture Impact of removing Allow Access to ... continue reading

New Data Exposed episode: A conversation about SLA for Azure SQL Database

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 uptime and performance and are a key input ... continue reading

New Data Exposed episode: Exploding Bill of Materials using Graph Shortest Path

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 belongs to. This information can be useful ... continue reading