Sunday, April 19, 2020

Azure Databricks - Accessing Data Lake using Azure Active Directory Credentials

This video discusses the way of accessing Azure Data Lake Gen 2 through Azure Databricks, using Azure Active Directory Credentials. Following are discussed;
  • Ways of Accessing ADLS Gen 2
  • Enabling Azure Data Lake Credential Passthrough
  • Demo: Accessing ADLS Gen 2 in Azure Databricks
    • Creating an Azure Databricks workspace
    • Configuring Standard Cluster for AAD Credentials
    • Configuring High Concurrency Cluster for AAD Credentials

Azure Databricks - Accessing Data Lake - Using a Service Principal

This video discusses the ways of accessing Azure Data Lake Gen 2 in Azure Databricks, specifically using a Service Principal. Following are discussed in detail;
  • Ways of accessing Azure Data Lake Gen 2
  • Creating a Service Principal for accessing Azure Data Lake
  • Access using Role-based access control
  • Access using ACL-based access control

Wednesday, April 8, 2020

Sending Emails from Azure SQL Database - YouTube Video

This video focuses on sending emails for operations related to Azure SQL databases. Following are discussed and demonstrated;

  • Possibilities of tracking changes in Azure SQL Database for sending emails
  • Setting up an Azure SendGrid account
  • Setting up an Azure Logi Apps for sending emails

Data Science with SQL Server Machine Learning Services - YouTube Video

This video discusses performing data science experiments in SQL Server using Python. Setting up the environment, training, storing models and consuming trained models stored in the database are discussed with a demonstration.


Automating Resume and Pause of Azure Analysis Services - YouTube Video

This video discusses how to automate starting and stopping Azure Analysis Services using Azure Automation Account. Following are demonstrated;
  • Create Azure Automation Account
  • Import libraries required
  • Create a PowerShell Runbook
  • Schedule the Runbook