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 Azure CLI over the Portal. Below will show you the commands I use.
Category Archives: SQL SERVER
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
SQL Managed Instance – Failover Groups Quick Tips
Lets summarise some important learnings about SQL MI and failover groups.
SQL Server and AKS
Following on from my last post after creating AKS, I now want to work with SQL server. First step, load up Azure cloud shell.
SQL server BIGINT
It has been a while since I wrote a blog post for TSQL Tuesday and there is no better time then now following on from Brent Ozar’s Invite about our favourite data types in SQL server.