Azure SQL Managed Instance – Cost Saving!
All About SQL
by blobeater
3w ago
We all would like to save money when operating in the cloud, Microsoft has released a stop / start concept for SQL Managed Instances – preview mode! At the time of writing, the Managed Instance needs to be built from ..read more
Visit website
Snowflake Classic UI vs Snowsight
All About SQL
by blobeater
2M ago
This blog post is not about which User Interface is better, Classic or Snowsight – If anyone does want my feedback on what I like and don’t like about them then I might do another blog post but the aim ..read more
Visit website
Cloning in Snowflake
All About SQL
by blobeater
3M ago
Cloning is a powerful feature within snowflake (also known as zero copy clone). You can obviously clone at the database or schema level but also tables too. It’s a snapshot of the object when the clone was taken. Its uses ..read more
Visit website
Snowflake – Search Optimisation Service
All About SQL
by blobeater
3M ago
Rarely do I say I love a feature across any technologies I have come across, in the snowflake world this is right up there. I tend to find this feature useful when you have an important query that uses the ..read more
Visit website
Snowflake Key Pair Authentication
All About SQL
by blobeater
4M ago
Snowflake does a great job on documenting the key pair process using bash for Linux environments. That’s great, but what if you need to work within a windows environment and use the command line. Its similar but worth a blog ..read more
Visit website
Snowflake Warehouses
All About SQL
by blobeater
4M ago
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 easy. It means moving up and down sizes for your snowflake ..read more
Visit website
Using Snowflake – Hands On
All About SQL
by blobeater
6M ago
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 to bypass this and go straight to the setup screens. (This ..read more
Visit website
Snowflake Architecture – The Basics
All About SQL
by blobeater
7M ago
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” of snowflake. This is where infrastructure management takes place, the optimiser ..read more
Visit website
Snowflake Editions
All About SQL
by blobeater
7M ago
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 next you need to think about what edition of snowflake suits ..read more
Visit website
Azure Storage Replication Types
All About SQL
by blobeater
8M ago
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 – we need it. When you create a storage account there are ..read more
Visit website

Follow All About SQL on Feedspot

Continue with Google
OR