Chaos engineering is fun but especially important when building solutions in the cloud. It is great leveraging the cloud to build something, whether that’s a globally distributed website with...
2023-06-28 (first published: 2023-06-08)
251 reads
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...
2023-01-12
35 reads
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...
2022-11-25
185 reads
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...
2022-11-11
71 reads
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...
2022-10-27
74 reads
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...
2022-10-12
9 reads
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
16 reads
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
101 reads
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)
379 reads
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
15 reads
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Can I authenticate with Active Directory and get into PostgreSQL? Version: PostgreSQL 16.1 on...
USE [DBName] SELECT QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName] , SUM(sPTN.Rows) AS [RowCount]...
Comments posted to this topic are about the item Backing Up Master
Ask SSC