Azure SQL Database
An Azure relational database service.
5,097 questions
1 answer
Azure SQL DB Autoscaling issue
Hello, I'm currently facing an issue with automating the scale up/down of my Azure SQL DB. When the DB experiences high DTU usage and the auto scale-up is triggered by an alert runbook, the query that was running on the DB gets interrupted, causing my…
asked 2024-04-17T15:38:07.7833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 91%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MoTaar
290
Reputation points
commented 2024-04-19T15:54:42.4166667+00:00
Oury Ba-MSFT
16,076
Reputation points Microsoft Employee
2 answers
Assign RBAC "Key Vault Administrator" role to Azure App via C# (.NET SDK)
I use below C# code create KeyVault with RBAC permission model. using KeyVaultModels = Microsoft.Azure.Management.KeyVault.Models; KeyVaultModels.VaultProperties vaultProperties = new KeyVaultModels.VaultProperties() { EnableRbacAuthorization = true, …
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 48%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
How to Automate sending of Azure Metrics chart to Email?
I have different Metrics for my Application Insights and I want to send the chart monthly to my email automatically. Currently, I am downloading the Excel File then attached that file to email manually. Is there a way I can achieve this automatically…
asked 2024-04-03T06:20:43.9766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 57.00000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
user20201
286
Reputation points
commented 2024-04-19T07:23:47.1+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 39%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SwathiDhanwada-MSFT
17,321
Reputation points
0 answers
Unable to recover Automation account in Azure
Hi, I need help with restoring my Azure automation account. I created an automation account for some testing in the EastUS region and I deleted all the resources once my testing was complete. Then, I tried creating an automation account again but got…
asked 2024-04-11T22:49:51.6466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 81%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI5%3C/text%3E%3C/svg%3E)
Ishaanpreet-5919
5
Reputation points
commented 2024-04-19T00:04:27.38+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER6%3C/text%3E%3C/svg%3E)
RaghuveerBoinapalli-6584
0
Reputation points
1 answer
Key Vault Integration on the Roadmap?
Are there currently any plans to allow Credentials and encrypted variables to be sourced directly from Key Vault so that we don't have to use PowerShell in the script to query the vault? Normally this wouldn't be an issue but since we're protecting our…
asked 2024-04-18T18:20:59.8+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 85%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Austin Greca
0
Reputation points
answered 2024-04-18T19:33:35.7166667+00:00
James Hamil
21,466
Reputation points Microsoft Employee
1 answer
Automating Email Notifications for Mailbox Storage Monitoring
Hi everyone, I'm looking to automate a task where I receive an email notification when a specific email mailbox reaches 80% of its storage capacity. After researching, it seems that using Azure Automation Accounts would be the way to go. Firstly, I'm…
asked 2024-04-17T12:01:56.5133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 92%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Aran Billen
496
Reputation points
commented 2024-04-18T09:00:25.86+00:00
Aran Billen
496
Reputation points
0 answers
My Job in a Hybrid Work is failing as out of resources
My job goes into suspended status with the exception of "Job was suspended as the job limit for a Hybrid Worker exceeded. Add more Hybrid Workers to the Hybrid Worker group to overcome this issue, see: https://aka.ms/HRW-polling-limit-exceed". …
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 61%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
0 answers
Support for Inline Child Scripts in PowerShell 7.2 Runbooks
What is the current status of support for inline scripts in Powershell 7.2 runbooks? The current documentation lists inline scripts as "not supported", but it is unclear whether this will change or when it might change. We have several scripts…
asked 2024-04-16T07:32:25.3133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 0%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGN%3C/text%3E%3C/svg%3E)
Guilherme Noronha
0
Reputation points
commented 2024-04-16T13:45:20.2833333+00:00
Guilherme Noronha
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Difference between DSCandHybridWorker and Webhook
Whats the difference between these 2?
asked 2024-04-16T11:12:51.85+00:00
Aran Billen
496
Reputation points
accepted 2024-04-16T12:55:02.66+00:00
Aran Billen
496
Reputation points
1 answer
One of the answers was accepted by the question author.
azure automation accounts public access - the risks
Hi all Can someone explain the real risks of having an automation account open with public network access? Assuming the only way to get into it is with system principal assigned to it?
asked 2024-04-15T14:46:44.2666667+00:00
Aran Billen
496
Reputation points
accepted 2024-04-16T11:10:59.1933333+00:00
Aran Billen
496
Reputation points
0 answers
Is there any API method/ CLI command to get Azure Dashboard printed in a pdf format?
Currently I can download the dashboard directly from Azure Portal UI itself by simply exporting it. I need an API endpoint / CLI command to get Azure Dashboard printed in a pdf format. Also, I need to attach that pdf and send it as a mail on a…
asked 2024-04-15T06:33:08.3533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 28.000000000000004%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Nihar Kenny
0
Reputation points
asked 2024-04-15T06:33:08.3533333+00:00
Nihar Kenny
0
Reputation points
1 answer
How to Automate Azure Task on Weekdays
Hello. I currently have an automated task which starts an Azure VM every morning at 3 AM. However, I only need it to start on weekdays (Monday - Friday). How do I amend this configuration to exclude Saturday and Sunday? I see that this page... …
asked 2024-04-15T00:29:45.0533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 10%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Rhys Miller
0
Reputation points
edited the question 2024-04-15T03:15:57.54+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 74%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Anveshreddy Nimmala
2,150
Reputation points Microsoft Vendor
1 answer
How to setup a host or VM to run on scheduled to execute a script so its going to update the user attributes in AAD/Entra ID?
How to setup a host or VM to run on scheduled to execute a script so its going to update the user attributes in AAD/Entra ID? Here is our use case: I want to run a MS Graph PowerShell script on scheduled hours once or twice a month which will update…
asked 2024-04-13T08:33:48.1233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 18%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mytoast Admin
95
Reputation points
edited the question 2024-04-15T03:14:33.6166667+00:00
Anveshreddy Nimmala
2,150
Reputation points Microsoft Vendor
1 answer
How to automate indexing additional documents in Azure Open AI to access GPT model (gptv4 Turbo) and Azure Search Service for data indexing and retrieval.
I've created a PoC using https://github.com/Azure-Samples/azure-search-openai-demo and explored the ChatGPT like experience over enterprise data using RAG model which uses Azure OpenAI to access GPT model (gptv4 Turbo) and Azure Search Service for data…
asked 2024-04-10T10:57:42.9033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 53%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENM%3C/text%3E%3C/svg%3E)
Narendra Mahendrakar (Microland)
0
Reputation points
answered 2024-04-12T11:31:25.4333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 92%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
ajkuma
22,086
Reputation points Microsoft Employee
1 answer
Azure Automation Account - Source Control sync error
One of our Automation Accounts in Azure is unable to sync with our Devops source control repository. Upon manually initiating a sync, it "Completes" but has the following error: System.Management.Automation.CommandNotFoundException: The term…
asked 2024-03-28T19:37:13.73+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 35%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Louis Rice
0
Reputation points
commented 2024-04-12T05:43:48.64+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 41%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AnuragSingh-MSFT
19,686
Reputation points
1 answer
One of the answers was accepted by the question author.
How can I create a custom Azure policy to prevent/deny manual resource creation in resource groups while allowing automated creation through GitHub Actions or Azure Automation?
How can I create a custom Azure policy to restrict end users from manually creating resources in resource groups and prevent unauthorized peerings with existing VNets, while also allowing the creation of resources through GitHub action automation or…
asked 2024-04-01T05:49:52.1833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 97%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Priyanka Varma
60
Reputation points
accepted 2024-04-11T03:58:20.34+00:00
Priyanka Varma
60
Reputation points
0 answers
Azure Automation Accounts
Hello, I tried to deploy Automation Account using bicep. Since this is first time to deploy AA so I deleted existing one and re-deploy it for multiple times. I suddently received following message: "code": "BadRequest", …
asked 2024-04-08T20:02:00.5566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 95%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJZ%3C/text%3E%3C/svg%3E)
Jeremy Zheng
50
Reputation points
commented 2024-04-10T14:20:45.59+00:00
Jeremy Zheng
50
Reputation points
1 answer
Support for Inline Child Scripts in PowerShell 7.1 (preview) runbooks?
Hello! Currently, inline child scripts are not supported (e.g. .\child-runbook.ps1) in 7.1 as per this document: https://learn.microsoft.com/en-us/azure/automation/automation-runbook-types?branch=pr-en-us-178132#known-issues---71-preview Is this…
asked 2022-06-30T17:14:35.557+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 94%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Jacob Garcia
6
Reputation points Microsoft Employee
edited a comment 2024-04-10T08:10:32.64+00:00
Guilherme Noronha
0
Reputation points
0 answers
How to get notified via email when deployments history of resource groups counts exceeds 500?
we noticed that resource group is limited to 800 deployments in its deployment history. At the end we have question about Monitoring Part. PowerShell Script to get list of Resource Group Name along with Deployment Name and Status of all Deployments for…
asked 2024-04-05T11:44:35.09+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 86%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Shashikanth M S
0
Reputation points
edited the question 2024-04-08T04:57:36.74+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 20%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Shweta Mathur
27,141
Reputation points Microsoft Employee
3 answers
Issue with Powershell 7.2 SqlServer module
I've installed the SqlServer module into Azure runbooks for powershell 7.2 but when I go to use it I get... "Invoke-Sqlcmd' is not recognized as a name of a cmdlet, function, script file, or executable program. Check the spelling of the name, or if…
asked 2024-02-22T04:11:24.68+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 46%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Shwetha J
10
Reputation points
commented 2024-04-06T05:39:02.46+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 27%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Somesh Bhalerao
5
Reputation points