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 Synapse. They face stiff competition from the likes of Snowflake. Snowflake does not really have this concept of Control and compute nodes like within the Microsoft world to build out this MPP based architecture.

Continue reading

Advertisement

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 if you are running complex OLTP database servers then very likely you will go for Memory optimised machines, right? We know SQL server loves RAM. Any ways here is the list:

Continue reading

Azure Redis Cache – Persistent Data

I mentioned before that you could use the idea of data persistency to rebuild your data from total failure. There are two types. RDB and AOF.

RDB – persists a snapshot of your cache in a binary format. The snapshot is saved in an Azure Storage account. AOF – saves every write operation to a log. The log is saved at least once per second into an Azure Storage account. 

This is quite an in-depth topic area and I suggest further reading to determine which one suits you: https://redis.io/topics/persistence#aof-disadvantages

To set this up you will see data persistence section within your Redis Cache

Continue reading

Microsoft Defender for open-source relational DB

If you navigate to the overview section of your MySQL server you will see a notification area, here you will find security section. It’s basically an area to provide some hints / tips if things have not been configured such as if you have not enabled query store it may well suggest it. For this blog it is suggesting I consider a feature called Microsoft Defender.

Continue reading

MySQL server Query Store

The query store, sounds familiar? The idea of the black box sitting within the database server watching what is going on within the environment. This is available within MySQL, maybe not as feature rich as SQL Server but still useful.

You will find this option under the Query performance insight section of your MySQL server.

Continue reading