All About SQL

Azure Cosmos DB Local Emulator

• by Arun Sirpal

• All About SQL

Technically you do not have to create a cosmos DB and incur costs to test cosmos DB based applications, you could use the local emulator. This means that you...

2019-06-11

53 reads

Azure Cosmos DB Intro

• by Arun Sirpal

• All About SQL

Cosmos DB falls into the “NoSQL” technology group, call it a buzz word if you like but it is very different to classic Relational Databases such as SQL Server....

2019-06-10

133 reads

Using Azure Data Factory to Migrate Data

• by Arun Sirpal

• 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

91 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

263 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

88 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

25 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

13 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

134 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

41 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

8 reads