Unfortunately due to personal reasons I haven’t been able to blog for a while. I am hoping I can change that and this will be one of those small blog posts. Recently on Microsoft Q&A there was question if you can get all Azure VMs with Period Assessment (Azure Update Manager feature) enabled ..read more

I hope this was useful information for you ..read more

Log Alerts have been available in Log Analytics for quite some time. Initially they were available via [legacy Log Alert API](https://docs.microsoft.com/en-us/azure/azure-monitor/alerts/api-alerts?WT.mc_id=AZ-MVP-5000120) that was specific for Log Analytics. In order to make Log Alert more native to Azure a new [Log Alert API](https://docs.microsoft.com/en-us/rest/api/monitor/scheduled-query-rules?WT.mc_id=AZ-MVP-5000120) was available. With a few minor features like (custom webhook payload) that API was direct translate from the legacy one offering the same features. Now Azure Monitor team is ..read more

I have been busy lately (answering on Q&A, Bicep testing, working, etc.) which prevented me from writing new blog posts but I hope to do more blogging again. This blog post will be a quick tip. If you have wondered in which resources a particular user assigned managed identity was used you can see that information quickly by using Azure Resource Graph. The query is very simple ..read more

At Azure Bootcamp Bulgaria 2021 I have presented "Azure Deployments - Past, Present and Future". In the demos I had two examples: * Advanced ARM template templates for deploying Azure SQL Database * The above example converted to the new Bicep language ..read more

If you are familiar with Log Analytics you will know that you can delete custom field/column directly from the UI as you can see below: For example I can delete custom field _ResourceId_s for MyLog0001_CL table. That option has been there for quite some time. A couple of years ago an API was made available so you can delete specific data from a table. This was also know as the [purge API](https://docs.microsoft.com/en-us/rest/api/loganalytics/workspacepurge/purge?WT.mc_id=AZ-MVP-5000120). The purge API is basically deleting data based on KQL query. With these APIs you could delete specific fie ..read more

This is just a quick blog post to notify you about me speaking at Azure Bootcamp Bulgaria 2021. If you are interested in Azure deployments or some of the other sessions you can check out the schedule and register ..read more

Azure SQL Databases is quite a big service and it is also one of the oldest. Because of these two there are a few architectural designs that you should be aware. Some of these are: * with every SQL logical server there is a master database resource that is created. This resource is not directly managed but for example when you configure diagnostic settings on server level you need to configure those against the master database resource rather the SQL logical server * The SKUs of Azure SQL Databases are mostly divided into DTU and vCore based. Among the vCore based we also have Hyperscale and S ..read more

Recently on Microsoft Q&A there was question on how you can control Azure SQL Firewall rule in a way that only certain IP addresses are allowed to be configured. Naturally I gave general answer that you can do that via Azure Policy. Initially I didn't give the person an actual policy as I haven't done such before. Of course creating Azure Policy definition can be challenging so the person asked him if I can provide him with example ..read more

AzureDiagnstics table is used by many Azure Services when you send diagnostic logs thus the [500 column limit that Microsoft is trying to fix for that table](https://docs.microsoft.com/en-us/azure/azure-monitor/reference/tables/azurediagnostics#additionalfields-column?WT.mc_id=AZ-MVP-5000120). When you hit that limit there is currently the described workaround but let's say you have used one service that was sending logs and you no longer use that service. The logs associated with that service are yet to purged but you also want to clean up any custom columns that the service was using. That w ..read more