Tag: Azure Automation

  1. Syncing SQL Azure indexes across different environment

    We recently had a SQL performance workshop to address ongoing performance issues in one of our client systems. The workshop was conducted by Gail Shaw. The experience is one for another article, but lets just say it was interestingly insightful. One of her suggestions was to make sure we are…

    on SQL Server Azure Automation Azure Azure PAAS Azure SDK Automation Index Syncig

  2. Automating the restores of a SQL Azure Database using Azure Automation

    We have a client whose back office application is hosted in Azure and they have utilised Power BI to create an operational dashboard. The Power BI dashboard queries the Live SQL Azure Database every 2 hours. The database is set up as a Premium 2 performance tier. The refreshes would…

    on Azure Azure Automation Azure Functions Azure PAAS