Month: October 2024
Pivot Table Grouping
Good Afternoon All,
I currently have two pivot tables, one has solar energy production data for a day split in hours, i.e., “Monday, 7/01/2024 – 12:00am – 1:00am” and the other has electricity usage data for a day split in 15 minute increments, i.e., “2024-07-01 00:00:00 to 2024-07-01 00:15:00”, “2024-07-01 00:15:00 to 2024-07-01 00:30:00”, and so on and so fourth.
I am trying to group the pivot table that is split in 15 minute increments by every 4 rows to match the solar energy production data for one hour increments but I am having trouble working the pivot table to group automatically.
I tried creating a calculated field using the following formula but had no luck:
SUM(OFFSET(“STARTING ROW”,(ROW()-ROW(“COLUMN START”))*4,0,4,1))
Is there an easier way to compute this so when I update the data it is automatically group by every 4 rows? It is a bunch of data (goes from 0000 to 2345 in 15 minutes) so grouping manually is not ideal.
Please see the attached picture for reference and I can provide the excel sheet if needed.
Thank you!
Marshall
Good Afternoon All, I currently have two pivot tables, one has solar energy production data for a day split in hours, i.e., “Monday, 7/01/2024 – 12:00am – 1:00am” and the other has electricity usage data for a day split in 15 minute increments, i.e., “2024-07-01 00:00:00 to 2024-07-01 00:15:00”, “2024-07-01 00:15:00 to 2024-07-01 00:30:00”, and so on and so fourth. I am trying to group the pivot table that is split in 15 minute increments by every 4 rows to match the solar energy production data for one hour increments but I am having trouble working the pivot table to group automatically. I tried creating a calculated field using the following formula but had no luck: SUM(OFFSET(“STARTING ROW”,(ROW()-ROW(“COLUMN START”))*4,0,4,1)) Is there an easier way to compute this so when I update the data it is automatically group by every 4 rows? It is a bunch of data (goes from 0000 to 2345 in 15 minutes) so grouping manually is not ideal. Please see the attached picture for reference and I can provide the excel sheet if needed. Thank you! Marshall Read More
Build more innovative solutions and services for your customers with updates to Azure OpenAI Service
Microsoft is announcing new products and features for Azure OpenAI Service, including GPT-4o with audio and speech capabilities! Come check out the exciting details in this announcement and how you can use the new capabilities to build better solutions and services for your customers.
Read more here
Microsoft Tech Community – Latest Blogs –Read More
How to address this issue and enhance pixel quality by estimating or predicting the missing (zero) pixels, by using AI models
Post Content Post Content ai, deep learning, image analysis, image processing, video processing, video, pixles, digital image processing MATLAB Answers — New Questions
Adsorption process in Simulink
How to create a switch command between adsorption and desorption in Simulink?How to create a switch command between adsorption and desorption in Simulink? How to create a switch command between adsorption and desorption in Simulink? adsorption, simulink, switch command MATLAB Answers — New Questions
UPDATE: Azure Pass Retirements
UPDATED: Azure Pass Retirements
September 25th post has been removed
As a part of the Microsoft security efforts, we are continuing to remove the dependency on Azure passes and are expecting that all Azure Passes will be removed from courses by end of October 2024. As a part of this effort please note the following changes below. The Authorized Lab Hosters will be working on removing Azure Passes from courses as updates gets released.
Should you have any further questions, please reach out to your Authorized Lab Hoster.
Please note: This is not a support forum. Only comments related to this specific blog post content are permitted and responded to.
Microsoft Tech Community – Latest Blogs –Read More
Dev Channel update to 131.0.2863.0 is live.
Hello Insiders! We released 131.0.2863.0 to the Dev channel! Additionally, Mobile and Mac received updates with version bumps to 131.0.2866.0 and 131.0.2867.0, respectively!
The release includes numerous fixes. For more details on the changes, check out the highlights below.
An AI companion for everyone – Official Microsoft Blog
Added Features:
Added a ‘Restart’ option in the Prism Collections setting toggle within the webui2 settings.
Introduced a ‘…’ menu to the tab center.
Improved Behavior:
Resolved an issue where browser would crash when opening a new InPrivate tab from the app’s contextual menu or widget on iOS.
Changed Behavior:
Resolved an issue where clicking on links sometimes opened them in the desktop browser instead of within Game Assist.
Resolved an issue where the stamp function could draw incomplete graphics directly on the border in screenshots.
Mac:
Resolved an issue where browser opens without FRE and becomes non-functional on Mac.
Android:
Fixed an issue where Talkback announced the ‘x’ button as ‘unlabeled’ in the ‘Notifications’ pane under the browser’s Account Menu on Android.
Fixed an issue where the shopping UI remained visible on Android after being opened and the system’s return button was pressed.
iOS:
Resolved an issue where the address bar on the NTP disappears in landscape mode on iOS.
Resolved an issue where the top sites names were misaligned on the ZIP page in iOS.
Fixed an issue where Top sites icons displayed abnormally when adding or removing top sites in split-screen mode on iOS.
Fixed an issue where the read aloud bar for online PDFs appeared on other pages in iOS.
Fixed an issue where Voiceover remained silent when loading search results on iOS.
See an issue that you think might be a bug? Remember to send that directly through the in-app feedback by heading to the … menu > Help and feedback > Send feedback and include diagnostics so the team can investigate.
Thanks again for sending us feedback and helping us improve our Insider builds.
~Gouri
Hello Insiders! We released 131.0.2863.0 to the Dev channel! Additionally, Mobile and Mac received updates with version bumps to 131.0.2866.0 and 131.0.2867.0, respectively!
The release includes numerous fixes. For more details on the changes, check out the highlights below.
An AI companion for everyone – Official Microsoft Blog
Added Features:
Added a ‘Restart’ option in the Prism Collections setting toggle within the webui2 settings.
Introduced a ‘…’ menu to the tab center.
Improved Behavior:
Resolved an issue where browser would crash when opening a new InPrivate tab from the app’s contextual menu or widget on iOS.
Changed Behavior:
Resolved an issue where clicking on links sometimes opened them in the desktop browser instead of within Game Assist.
Resolved an issue where the stamp function could draw incomplete graphics directly on the border in screenshots.
Mac:
Resolved an issue where browser opens without FRE and becomes non-functional on Mac.
Android:
Fixed an issue where Talkback announced the ‘x’ button as ‘unlabeled’ in the ‘Notifications’ pane under the browser’s Account Menu on Android.
Fixed an issue where the shopping UI remained visible on Android after being opened and the system’s return button was pressed.
iOS:
Resolved an issue where the address bar on the NTP disappears in landscape mode on iOS.
Resolved an issue where the top sites names were misaligned on the ZIP page in iOS.
Fixed an issue where Top sites icons displayed abnormally when adding or removing top sites in split-screen mode on iOS.
Fixed an issue where the read aloud bar for online PDFs appeared on other pages in iOS.
Fixed an issue where Voiceover remained silent when loading search results on iOS.
See an issue that you think might be a bug? Remember to send that directly through the in-app feedback by heading to the … menu > Help and feedback > Send feedback and include diagnostics so the team can investigate.
Thanks again for sending us feedback and helping us improve our Insider builds.
~Gouri Read More
How to apply a legend to a graphed model array?
Hello, I have a created a model array of transfer functions using stack() and they are labeled with their varying parameters using SamplingGrid.
Yarray = feedback(Garray,1);
Yarray.SamplingGrid = struct(‘zeta’,dr);
figure;
set(gcf,’Visible’,’on’)
step(Yarray, 60)
How do I apply a visible legend to this graph? I like the normal legend() function that applies the titles and automatically changes the colors. However, calling this function either with my desired labels or empty just has the default color line labeled as ‘Yarray.’ I would love if they could be labeled dynamically following the SamplingGrid structure.Hello, I have a created a model array of transfer functions using stack() and they are labeled with their varying parameters using SamplingGrid.
Yarray = feedback(Garray,1);
Yarray.SamplingGrid = struct(‘zeta’,dr);
figure;
set(gcf,’Visible’,’on’)
step(Yarray, 60)
How do I apply a visible legend to this graph? I like the normal legend() function that applies the titles and automatically changes the colors. However, calling this function either with my desired labels or empty just has the default color line labeled as ‘Yarray.’ I would love if they could be labeled dynamically following the SamplingGrid structure. Hello, I have a created a model array of transfer functions using stack() and they are labeled with their varying parameters using SamplingGrid.
Yarray = feedback(Garray,1);
Yarray.SamplingGrid = struct(‘zeta’,dr);
figure;
set(gcf,’Visible’,’on’)
step(Yarray, 60)
How do I apply a visible legend to this graph? I like the normal legend() function that applies the titles and automatically changes the colors. However, calling this function either with my desired labels or empty just has the default color line labeled as ‘Yarray.’ I would love if they could be labeled dynamically following the SamplingGrid structure. model array, legend, step MATLAB Answers — New Questions
New updates to Azure OpenAI Service, including GPT-4o with audio and speech capabilities
Microsoft is announcing new products and features for Azure OpenAI Service, including GPT-4o with audio and speech capabilities! Come check out the exciting details in this announcement and how you can use the new capabilities to build better solutions and services for your customers.
Microsoft is announcing new products and features for Azure OpenAI Service, including GPT-4o with audio and speech capabilities! Come check out the exciting details in this announcement and how you can use the new capabilities to build better solutions and services for your customers.
Learn more: Announcing new products and features for Azure OpenAI Service include GPT-4o-Realtime-Preview with audio and speech capabilities Read More
Device Settings – Maximum Number of Devices per user
I really want to know what does these settings do? Does it help the techs who are joining the devices to Intune have restrictions and how so? Also, how does this affect Autopilot joined devices, if there is a limit that is set here?
I really want to know what does these settings do? Does it help the techs who are joining the devices to Intune have restrictions and how so? Also, how does this affect Autopilot joined devices, if there is a limit that is set here? Read More
Cannot sign in re email in the last few fays
Couldnt sign in for last few days. Cannot send or receive emails. Advice given for this problem is for experts only, not for the ordinary user. I do not understand it. When I enter my password, I’m told I cannot sign in.
Couldnt sign in for last few days. Cannot send or receive emails. Advice given for this problem is for experts only, not for the ordinary user. I do not understand it. When I enter my password, I’m told I cannot sign in. Read More
Outlook auto-delete e-mails
I have a user, each email she gets, goes straight to her deleted files, she would have to manually move them over to her inbox. I have checked her rules, junk options, uninstall office 365 re-install, nothing seems to be working.
I have a user, each email she gets, goes straight to her deleted files, she would have to manually move them over to her inbox. I have checked her rules, junk options, uninstall office 365 re-install, nothing seems to be working. Read More
outlook attachments macbook not showing recent items in Finder
when searching for an attachment in Finder, more recent maps and docs are not shown
when searching for an attachment in Finder, more recent maps and docs are not shown Read More
NEW Video: Microsoft Intune support for Apple Intelligence…
Microsoft Intune support for #Apple Intelligence…
Apple managed supervised devices, Intune supports new settings for Apple Intelligence in the Restrictions payload and Math Settings declaration.
#Youtube: https://youtube.com/@shadykhorshed?si=Ywa7BklYPlpDP5va
#apple #msintune #microsoft #MDM #iOS #iPad
Microsoft Intune support for #Apple Intelligence… Apple managed supervised devices, Intune supports new settings for Apple Intelligence in the Restrictions payload and Math Settings declaration. #Youtube: https://youtube.com/@shadykhorshed?si=Ywa7BklYPlpDP5va #apple #msintune #microsoft #MDM #iOS #iPad Read More
internet calendars not letting me set reminders
I have my default calendar and can set reminders fine in that calendar. However, I get the following message when trying to set a reminder…
“The reminder XXXX will not appear because the item is in a folder that doesn’t support reminders. Is this OK?”
My mail folders are all IMAP except one exchange folder, but the default is an IMAP. i do not think the folder type does/should affect an internet calendar’s ability to set reminders.
It’s annoying that i cannot set reminders for ical events, and this must be something that can be fixed.
I appreciate any help in resolving this.
I have my default calendar and can set reminders fine in that calendar. However, I get the following message when trying to set a reminder… “The reminder XXXX will not appear because the item is in a folder that doesn’t support reminders. Is this OK?” My mail folders are all IMAP except one exchange folder, but the default is an IMAP. i do not think the folder type does/should affect an internet calendar’s ability to set reminders. It’s annoying that i cannot set reminders for ical events, and this must be something that can be fixed. I appreciate any help in resolving this. Read More
ExpressRoute Metro is now generally available!!
We are excited to announce general availability of ExpressRoute Metro, a new private connectivity architecture designed to enhance network resiliency for our customers. ExpressRoute Metro provides a highly resilient circuit that enables diverse connections to two separate edge sites within a city, ensuring increased redundancy and reliability.
With Metro Provider and Metro Direct, customers can benefit from enhanced redundancy across the circuit and port infrastructure, while also gaining an additional layer of resiliency at the edge site level. This solution is engineered to maintain robust connectivity in case of site-wide disruptions, ensuring uninterrupted service and business continuity.
Key Highlights:
Enhanced Resiliency: Dual-homed connections across two distinct edge sites offer improved resiliency.
Locations Coverage: Metro is currently available in Amsterdam, Singapore and Zurich with more locations including Atlanta, Milan, Madrid, Chicago, and Dublin, scheduled to go live in coming months.
Simple Setup: The setup process is designed for simplicity and ease of configuration, featuring a guided portal that provides clear navigational support.
Learn more about ExpressRoute Metro here.
For Pricing, please refer here.
Microsoft Tech Community – Latest Blogs –Read More
Transition from VNET integration to public access or Private Link using the Azure CLI
You can transition an Azure Database for MySQL flexible server from using VNET integration (Private Access) to using Public Access or Private Link seamlessly, without the need to alter the server name or migrate data, which simplifies the process for customers. However, after you make the transition, you cannot reverse it. The transition involves approximately 5-10 minutes of downtime for non-HA servers and about 20 minutes of downtime for HA-enabled servers.
Note: Step-by-step instructions for transitioning an Azure Database for MySQL flexible server from using VNET integrated to using Public Access or Private Link via the Azure Portal are available in the article Move from private access to public access or Private Link with the Azure portal.
This post provides two bash scripts that use the Azure CLI to transition an Azure Database for MySQL flexible server from VNET integrated to Public Access or a Private Link. You can run these bash scripts either locally or by using the Azure Cloud Shell.
MysqlVnetToPublic.sh
You can use this script to transition from using VNET integrated to Public Access using a firewall rule. The flexible server’s underlying VNET and subnet are not changed. The script accepts one firewall rule as input, but you can modify it to add multiple firewall rules if required. The script detaches the VNET from the flexible server, enables Public Access, and then creates the firewall rule.
#!/bin/bash
#
# PURPOSE
# Migrate Azure Database for MySQL Flexible Server from VNET Integrated to Public Access
#
# DESCRIPTION
# Move from private access (virtual network integrated) to public access
# https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-network-from-private-to-public
#
# PREREQUISITES
# Azure CLI (https://docs.microsoft.com/en-us/cli/azure/install-azure-cli?view=azure-cli-latest)
#
# ARGUMENTS
# –subscription-id -s [Required] : Subscription ID.
# –resource-group-name -g [Required] : Name of resource group.
# –server-name -n [Required] : Name of the server.
# –rule-name -r [Required] : The name of the firewall rule. The firewall rule name can
# only contain 0-9, a-z, A-Z, ‘-‘ and ‘_’. Additionally, the name
# of the firewall rule must be at least 1 character and no more
# than 80 characters in length.
# –start-ip-address -a [Required] : The start IP address of the firewall rule. Must be IPv4 format.
# Use value ‘0.0.0.0’ to represent all Azure-internal IP addresses.
# –end-ip-address -b [Required] : The end IP address of the firewall rule. Must be IPv4 format.
# Use value ‘0.0.0.0’ to represent all Azure-internal IP addresses.
#
# USAGE
# bash mysqlVnetToPublic.sh
# –subscription-id ‘ffffffff-ffff-ffff-ffff-ffffffffffff’
# –resource-group-name ‘mysqlRG’
# –server-name ‘mysqlflex’
# –firewall-rule-name ‘allowiprange’
# –start-ip-address 107.46.14.0
# –end-ip-address 107.46.14.221
#
function usage()
{
echo “”
echo “PURPOSE”
echo “Migrate Azure Database for MySQL Flexible Server from VNET Integrated to Public Access”
echo “”
echo “DESCRIPTION”
echo “Move from private access (virtual network integrated) to public access”
echo “https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-network-from-private-to-public”
echo “”
echo “PREREQUISITES”
echo “Azure CLI (https://docs.microsoft.com/en-us/cli/azure/install-azure-cli?view=azure-cli-latest)”
echo “”
echo “ARGUMENTS”
echo ” –subscription-id -s [Required] : Subscription ID.”
echo ” –resource-group-name -g [Required] : Name of resource group.”
echo ” –server-name -n [Required] : Name of the server.”
echo ” –rule-name -r [Required] : The name of the firewall rule. The firewall rule name can”
echo ” only contain 0-9, a-z, A-Z, ‘-‘ and ‘_’. Additionally, the name”
echo ” of the firewall rule must be at least 1 character and no more”
echo ” than 80 characters in length.”
echo ” –start-ip-address -a [Required] : The start IP address of the firewall rule. Must be IPv4 format.”
echo ” Use value ‘0.0.0.0’ to represent all Azure-internal IP addresses.”
echo ” –end-ip-address -b [Required] : The end IP address of the firewall rule. Must be IPv4 format.”
echo ” Use value ‘0.0.0.0’ to represent all Azure-internal IP addresses.”
echo “”
echo “USAGE”
echo “bash mysqlVnetToPublic.sh”
echo -e “t–subscription-id ‘ffffffff-ffff-ffff-ffff-ffffffffffff'”
echo -e “t–resource-group-name ‘mysqlRG'”
echo -e “t–server-name ‘mysqlflex'”
echo -e “t–firewall-rule-name ‘allowiprange'”
echo -e “t–start-ip-address 107.46.14.0”
echo -e “t–end-ip-address 107.46.14.221”
echo “”
exit 1
}
PARAMS=””
while (( “$#” )); do
case “$1” in
-h | –help)
usage
exit
;;
-s|–subscription-id)
SUBSCRIPTION_ID=$2
shift 2
;;
-g|–resource-group-name)
RESOURCE_GROUP_NAME=$2
shift 2
;;
-n|–server-name)
SERVER_NAME=$2
shift 2
;;
-r|–firewall-rule-name)
FIREWALL_RULE_NAME=$2
shift 2
;;
-a|–start-ip-address)
START_IP_ADDRESS=$2
shift 2
;;
-b|–end-ip-address)
END_IP_ADDRESS=$2
shift 2
;;
–) # end argument parsing
shift
break
;;
-*|–*=) # unsupported flags
echo “Error: Unsupported flag $1” >&2
exit 1
;;
*) # preserve positional arguments
PARAMS=”$PARAMS $1″
shift
;;
esac
done
# set positional arguments in their proper place
eval set — “$PARAMS”
# Ensure required parameters are provided
if [ -z “$SUBSCRIPTION_ID” ]; then
echo “Error: Subscription ID is required”
usage
fi
if [ -z “$RESOURCE_GROUP_NAME” ]; then
echo “Error: Resource Group Name is required”
usage
fi
if [ -z “$SERVER_NAME” ]; then
echo “Error: Server Name is required”
usage
fi
if [ -z “$FIREWALL_RULE_NAME” ]; then
echo “Error: Firewall Rule Name is required”
usage
fi
if [ -z “$START_IP_ADDRESS” ]; then
echo “Error: Start IP Address is required”
usage
fi
if [ -z “$END_IP_ADDRESS” ]; then
echo “Error: End IP Address is required”
usage
fi
# Prerequisites – Install Azure CLI package
if ! [ -x “$(command -v az)” ]; then
echo ‘Error: azure cli is not installed. Please install from https://docs.microsoft.com/en-us/cli/azure/install-azure-cli?view=azure-cli-latest’ >&2
exit 1
fi
# Check if the subscription exists
if ! az account list –query “[?id==’$SUBSCRIPTION_ID’ || name==’$SUBSCRIPTION_ID’].id” -o tsv | grep -q .; then
echo “Subscription ‘$SUBSCRIPTION_ID’ does not exist.”
exit 1
fi
# Set subscription
az account set –subscription “$SUBSCRIPTION_ID”
# Check if the resource group exists
if ! az group show –name “$RESOURCE_GROUP_NAME” > /dev/null 2>&1; then
echo “Resource group ‘$RESOURCE_GROUP_NAME’ does not exist.”
exit 1
fi
# Check if the MySQL Flexible server exists
if ! az mysql flexible-server show –resource-group “$RESOURCE_GROUP_NAME” –name “$SERVER_NAME” > /dev/null 2>&1; then
echo “MySQL Flexible Server ‘$SERVER_NAME’ does not exist in resource group ‘$RESOURCE_GROUP_NAME’.”
exit 1
fi
# Ensure server is VNET Integrated
DELEGATED_SUBNET_RESOURCE_ID=$(az mysql flexible-server show –resource-group “$RESOURCE_GROUP_NAME” –name “$SERVER_NAME” –query “network.delegatedSubnetResourceId” –output tsv)
if [ -z “$DELEGATED_SUBNET_RESOURCE_ID” ]; then
echo “Error: MySQL Flexible Server is not VNET Integrated”
exit 1
fi
echo “Detaching VNET from server $SERVER_NAME”
az mysql flexible-server detach-vnet –resource-group “$RESOURCE_GROUP_NAME” –name “$SERVER_NAME” –public-network-access Enabled –yes
echo “Creating Firewall Rule on server $SERVER_NAME”
az mysql flexible-server firewall-rule create
–resource-group “$RESOURCE_GROUP_NAME”
–name “$SERVER_NAME”
–rule-name “$FIREWALL_RULE_NAME”
–start-ip-address “$START_IP_ADDRESS”
–end-ip-address “$END_IP_ADDRESS”
# Verify Firewall Rules
echo “Migration Successful !!”
echo “Check the firewall rules here : https://portal.azure.com/#resource/subscriptions/$SUBSCRIPTION_ID/resourceGroups/$RESOURCE_GROUP_NAME/providers/Microsoft.DBforMySQL/flexibleServers/$SERVER_NAME/networking”
MysqlVnetToPrivateEndpoint.sh
You can use this script to transition from using VNET integrated to Private Link. The script detaches the VNET from the flexible server, disables Public Access, removes any delegations on the subnet, and then creates the private endpoint on the same subnet. Removing delegation on a subnet is a prerequisite for using it to create private endpoints. Removing subnet delegation can fail if the subnet is still associated with other MySQL flexible servers. Additionally, the script also provides an option to integrate with Private DNS Zone, enabling access to the MySQL flexible server using the FQDN (for example, myserver.mysql.database.azure.com) from inside the VNET.
#!/bin/bash
#
# PURPOSE
# Migrate Azure Database for MySQL Flexible Server from VNET Integrated to PrivateLink
#
# DESCRIPTION
# Move from private access (virtual network integrated) to PrivateLink
# https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-network-from-private-to-public
#
# PREREQUISITES
# Azure CLI (https://docs.microsoft.com/en-us/cli/azure/install-azure-cli?view=azure-cli-latest)
#
# ARGUMENTS
# –subscription-id -s [Required] : Subscription ID.
# –resource-group-name -g [Required] : Name of resource group.
# –server-name -n [Required] : Name of the server.
# –private-endpoint-name -r [Required] : Name for the private endpoint.
# –integrate-private-dns-zone -z [Optional] : Whether to integrate with a new Private DNS Zone.
#
# USAGE
# bash mysqlVnetToPrivateEndpoint.sh
# –subscription-id ‘ffffffff-ffff-ffff-ffff-ffffffffffff’
# –resource-group-name ‘mysqlRG’
# –server-name ‘mysqlflex’
# –private-endpoint-name ‘mysqlpe’
# –integrate-private-dns-zone false
#
function usage()
{
echo “”
echo “PURPOSE”
echo “Migrate Azure Database for MySQL Flexible Server from VNET Integrated to PrivateLink”
echo “”
echo “DESCRIPTION”
echo “Move from private access (virtual network integrated) to PrivateLink”
echo “https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-network-from-private-to-public”
echo “”
echo “PREREQUISITES”
echo “Azure CLI (https://docs.microsoft.com/en-us/cli/azure/install-azure-cli?view=azure-cli-latest)”
echo “”
echo “ARGUMENTS”
echo ” –subscription-id -s [Required] : Subscription ID.”
echo ” –resource-group-name -g [Required] : Name of resource group.”
echo ” –server-name -n [Required] : Name of the server.”
echo ” –private-endpoint-name -r [Required] : Name for the private endpoint.”
echo ” –integrate-private-dns-zone -z [Optional] : Whether to integrate with a new Private DNS Zone. Defaults to False”
echo “”
echo “USAGE”
echo “bash mysqlVnetToPrivateEndpoint.sh”
echo -e “t–subscription-id ‘ffffffff-ffff-ffff-ffff-ffffffffffff'”
echo -e “t–resource-group-name ‘mysqlRG'”
echo -e “t–server-name ‘mysqlflex'”
echo -e “t–private-endpoint-name ‘mysqlpe'”
echo -e “t–integrate-private-dns-zone false”
echo “”
exit 1
}
PARAMS=””
while (( “$#” )); do
case “$1” in
-h| –help)
usage
exit
;;
-s|–subscription-id)
SUBSCRIPTION_ID=$2
shift 2
;;
-g|–resource-group-name)
RESOURCE_GROUP_NAME=$2
shift 2
;;
-n|–server-name)
SERVER_NAME=$2
shift 2
;;
-r|–private-endpoint-name)
PRIVATE_ENDPOINT_NAME=$2
shift 2
;;
-z|–integrate-private-dns-zone)
INTEGRATE_PRIVATE_DNS_ZONE=$2
shift 2
;;
–) # end argument parsing
shift
break
;;
-*|–*=) # unsupported flags
echo “Error: Unsupported flag $1” >&2
exit 1
;;
*) # preserve positional arguments
PARAMS=”$PARAMS $1″
shift
;;
esac
done
# set positional arguments in their proper place
eval set — “$PARAMS”
# Ensure required parameters are provided
if [ -z “$SUBSCRIPTION_ID” ]; then
echo “Error: Subscription ID is required”
usage
fi
if [ -z “$RESOURCE_GROUP_NAME” ]; then
echo “Error: Resource Group Name is required”
usage
fi
if [ -z “$SERVER_NAME” ]; then
echo “Error: Server Name is required”
usage
fi
if [ -z “$PRIVATE_ENDPOINT_NAME” ]; then
echo “Error: Private Endpoint Name is required”
usage
fi
if [ -z “$INTEGRATE_PRIVATE_DNS_ZONE” ]; then
INTEGRATE_PRIVATE_DNS_ZONE=false
else
if [ “$INTEGRATE_PRIVATE_DNS_ZONE” != “true” ] && [ “$INTEGRATE_PRIVATE_DNS_ZONE” != “false” ]; then
echo “Error: –integrate-private-dns-zone must be either true or false”
usage
fi
fi
# Prerequisites – Install Azure CLI package
if ! [ -x “$(command -v az)” ]; then
echo ‘Error: azure cli is not installed. Please install from https://docs.microsoft.com/en-us/cli/azure/install-azure-cli?view=azure-cli-latest’ >&2
exit 1
fi
# Check if the subscription exists
if ! az account list –query “[?id==’$SUBSCRIPTION_ID’ || name==’$SUBSCRIPTION_ID’].id” -o tsv | grep -q .; then
echo “Subscription ‘$SUBSCRIPTION_ID’ does not exist.”
exit 1
fi
# Set subscription
az account set –subscription “$SUBSCRIPTION_ID”
# Check if the resource group exists
if ! az group show –name “$RESOURCE_GROUP_NAME” > /dev/null 2>&1; then
echo “Resource group ‘$RESOURCE_GROUP_NAME’ does not exist.”
exit 1
fi
# Check if the MySQL Flexible server exists
if ! az mysql flexible-server show –resource-group “$RESOURCE_GROUP_NAME” –name “$SERVER_NAME” > /dev/null 2>&1; then
echo “MySQL Flexible Server ‘$SERVER_NAME’ does not exist in resource group ‘$RESOURCE_GROUP_NAME’.”
exit 1
fi
# Get VNET and subnet details
echo “Obtaining Vnet and Subnet details for server $SERVER_NAME”
DELEGATED_SUBNET_RESOURCE_ID=$(az mysql flexible-server show –resource-group “$RESOURCE_GROUP_NAME” –name “$SERVER_NAME” –query “network.delegatedSubnetResourceId” –output tsv)
# Ensure server is VNET Integrated
if [ -z “$DELEGATED_SUBNET_RESOURCE_ID” ]; then
echo “Error: MySQL Flexible Server is not VNET Integrated”
exit 1
fi
# Extract VNET and Subnet details
VNET_SUB=$(echo $DELEGATED_SUBNET_RESOURCE_ID | cut -d “/” -f 3)
VNET_RG=$(echo $DELEGATED_SUBNET_RESOURCE_ID | cut -d “/” -f 5)
VNET=$(echo $DELEGATED_SUBNET_RESOURCE_ID | cut -d “/” -f 9)
SUBNET=$(echo $DELEGATED_SUBNET_RESOURCE_ID | cut -d “/” -f 11)
echo “VNET Subscription ID : $VNET_SUB”
echo “VNET Resource Group : $VNET_RG”
echo “VNET Name : $VNET”
echo “Subnet Name : $SUBNET”
echo “Detaching VNET $VNET from server $SERVER_NAME”
az mysql flexible-server detach-vnet –resource-group “$RESOURCE_GROUP_NAME” –name “$SERVER_NAME” –public-network-access Disabled –yes
echo “Removing Delegations on Subnet $DELEGATED_SUBNET_RESOURCE_ID”
az network vnet subnet update –ids “$DELEGATED_SUBNET_RESOURCE_ID” –remove delegations
MYSQL_FLEX_RESOURCE_ID=$(az mysql flexible-server show –resource-group “$RESOURCE_GROUP_NAME” –name “$SERVER_NAME” –query “id” –output tsv)
MYSQL_FLEX_LOCATION=$(az mysql flexible-server show –resource-group “$RESOURCE_GROUP_NAME” –name “$SERVER_NAME” –query “location” –output tsv)
echo “Creating Private Endpoint $PRIVATE_ENDPOINT_NAME using Subnet $DELEGATED_SUBNET_RESOURCE_ID”
az network private-endpoint create
–resource-group “$VNET_RG”
–vnet-name “$VNET”
–subnet “$SUBNET”
–private-connection-resource-id “$MYSQL_FLEX_RESOURCE_ID”
–group-id mysqlServer
–connection-name “$PRIVATE_ENDPOINT_NAME”
–name “$PRIVATE_ENDPOINT_NAME”
–location “$MYSQL_FLEX_LOCATION”
if [ “$INTEGRATE_PRIVATE_DNS_ZONE” == “true” ]; then
echo “Creating Private DNS Zone”
az network private-dns zone create
–resource-group “$VNET_RG”
–name “privatelink.mysql.database.azure.com”
echo “Linking Private DNS Zone with VNET $VNET”
az network private-dns link vnet create
–resource-group “$VNET_RG”
–zone-name “privatelink.mysql.database.azure.com”
–name “${VNET}Link”
–virtual-network “$VNET”
–registration-enabled false
echo “Creating Private DNS Zone Group”
az network private-endpoint dns-zone-group create
–resource-group “$VNET_RG”
–endpoint-name “$PRIVATE_ENDPOINT_NAME”
–name “${PRIVATE_ENDPOINT_NAME}ZoneGroup”
–private-dns-zone “privatelink.mysql.database.azure.com”
–zone-name mysqlServer
fi
# Verify Private Endpoints
echo “Migration Successful !!”
echo “Check the private endpoints here : https://portal.azure.com/#resource/subscriptions/$SUBSCRIPTION_ID/resourceGroups/$RESOURCE_GROUP_NAME/providers/Microsoft.DBforMySQL/flexibleServers/$SERVER_NAME/networking”
Try them out!
We encourage you to try out these scripts to help streamline your transition processes. You can download them from the following GitHub repo folder: Azure/azure-mysql/scripts
mysqlVnetToPublic.sh
mysqlVnetToPrivateEndpoint.sh
If you have any queries or suggestions, please let us know by leaving a comment below or by contacting directly us at AskAzureDBforMySQL@service.microsoft.com.
Microsoft Tech Community – Latest Blogs –Read More
How to draw isolines between points?
Hello everyone!
I have points with known geographic coordinates and certain values. How do I draw isolines (lines of equal values) or a continuous color field between them on the map?Hello everyone!
I have points with known geographic coordinates and certain values. How do I draw isolines (lines of equal values) or a continuous color field between them on the map? Hello everyone!
I have points with known geographic coordinates and certain values. How do I draw isolines (lines of equal values) or a continuous color field between them on the map? map, isolines, contour MATLAB Answers — New Questions
Why is my modified path not saved in MATLAB?
I am modifying my MATLAB path by using either the "Set Path" button in the toolbar, or by using the "addpath" and "savepath" commands in the MATLAB Command Window. However, when I exit MATLAB and restart it, the MATLAB search path does not reflect the changes that I had made.
Why are my MATLAB path modifications not saved in the new session of MATLAB?I am modifying my MATLAB path by using either the "Set Path" button in the toolbar, or by using the "addpath" and "savepath" commands in the MATLAB Command Window. However, when I exit MATLAB and restart it, the MATLAB search path does not reflect the changes that I had made.
Why are my MATLAB path modifications not saved in the new session of MATLAB? I am modifying my MATLAB path by using either the "Set Path" button in the toolbar, or by using the "addpath" and "savepath" commands in the MATLAB Command Window. However, when I exit MATLAB and restart it, the MATLAB search path does not reflect the changes that I had made.
Why are my MATLAB path modifications not saved in the new session of MATLAB? addpath, savepath MATLAB Answers — New Questions
compute rotation angle of binary shape image without having primary image(image before rotation)
I have some binary image of letters.I need to rotate these letters shapes X degree, then compute the degree of rotation (X) without having the first letters shapes image (Not-Rotated shapes).
I tested several ways. I used RegionProps.Rotation(RP.R), but had little accuracy.
For example if RP.R is 90 degree, after 5 degree rotation with imrotate method, it will be 80 degree instead 85 degree.
Also I used minimum bounding box;before and after rotating the shapes, I measure the angle between square diagonal and x-axis, or on side of square and x-axis. In this way,for some shapes of letters, measure specified angle after rotating the shape and it was inaccurate and in some cases after X degree rotation(X = 2,3, or 5 degree),the specified angle was unchanged (figure1).
<</matlabcentral/answers/uploaded_files/106773/Figure2.png>>
I want to familiar me with a solution for this problem with these constraints:
-we don’t have the ascii code.
-we couldn’t used OCR for letter detection
-for angle calculation,we don’t have the primary image shape.
thank you.I have some binary image of letters.I need to rotate these letters shapes X degree, then compute the degree of rotation (X) without having the first letters shapes image (Not-Rotated shapes).
I tested several ways. I used RegionProps.Rotation(RP.R), but had little accuracy.
For example if RP.R is 90 degree, after 5 degree rotation with imrotate method, it will be 80 degree instead 85 degree.
Also I used minimum bounding box;before and after rotating the shapes, I measure the angle between square diagonal and x-axis, or on side of square and x-axis. In this way,for some shapes of letters, measure specified angle after rotating the shape and it was inaccurate and in some cases after X degree rotation(X = 2,3, or 5 degree),the specified angle was unchanged (figure1).
<</matlabcentral/answers/uploaded_files/106773/Figure2.png>>
I want to familiar me with a solution for this problem with these constraints:
-we don’t have the ascii code.
-we couldn’t used OCR for letter detection
-for angle calculation,we don’t have the primary image shape.
thank you. I have some binary image of letters.I need to rotate these letters shapes X degree, then compute the degree of rotation (X) without having the first letters shapes image (Not-Rotated shapes).
I tested several ways. I used RegionProps.Rotation(RP.R), but had little accuracy.
For example if RP.R is 90 degree, after 5 degree rotation with imrotate method, it will be 80 degree instead 85 degree.
Also I used minimum bounding box;before and after rotating the shapes, I measure the angle between square diagonal and x-axis, or on side of square and x-axis. In this way,for some shapes of letters, measure specified angle after rotating the shape and it was inaccurate and in some cases after X degree rotation(X = 2,3, or 5 degree),the specified angle was unchanged (figure1).
<</matlabcentral/answers/uploaded_files/106773/Figure2.png>>
I want to familiar me with a solution for this problem with these constraints:
-we don’t have the ascii code.
-we couldn’t used OCR for letter detection
-for angle calculation,we don’t have the primary image shape.
thank you. text image processing, text image rotation, image processing MATLAB Answers — New Questions
Help with time variation graphs versus time
Hi everyone.
Can you help me on how I can obtain this type of graphs (see example), which represent amplitude variations at a certain frequency with respect to time. Note that the Y axis is in logarithmic. A small sample of my data is:
Date time Freq Amplitude
2010/01/01 00:00 0.109864 2.04021
2010/01/01 00:00 0.122071 2.8937
2010/01/01 00:00 0.134278 2.84502
2010/01/01 00:00 0.146485 2.92267
2010/01/01 00:00 0.158692 3.11156
2010/01/01 00:00 0.170899 3.41533
2010/01/01 00:00 0.183107 3.10193
2010/01/01 00:00 0.195314 3.32969
2010/01/01 00:00 0.207521 3.29483
2010/01/01 00:00 0.219728 3.21573
Thank to allHi everyone.
Can you help me on how I can obtain this type of graphs (see example), which represent amplitude variations at a certain frequency with respect to time. Note that the Y axis is in logarithmic. A small sample of my data is:
Date time Freq Amplitude
2010/01/01 00:00 0.109864 2.04021
2010/01/01 00:00 0.122071 2.8937
2010/01/01 00:00 0.134278 2.84502
2010/01/01 00:00 0.146485 2.92267
2010/01/01 00:00 0.158692 3.11156
2010/01/01 00:00 0.170899 3.41533
2010/01/01 00:00 0.183107 3.10193
2010/01/01 00:00 0.195314 3.32969
2010/01/01 00:00 0.207521 3.29483
2010/01/01 00:00 0.219728 3.21573
Thank to all Hi everyone.
Can you help me on how I can obtain this type of graphs (see example), which represent amplitude variations at a certain frequency with respect to time. Note that the Y axis is in logarithmic. A small sample of my data is:
Date time Freq Amplitude
2010/01/01 00:00 0.109864 2.04021
2010/01/01 00:00 0.122071 2.8937
2010/01/01 00:00 0.134278 2.84502
2010/01/01 00:00 0.146485 2.92267
2010/01/01 00:00 0.158692 3.11156
2010/01/01 00:00 0.170899 3.41533
2010/01/01 00:00 0.183107 3.10193
2010/01/01 00:00 0.195314 3.32969
2010/01/01 00:00 0.207521 3.29483
2010/01/01 00:00 0.219728 3.21573
Thank to all spectrogram, hvgram, temporal variations MATLAB Answers — New Questions