All About SQL

Snowflake Warehouses

• by Arun Sirpal

• All About SQL

Everyone has heard of scaling up and scaling out compute. Have you ever heard about a term called scaling across? Before Snowflake, I never. Scaling up and down is...

2022-10-11

Snowflake – Where is the explain/execution plan?

• by Arun Sirpal

• All About SQL

Whatever your database background is you will have heard of an execution / explain plan. Snowflake is no different. Coming from a MS SQL background I was used to...

2022-09-23

1 reads

Using Snowflake – Hands On

• by Arun Sirpal

• All About SQL

Now let’s start the process of creating a snowflake account in the Azure Cloud. You can sign up for a free trial from here – https://signup.snowflake.com/ I am going...

2022-07-26

Snowflake Architecture – The Basics

• by Arun Sirpal

• All About SQL

At the most basic level, Snowflake has 3 important components. The Cloud services layer, centralised storage layer and the compute layer. Cloud services – they call this the “brains”...

2022-07-19

Snowflake Editions

• by Arun Sirpal

• All About SQL

You have decided that snowflake is the technology you want to use to build your next gen data platform, you have decided your cloud provider (Azure, AWS, GCP) then...

2022-07-13

Snowflake Data Cloud

• by Arun Sirpal

• All About SQL

Time to shift gears away from the world of relational databases whether that is in the cloud, on-prem, Linux-based, containers or even sitting within Kubernetes. Everyone has heard of...

2022-07-06

A New MVP Led Training Initiative – Cloud Formations

• by Arun Sirpal

• All About SQL

Hello Readers – I wanted to make sure those who follow my blog have heard about the new MVP led training initiative started by Paul Andrew (@mrpaulandrew). It’s called...

2022-07-04

Azure CLI – Deleting Resources

• by Arun Sirpal

• All About SQL

Azure CLI is really handy for all sorts of tasks. When I build solutions, POCs and environments and I want to tear down the resources I like to use...

2022-06-16

29 reads

Azure Storage Replication Types

• by Arun Sirpal

• All About SQL

Storage Accounts are pretty much integrated into so many different designs in Azure, whether you are using Azure Synapse, 3rd party product like Snowflake, or Event Streaming designs –...

2022-06-15

47 reads

Azure VM Scale Sets

• by Arun Sirpal

• All About SQL

I really like scale sets. It lets you create and manage up to 1000 load balanced VMs per availability zone using windows or Linux images. (We can have flexible...

2022-06-09

9 reads