Category: Azure

Sync Azure Analysis Service Replicas with Azure Automation

July 5, 2021

Azure Analysis Service Replicas Azure Analysis Service lets you scale out your queries very easily through replicas. Replicas are nothing but multiple copies of your Azure Analysis Service (AAS) database. In critical times, queries can run in replicas and reduce the load on Query Processing Unit (QPU). You can read more about Analysis Service replicas … More Sync Azure Analysis Service Replicas with Azure Automation

Azure Analysis Service – current context is read-only

June 27, 2021

Ever faced the following error while changing any properties in Azure Analysis Service or while processing a Analysis Service Database: “ This operation is not allowed by The Azure Analysis Service product as the current context is read-only” All you have to do is to add “:rw” at the end of your server name URL … More Azure Analysis Service – current context is read-only

Restore SQL Server database using SAS from Azure Blob Storage

November 23, 2018

You need to create a SQL Server credential first to restore a database back up from Azure blob storage. A lot of writings can be found around the web on this. Most of them have used Azure Storage Account to create the credential in the first place. In this short post, I will be using … More Restore SQL Server database using SAS from Azure Blob Storage