Monitoring Runbooks / Azure Automation + Log Analytics

A while ago, I wrote a couple of posts showing how we are collecting and storing Azure Automation runbook job history for monitoring and support using a custom runbook and Azure SQL database. Since then I have learned that Log Analytics for Azure Automation is in available in preview.  After setting it up and taking…


SQL Server Database migration to Azure SQL DB – using SSMS. Comparison of SSMS, SSDT, SAMW, SQL Server 2016 Upgrade Advisor.

If you are planning to migrate an on-prem SQL Server to Azure, there are a few key considerations: Understand the Azure SQL Database General Limitations and Guidelines Review the Azure SQL Database Transact-SQL differences Review the Azure SQL Database resource limits   Migration will involve both migration of the schema and data from your source…

0

WinRM | It's kind of a like / hate thing...

Sure, I like WinRM. It enables remote management of Windows over HTTP and it is at the core of how we perform configuration and change automation here in MSIT.  When configured properly it makes execution of tasks on remote machines insanely simple and without it I don’t think we’d be able to perform half of the activities we have automated in…


Monitoring a Busy Azure Automation Infrastructure (Part 2)

Keeping Operations and our customers happy with telemetry OK, so as we established in part one of this subject we’ve got a ton of Azure Automation (AA) runbook job history stored in Azure, and we need to begin collecting it and storing somewhere that is quick and easy to access and can serve as a…


Monitoring a Busy Azure Automation Infrastructure (Part 1)

*Update – Here is a better, supported way to monitor Automation… Since this blog was written, Microsoft has released Log Analytics for Azure Automation. Keeping Operations and our customers happy with telemetry After finally making forward progress in the push to migrate our automation workflows from SMA to Azure Automation (AA) we’ve got several thousand…


Already using Azure and curious which services are enabled in Resource Manager mode

I work with many IT teams and often get get questions from external customers at EBC on what is ARM, why leverage ARM, and whether all existing Azure services are ARM enabled? Azure has provided documentation ARM: ​Azure Resource Manager mode provide many advantages to enterprise IT including: 1. ability to tag resources which aid in classification…

0