May 4, 2022
There is a new DMV currently in preview which returns information about backups of Azure SQL databases except for the Hyperscale tier. Microsoft official documentation is here. If you run the example query as-is from the above documentation some of the columns do not make sense. Instead, use this query where I am joining with […]
November 2, 2021
Definition Data warehouse snapshot A data warehouse snapshot creates a restore point you can leverage to recover or copy your data warehouse to a previous state. Since a dedicated SQL pool is a distributed system, a data warehouse snapshot consists of many files that are located in Azure storage. Snapshots capture incremental changes from the data stored […]
October 26, 2020
In this blog post, I discussed some facts about Azure SQL Database Serverless. If someone wants to avoid those limitations and disable ‘Auto-pause,’ how costly is it? Suppose a serverless database is not paused and configured with 4 max vCores and 0.5 min vCores corresponding to 2.1 GB min memory. Then the minimum compute bill […]
October 20, 2020
Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview Few […]
March 19, 2020
On March 16th, I posted (Twitter|LinkedIn) about achieving my first ever Azure Certification. AZ-900 Azure Fundamentals. I understand it is basics, and that is why it is called fundamentals. I had a few people asked me how I prepared as they want to do the same. Here are a few resources I used to prepare: […]