I thank Rie Merritt (Blog|Twitter) for hosting T-SQL Tuesday #148. The topic for this month is Advice on running a user group. I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some of the T-SQL Tuesdays and participated in a few. Thank you, Steve Jones (Blog|Twitter), for coordinating this […]
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 […]
If you are using Azure Data Factory, you can export platform logs and metrics to a log analytics workspace. Sending logs and metrics to a Log Analytics workspace allows you to analyze them with other monitoring data collected by Azure Monitor using powerful log queries and leveraging other Azure Monitor features such as alerts and visualizations. […]
The auto-failover groups feature for the Azure SQL database can be configured with an automatic failover policy. Azure triggers failover after the failure is detected and the grace period has expired. Grace period is determined by a setting called ‘GracePeriodWithDataLossHours’ that cannot be set under one hour. Why is it not allowed to set a […]
A list of items that people often get wrong. If you have a suggestion, let me know, and I will add them to this page.
