All About SQL

Quite simply the objective as follows: Move data from Azure SQL Database to Azure SQL DW via Azure Data Factory v2 (ADF). Overview Before I begin, what exactly is...

2019-05-22

197 reads

Azure SQL Database Serverless

by Arun Sirpal

All About SQL

Quite a significant change has taken place within the Azure SQL Database space, more specifically the development of Azure SQL Database Serverless. Currently in preview mode this “compute” tier changes...

2019-05-14

330 reads

Pausing / Resuming Azure SQL DW

by Arun Sirpal

All About SQL

Before writing about pausing (and resuming) Azure SQL Data Warehouse (DW) it makes sense to discuss the architecture of this product. At a high level it involves a control...

2019-05-07

119 reads

Video – Creating Azure SQL Database

by Arun Sirpal

All About SQL

A quick 2 minute upload (with sound, my voice) showing you how easy it is to create an Azure SQL Database using the Azure portal and then using SSMS...

2019-04-23

41 reads

Scaling SQL Elastic Pools

by Arun Sirpal

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...

2019-04-15

63 reads

Tuning Azure SQL Elastic Pools

by Arun Sirpal

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...

2019-04-11

157 reads

SQL Server 2019 Suspend/Resume TDE

by Arun Sirpal

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...

2019-04-02

170 reads

New Improved Azure Elastic Jobs

by Arun Sirpal

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...

2019-03-27

30 reads