Azure SQL Database – Advanced Threat Detection

• by Arun Sirpal

• All About SQL

You should always seriously consider enabling this feature. This is part of the ADS suite – Advanced Data Security and I will show you how good this pro-active service...

2020-07-21

125 reads

Azure SQL Database and Backups

• by Arun Sirpal

• All About SQL

Question, can you take a built-in backup ( a backup that Microsoft takes as part of the service) and create a new database from it on a NEW server...

2020-07-14

147 reads

Azure Data Engineer Associate

• by Arun Sirpal

• All About SQL

You can read about all the new role based qualifications from Microsoft here – https://www.microsoft.com/en-us/learning/certification-overview.aspx Today I want to talk about the Azure Data Engineer one from my experience...

2020-07-06

23 reads

Azure SQL Database Networking

• by Arun Sirpal

• All About SQL

Have you realised the changes Microsoft have made to the firewall and networking section of Azure SQL Database? I found this quite stealthy and took me by surprise. I...

2020-06-24

1 reads

Azure SQL Database Migrating across Tiers

• by Arun Sirpal

• All About SQL

A quick post today about moving across database tiers. As you can see below I have a General Purpose Serverless Gen 5 1 vCore database (currently paused). Can I...

2020-06-17

446 reads

Azure Monitor and Azure SQL Database

• by Arun Sirpal

• All About SQL

This is all about enabling diagnostics telemetry for Azure SQL databases. For Azure SQL Database there are quite a few options to select from. Below shows the diagnostic settings...

2020-06-10

20 reads

Tips and Tricks Azure Databricks

• by Arun Sirpal

• All About SQL

It has been a while since I posted an entry for TSQL Tuesday, which, for today is hosted by Kenneth . The subject being a non SQL Server tip. For...

2020-06-09

175 reads

Lock your Azure SQL Database

• by Arun Sirpal

• All About SQL

So you have many databases in Azure, you accidentally deleted one which can happen and has happened to me because in my situation they had very similar naming conventions...

2020-06-03

117 reads

Azure Databricks to Azure SQL DB

• by Arun Sirpal

• All About SQL

Recently I got to a stage where I leveraged Databricks to the best of my ability to join couple of CSV files together, play around some aggregations and then...

2020-05-26

17 reads

SQL Server 2019 Linux On Azure

• by Arun Sirpal

• All About SQL

It was just a matter of time until I started combining my cloud experience with “different” flavours of SQL Server. I haven’t used Linux since my university days (Oracle...

2020-05-19

85 reads