All About SQL

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

13 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

16 reads

Azure SQL Training

• by Arun Sirpal

• All About SQL

I thought being an Azure Data/Database blogger I would share some amazing content from Microsoft, an Azure SQL Fundamentals learning path. Following this training you will “Learn how to...

2020-08-05

27 reads

Azure SQL Database SLA

• by Arun Sirpal

• All About SQL

Can you improve on the baseline (service level agreement) SLA of 99.99 % for Azure SQL Database? How can you get 99.995% as shown below, from official Microsoft documentation?...

2020-08-04

10 reads

SQL Server Stretch DB to Azure

• by Arun Sirpal

• All About SQL

Since SQL Server 2016 we could leverage Microsoft Azure to dynamically move “cold” portions of data away from on-premises storage for longer retention time periods. Whilst in theory being...

2020-07-27

18 reads

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

123 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

144 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

443 reads