Provisioning Azure Cosmos DB using Powershell

Azure Cosmos database is one of the NoSQL database that is available in Microsoft Azure cloud platform. Azure Cosmos db is getting more popular compared to other NoSQL databases in the cloud market so many organisations started using Cosmos database with their organization. When we started incorporating Cosmos database into our project we provisioned it […]

Always Encrypted – An Over View – Part 1

Always encrypted is a new feature introduced to encrypt the  in rest as well as during transport. It’s been quite long time the feature has been released to general public. In this encryption method the encryption will be done at the client side. Encryption keys can be stored in Azure vault, Windows certificate store in client server or in hardware module. […]

Clear Procedure Cache in SQL Azure database

When we were working on performance baseline or performance improvement we might be clearing down the procedure cache to get the exact statistics of the stored procedure. Many of them are already aware how to do it in hosue SQL Server. We might be using anyone of the below command to clear the procedure cache.

Issues restoring SQL Azure bacpac due to QueryStoreStaleQueryThreshold

In our environment we have inhouse and SQL Azure databases. We will be refreshing the DEV environments weekly once from the production SQL Azure databases. As you know backups are taken care by Azure itself, so we can simply add the storage in our inhouse server and extract it as data tier application.