Blog Posts

Scaling SQL Elastic Pools

• All About SQL

There are a few ways to scale a SQL elastic pool. For this blog post I show you how to scale up. It can be done via the Azure…

Arun Sirpal

2019-04-15

12 reads

Tuning Azure SQL Elastic Pools

• All About SQL

The below image is a beautiful picture, now it could be worse. The red line and the green line could peak at the same time and for a very…

Arun Sirpal

2019-04-11

114 reads

SQL Server 2019 Suspend/Resume TDE

• All About SQL

Yes, a really nice new shiny feature where we have the ability to suspend and resume the encryption scan for TDE – Transparent Data Encryption which is available in…

Arun Sirpal

2019-04-02

34 reads

New Improved Azure Elastic Jobs

• All About SQL

There is a new way to setup Azure elastic jobs to run against a target group of databases (targeting an elastic pool). I actually found the process quite messy…

Arun Sirpal

2019-03-27

5 reads