All About SQL

Azure Databricks and Azure Key Vault

• by Arun Sirpal

• All About SQL

The key vault should always be a core component of your Azure design because we can store keys, secrets, certicates thus abstract / hide the true connection string within...

2020-10-28

4 reads

Azure Databricks – Pin Cluster

• by Arun Sirpal

• All About SQL

Before discussing why you would want to pin a cluster it would be useful to understand the different states of a cluster. We can have: I usually have “auto...

2020-10-22

7 reads

Azure Databricks to Power BI

• by Arun Sirpal

• All About SQL

A very common approach is to query data straight from Databricks via Power BI. For this you need Databricks token and the JDBC address URL. This is found within...

2020-10-20

11 reads

Azure Databricks – The Notebook

• by Arun Sirpal

• All About SQL

Data engineers, pipe line developers, general data enthusiasts will be spending most of their time within a notebook. Here you develop your code, nice visualisations and commentary boxes are...

2020-10-14

14 reads

Azure Databricks Overview

• by Arun Sirpal

• All About SQL

I have spent many long weekends getting stuck into Azure Databricks, plenty of time to understand the core functionality from mounting storage, streaming data, knowing the delta lake and...

2020-10-06

137 reads

Backups for Azure SQL Virtual Machines

• by Arun Sirpal

• All About SQL

When it comes to database backups for IaaS based Azure SQL Servers you have 3 options. Automated Backups, both V1 and V2 depending on the SQL Server version. Azure...

2020-09-16

7 reads

Automating DBCC CHECKDB for Azure SQL DB with Azure Functions

• by Arun Sirpal

• All About SQL

Warning, this is a longer post from me than usual. The title is a mouthful and so is this post. In the past I have linked to blog posts...

2020-09-09

103 reads

Azure SQL Database for the DBA

• by Arun Sirpal

• All About SQL

Last month I gave a presentation to The PASS Hybrid VG https://hybrid.pass.org/. Now is a good time to become “cloud ready” as a DBA and my presentation gives a...

2020-09-03

31 reads

Azure SQL Database – Read Only Endpoints

• by Arun Sirpal

• All About SQL

One of the main benefits of configuring active geo-replication for Azure SQL Database is leveraging the read-only endpoint, a good technique to split away read only activity from OLTP...

2020-08-25

101 reads

Azure SQL – Advanced Data Security [video]

• by Arun Sirpal

• All About SQL

A quick 2 minute overview video (from me) about ADS – Advanced Data Security. The unified package from Microsoft providing the ability to discover / classifying sensitive data, mitigate...

2020-08-19

11 reads