---

Filter by type:

• All
• Articles
• Blog Posts

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

7 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

13 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

102 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

100 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

Azure Database Administrator

• by Arun Sirpal

• All About SQL

Recently I found out that I passed the BETA exam for Azure Database Administrator Associate qualification. I wanted to share with you my thoughts on the exam and if...

2020-08-11

21 reads

Azure SQL Database – Maxdop Updated

• by Arun Sirpal

• All About SQL

About 1.5 years I wrote about MAXDOP setting within Azure SQL DB, more specifically the fact that the default setting being 0. (https://blobeater.blog/2018/09/12/maxdop-and-azure-sql-db/) Now, you should be aware that...

2020-08-10

245 reads

Filter by type:

• All
• Articles
• Blog Posts