Snowflake + Azure blob

Let’s go back to data platforms today and I want to talk about a very common integration I see nowadays, Azure Blob Storage linked to Snowflake via a storage integration which then we can access semi structured files via external tables, it is a good combination of technology I have to say.

What do you need – the diagram gives you the high level reqs.

Continue reading

Azure SQL MI License free?

A common setup when leveraging the cloud is to use the cloud for Disaster recovery (DR) purposes, some say it becomes a logical extension of your on-prem / data centre (makes more sense if you use express route and private endpoints).

You can use this approach for DR of your SQL based systems, look at the below image and you can see how. (Assume the left-hand side SQL icon is a VM on prem)

Continue reading

Azure chaos STUDIO

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 lots of traffic or an internal 3 tier application for a business – the question is – what happens is there is an unexpected fault / disruption? Can your system / app withstand the issue?

Continue reading

Azure SQL Managed Instance – Cost Saving!

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!

Continue reading

Snowflake Classic UI vs Snowsight

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 here today is to show you how to load the classic one as the default experience because when you login to snowflake the snowsight UI is the default one..

Continue reading