Snowflake – Where is the explain/execution plan?
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
79 reads
Arun Sirpal
Using Snowflake – Hands On
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-09-23 (first published: 2022-07-26)
355 reads
Snowflake Architecture – The Basics
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
13 reads
Snowflake Editions
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
112 reads
Snowflake Data Cloud
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
141 reads
A New MVP Led Training Initiative – Cloud Formations
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
11 reads
Azure CLI – Deleting Resources
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
31 reads
Azure Storage Replication Types
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
53 reads
Azure VM Scale Sets
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
Azure VM Types
There are many different family groups for Azure VMs each with its own purpose. Below is a summary of what can be selected. This is important because for example...
2022-06-06
11 reads
Blogs
T-SQL Tuesday #155 –The Dynamic Code Invitation
By Steve Jones
Apologies for the late invitation. A minor snafu has me hosting again. This is...
Daily Coping 6 Oct 2022
By Steve Jones
Today’s coping tip is to remind yourself that you are enough just as you...
What you can do is based on more than your direct permissions.
What you have access to is not just what you have direct permissions to....
Forums
Problem extracting Data from JSON string
Hi there I have a JSON sample and struggling to extract data from it....
I must be loosing my mind. Odd data issue
I have a guest table on two servers. Call them prod1 and prod2. The...
Ask SSC