Jeroen ter Heerdt

Azure Big Data

Drive Higher Utilization of Azure HDInsight Clusters with Autoscale

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 you should definitely watch this video to learn about how to leverage Azure HDInsight Autoscale feature to help you achieve higher cost efficiency. […]

Read More
Azure SQL Server

Auto-Failover Groups in Azure SQL

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 tutorial, which you can follow here: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-implement-geo-distributed-database?tabs=azure-powershell&WT.mc_id=dataexposed-c9-niner. To compare geo-replication and auto-failover groups, refer to the table here: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-business-continuity#compare-geo-replication-with-failover-groups&WT.mc_id=dataexposed-c9-niner. Time Index: [00:30] […]

Read More
Azure Data SQL Server

Load data from Azure Blob storage into Azure SQL

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. Time Index: [00:25] Background [01:25] Azure SQL Notebook in Azure Data Studio [02:06] Step 1: Create a table and schema [02:20] Step 2: Create a master key [02:37] Step 3: […]

Read More
Azure Data SQL Server

Intro to Azure CLI for Azure SQL

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.       Time Index: [00:00] Intro [00:38] Intro to the Azure Cloud Shell (ACS) [01:06] Switch between Bash and PowerShell in ACS [01:20] Azure CLI is cross-platform […]

Read More
Azure SQL Server

Intro to PowerShell notebooks for Azure SQL

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 them to manage your Azure SQL Databases and Managed Instances. Time index: [00:00] Intro [00:32] Notebooks in Azure Data Studio [01:20] PowerShell […]

Read More
Big Data Security

Overview: Big Data Cluster Security

In this video, get an overview of security features in Big Data Clusters.  More information on security in big data clusters: https://docs.microsoft.com/en-us/sql/big-data-cluster/concept-security?view=sql-server-ver15&WT.mc_id=dataexposed-c9-niner  Follow Jeroen ter Heerdt and Nellie Gustafsson on Twitter.

Read More
Azure Data

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: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tier-hyperscale.

Read More
Azure Data

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 backup (.bak) or BACPAC file.

Read More