John Liu Blog

Every drop counts

Azure OpenAI Troubleshooting

Access denied due to Virtual Network/Firewall rules When making calls to your OpenAI deployed model, you may receive following error: “Access denied due to Virtual Network/Firewall rules.” As the error message suggested, check the “Firewalls and virtual networks” setting for you Azure OpenAI in Azure Portal under “Resource Management” –> “Networking”. If the firewalls are configured for “Selected Networks and Private Endpoints”, make sure the IP address of you current computer is allowed to access the network.

Posted by John Liu Monday, June 5, 2023

Power Automate extract email alias address

One can use Azure PowerAutomate to process files received via email. We can setup one central email account and create different email alias for different client where PowerAutomate only need to mornitor one email account. Howerver, PowerAutomate doesn’t (at the time of this article) expose the alias email address in the Office365 Outlook email action. One solution to address this challenge is to use Azure Function App to extract the alias email address from the email body using Regex.

Posted by John Liu Saturday, April 16, 2022

SQL Server on Azure config best practice

Each Azure VM has a OS disk (C drive) and a temporary disk (D drive). Only store on the temporary disk temp data that doesn’t need to be retained as all data on this disk will be lost after server reboot. The best practice for SQL Server on Azure VM is to use Premium Disks pooled for increased IOPs and storage capacity. Data file should be on its own pool with read-caching on the Azure disk.

Posted by John Liu Sunday, November 7, 2021

Azure sign-in methods in PowerShell script

When using PowerShell script to run tasks in Azure environment, we need first to sign-in to Azure. There are several ways to sign-in to Azure in PowerShell script. 1. Interactive sign-in we can using either Connect-AzAccount or Login-AzAccount -Credential (Get-Credential) Login-AzAccount and Add-AzAccount are alias of Connect-AzAccount. With -Credential (Get-Credential) option, it let you interactively enter the credential on the cmd interface, otherwise, it popup a GUI to let you login.

Posted by John Liu Monday, November 1, 2021