Month: August 2024
Every other row is blank when downloading .csv files
When viewing .csv files with Notepad, everything looks great.
However, when I open these files, every other row is blank including the header row.
Is the problem on my end with various format selections, or the party sending me these files with, perhaps, and extra line feed tacked onto the end of each record?
Getting rid of every other blank line is manually time consuming and should not be there in the first place.
Thank you for any suggestions.
When viewing .csv files with Notepad, everything looks great.However, when I open these files, every other row is blank including the header row.Is the problem on my end with various format selections, or the party sending me these files with, perhaps, and extra line feed tacked onto the end of each record?Getting rid of every other blank line is manually time consuming and should not be there in the first place.Thank you for any suggestions. Read More
Comments on pages turning itself on
Is anyone else experiencing this?
For about 3 weeks, definitely since the changes to SPO page editing were rolled out, the Comments feature on SharePoint pages has been toggling itself on when I edit existing pages.
It doesn’t always happen.It doesn’t matter if I was the last person to edit or not. Now I have to scroll to the bottom of every page that I edit, whether or not I actually made changes, and check to make sure that this is toggled off.
This behavior was present a few years ago. It is very frustrating. Any feedback would be appreciated.
Is anyone else experiencing this? For about 3 weeks, definitely since the changes to SPO page editing were rolled out, the Comments feature on SharePoint pages has been toggling itself on when I edit existing pages.It doesn’t always happen.It doesn’t matter if I was the last person to edit or not. Now I have to scroll to the bottom of every page that I edit, whether or not I actually made changes, and check to make sure that this is toggled off.This behavior was present a few years ago. It is very frustrating. Any feedback would be appreciated. Read More
XLook Up
I have 3 workbooks. One called PO number system and one for each project manager.
Workbook 1 – PO Number system
Workbook 2 – Marc
Workbook 3 – Kyle
On the PO Number System, Column A is dropdown for project manager name.
Column B is PO number (generated from formula tied to Customer List in same workbook)
I want the project manager to be able to fill in the remainder of the columns (C-K) and it automatically fill in on their corresponding workbook – if Column A2 on PO Number System Workbook says Marc, then I want Marc’s workbook to automatically fill in everything associated with that line 2 from the PO Number System Column. If it doesn’t say Marc’s name, then nothing happens to his spreadsheet. If A2 says Kyle, then everything should fill in on Kyle’s workbook.
Spreadsheets attached for reference.
I have 3 workbooks. One called PO number system and one for each project manager.Workbook 1 – PO Number systemWorkbook 2 – MarcWorkbook 3 – KyleOn the PO Number System, Column A is dropdown for project manager name.Column B is PO number (generated from formula tied to Customer List in same workbook)I want the project manager to be able to fill in the remainder of the columns (C-K) and it automatically fill in on their corresponding workbook – if Column A2 on PO Number System Workbook says Marc, then I want Marc’s workbook to automatically fill in everything associated with that line 2 from the PO Number System Column. If it doesn’t say Marc’s name, then nothing happens to his spreadsheet. If A2 says Kyle, then everything should fill in on Kyle’s workbook.Spreadsheets attached for reference. Read More
? (help) button not responding
Every time I try to use the ? (help) button in either Excel or PowerPoint, I get a message that reads, “Sorry, something went wrong. Please check your internet connection and try again.” This does not happen when I am using Word. Any ideas on why? Thanks.
Every time I try to use the ? (help) button in either Excel or PowerPoint, I get a message that reads, “Sorry, something went wrong. Please check your internet connection and try again.” This does not happen when I am using Word. Any ideas on why? Thanks. Read More
Booking Appointment Graph API Update No Longer Updates Service Name
The service name property of an appointment was previously editable per docs and testing.
https://learn.microsoft.com/en-us/graph/api/bookingappointment-update?view=graph-rest-1.0
Now when an update occurs via API, the service name completely resets to the default service name of the appointments service ID. You can still pass the service name when creating and appointment via the API, but any updates will break it. Anyone else experiencing this issue?
The service name property of an appointment was previously editable per docs and testing.https://learn.microsoft.com/en-us/graph/api/bookingappointment-update?view=graph-rest-1.0Now when an update occurs via API, the service name completely resets to the default service name of the appointments service ID. You can still pass the service name when creating and appointment via the API, but any updates will break it. Anyone else experiencing this issue? Read More
Linking a project to a porfolio
We have five project portfolios consisting of 7-25 sub-projects. Recently, we added a project online to our desktop 2019 version to allow project managers access to their project files. In the past, if we updated a single project, its respective portfolio would automatically be updated. Since we started using Project Online, we get errors when we update projects. Does the online project interfere with the desktop version when working with project portfolios?
Thanks.
Teshome
We have five project portfolios consisting of 7-25 sub-projects. Recently, we added a project online to our desktop 2019 version to allow project managers access to their project files. In the past, if we updated a single project, its respective portfolio would automatically be updated. Since we started using Project Online, we get errors when we update projects. Does the online project interfere with the desktop version when working with project portfolios? Thanks.Teshome Read More
Unable to pass employment verification, and now the process has been ended!
Hello,
I’ve been trying to get past the “employment verification” step for almost a month now. In the “fix now” menu, I was asked to provide the domain registration receipt, which I’ve submitted multiple times. I opened a ticket and was advised to change my email address to something non-generic, which I did. However, I haven’t received any further updates. I’ve followed up multiple times, only to receive the same automated response: “We’re looking into your issue and will provide an update.” Today, I received an email stating that after several unsuccessful attempts to verify my information, the verification process has been terminated. This is very frustrating, as all my information is legit, and there seems to be no reason my profile shouldn’t be approved.
Please assist, as opening tickets doesn’t seem to move the process forward at all.
Thank you!
Hello,I’ve been trying to get past the “employment verification” step for almost a month now. In the “fix now” menu, I was asked to provide the domain registration receipt, which I’ve submitted multiple times. I opened a ticket and was advised to change my email address to something non-generic, which I did. However, I haven’t received any further updates. I’ve followed up multiple times, only to receive the same automated response: “We’re looking into your issue and will provide an update.” Today, I received an email stating that after several unsuccessful attempts to verify my information, the verification process has been terminated. This is very frustrating, as all my information is legit, and there seems to be no reason my profile shouldn’t be approved.Please assist, as opening tickets doesn’t seem to move the process forward at all.Thank you! Read More
Passwords are missing from Edge Wallet
My passwords suddenly went missing from Edge Wallet but the passwords are still being populated on websites. Can you please advise how to restore my passwords to Edge Wallet?
My passwords suddenly went missing from Edge Wallet but the passwords are still being populated on websites. Can you please advise how to restore my passwords to Edge Wallet? Read More
World magnetic model frame of reference??
I am using the world magnetic model function wrldmagm as part of a scrip, but the help page that describes the function provides no information about the reference frame used for the magnetic vector. The simulink block seems to use North-East-Down, would it be safe to assume that the script function does the same?I am using the world magnetic model function wrldmagm as part of a scrip, but the help page that describes the function provides no information about the reference frame used for the magnetic vector. The simulink block seems to use North-East-Down, would it be safe to assume that the script function does the same? I am using the world magnetic model function wrldmagm as part of a scrip, but the help page that describes the function provides no information about the reference frame used for the magnetic vector. The simulink block seems to use North-East-Down, would it be safe to assume that the script function does the same? worldmagneticmodel MATLAB Answers — New Questions
Calling a function with no arguments
Hi All,
In my program , I’m trying to call a function with some input arguments but no outputs as I’m using this function for the purpose of plotting.
How should its syntax look like?
[ ] = function_name( var1,var2,var3) // This line is giving me erorr : Assigning an output to an empty array is not supported.
Please suggest me a way to handle this error.
Thanks in advance!Hi All,
In my program , I’m trying to call a function with some input arguments but no outputs as I’m using this function for the purpose of plotting.
How should its syntax look like?
[ ] = function_name( var1,var2,var3) // This line is giving me erorr : Assigning an output to an empty array is not supported.
Please suggest me a way to handle this error.
Thanks in advance! Hi All,
In my program , I’m trying to call a function with some input arguments but no outputs as I’m using this function for the purpose of plotting.
How should its syntax look like?
[ ] = function_name( var1,var2,var3) // This line is giving me erorr : Assigning an output to an empty array is not supported.
Please suggest me a way to handle this error.
Thanks in advance! function MATLAB Answers — New Questions
Why do I get errors related to Updaters during the Hardware Setup of the “Embedded Coder Support Package for STMicroelectronics STM32 Processors”?
I installed the "Embedded Coder Support Package for STMicroelectronics STM32 Processors", but I am unable to complete the Hardware Setup.
At the "Install STM32Cube Firmware" stage, I click the "Install" button and get error such as the following:
[ERROR] AnalyticsContext:980 – The ST intranet updater server is unknown: mcucrossselector.codex.cro.st.com
[ERROR] WebUtils:643 – Updater is busy
[ERROR] HomeAdPanel:114 – Failed to refresh advertisement data
[ERROR] WebUtils:384 – Updater is busy
[ERROR] WebUtils:384 – Updater is busy
[ERROR] WebUtils:384 – Updater is busy
[ERROR] MainUpdater:2088 – Updater is busy
Or:
[ERROR] AnalyticsContext:980 – The ST intranet updater server is unknown: mcucrossselector.codex.cro.st.com
[ERROR] ServerAccessManage:1058 – Problem during Server Connexion : IO error PKIX path building failed:
sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
[ERROR] ServerAccessManage:537 – Problem during Server Connexion : : updaters.zip.
[ERROR] ServerAccessManage:1032 – Warning during Server Connexion : Unknown host www.ebuc23.com
[ERROR] ServerAccessManage:537 – Unknown host server name. : updaters.zip.
[ERROR] Engine:463 – C:UsersPede.stm32cubemxthirdpartiespdscEmbeddedOffice.I-CUBE-FS-RTOS.1.0.1.pdsc:
PDSC version is not supported
swmgr refresh
[ERROR] ServerAccessManage:1058 – Problem during Server Connexion : IO error PKIX path building failed:
sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
[ERROR] ServerAccessManage:537 – Problem during Server Connexion : : updaters.zip.
[ERROR] ServerAccessManage:1032 – Warning during Server Connexion : Unknown host www.ebuc23.com
[ERROR] ServerAccessManage:537 – Unknown host server name. : updaters.zip.
[INFO] CheckServerUpdateThread:115 – End of CheckServer Thread
[INFO] LoadServerUpdatesThread:339 – End of LoadServerUpdate ThreadI installed the "Embedded Coder Support Package for STMicroelectronics STM32 Processors", but I am unable to complete the Hardware Setup.
At the "Install STM32Cube Firmware" stage, I click the "Install" button and get error such as the following:
[ERROR] AnalyticsContext:980 – The ST intranet updater server is unknown: mcucrossselector.codex.cro.st.com
[ERROR] WebUtils:643 – Updater is busy
[ERROR] HomeAdPanel:114 – Failed to refresh advertisement data
[ERROR] WebUtils:384 – Updater is busy
[ERROR] WebUtils:384 – Updater is busy
[ERROR] WebUtils:384 – Updater is busy
[ERROR] MainUpdater:2088 – Updater is busy
Or:
[ERROR] AnalyticsContext:980 – The ST intranet updater server is unknown: mcucrossselector.codex.cro.st.com
[ERROR] ServerAccessManage:1058 – Problem during Server Connexion : IO error PKIX path building failed:
sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
[ERROR] ServerAccessManage:537 – Problem during Server Connexion : : updaters.zip.
[ERROR] ServerAccessManage:1032 – Warning during Server Connexion : Unknown host www.ebuc23.com
[ERROR] ServerAccessManage:537 – Unknown host server name. : updaters.zip.
[ERROR] Engine:463 – C:UsersPede.stm32cubemxthirdpartiespdscEmbeddedOffice.I-CUBE-FS-RTOS.1.0.1.pdsc:
PDSC version is not supported
swmgr refresh
[ERROR] ServerAccessManage:1058 – Problem during Server Connexion : IO error PKIX path building failed:
sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
[ERROR] ServerAccessManage:537 – Problem during Server Connexion : : updaters.zip.
[ERROR] ServerAccessManage:1032 – Warning during Server Connexion : Unknown host www.ebuc23.com
[ERROR] ServerAccessManage:537 – Unknown host server name. : updaters.zip.
[INFO] CheckServerUpdateThread:115 – End of CheckServer Thread
[INFO] LoadServerUpdatesThread:339 – End of LoadServerUpdate Thread I installed the "Embedded Coder Support Package for STMicroelectronics STM32 Processors", but I am unable to complete the Hardware Setup.
At the "Install STM32Cube Firmware" stage, I click the "Install" button and get error such as the following:
[ERROR] AnalyticsContext:980 – The ST intranet updater server is unknown: mcucrossselector.codex.cro.st.com
[ERROR] WebUtils:643 – Updater is busy
[ERROR] HomeAdPanel:114 – Failed to refresh advertisement data
[ERROR] WebUtils:384 – Updater is busy
[ERROR] WebUtils:384 – Updater is busy
[ERROR] WebUtils:384 – Updater is busy
[ERROR] MainUpdater:2088 – Updater is busy
Or:
[ERROR] AnalyticsContext:980 – The ST intranet updater server is unknown: mcucrossselector.codex.cro.st.com
[ERROR] ServerAccessManage:1058 – Problem during Server Connexion : IO error PKIX path building failed:
sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
[ERROR] ServerAccessManage:537 – Problem during Server Connexion : : updaters.zip.
[ERROR] ServerAccessManage:1032 – Warning during Server Connexion : Unknown host www.ebuc23.com
[ERROR] ServerAccessManage:537 – Unknown host server name. : updaters.zip.
[ERROR] Engine:463 – C:UsersPede.stm32cubemxthirdpartiespdscEmbeddedOffice.I-CUBE-FS-RTOS.1.0.1.pdsc:
PDSC version is not supported
swmgr refresh
[ERROR] ServerAccessManage:1058 – Problem during Server Connexion : IO error PKIX path building failed:
sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
[ERROR] ServerAccessManage:537 – Problem during Server Connexion : : updaters.zip.
[ERROR] ServerAccessManage:1032 – Warning during Server Connexion : Unknown host www.ebuc23.com
[ERROR] ServerAccessManage:537 – Unknown host server name. : updaters.zip.
[INFO] CheckServerUpdateThread:115 – End of CheckServer Thread
[INFO] LoadServerUpdatesThread:339 – End of LoadServerUpdate Thread MATLAB Answers — New Questions
FAQs from Mastering the Marketplace: Developing your virtual machine offer
Developing your virtual machine offer is a webinar offered regularly through the Mastering the Marketplace series. This session reviews the required technical configurations to make Virtual Machine apps and how to publish virtual machines offers to the Azure marketplace.
Looking for additional guidance with Virtual Machines? An Azure technical expert will take you through:
A brief overview of what a virtual Machine offer type is.
How to publish a Virtual machine offer and integrate the solution from the Azure Portal tool to Partner center.
How to setup Tenants.
How to create different plans to best suit your customers’ needs
How to use Cloud-init within the Azure Portal.
Attendees can also participate in a short Q&A following the session.
Below is a list of recently asked questions from this session.
Q1. Once I published the image to the gallery, does it make sense to keep the generalized VM around (if yes, then for what purpose?) or may I delete it?
A: You can delete the image after the offer is published live on the marketplace. At full publish, MS maintains a registry of your images, so you no longer have to hold on to it.
Q2. Does the standard Microsoft Marketplace agreement work both for transactable and non-transactable?
A: Yes it does. It simply is an option for your T&C if you don’t have your own.
Q3. Last time we used the Direct Shared Gallery it was in Preview and sharing was severely limited (only a few tenants and subscriptions). What is the situation now?
A: As of August 2024 it still has these limitations. You can share it across subscriptions on the same tenant but not across tenants. If that doesn’t work, you can use a vhd link to publish the VM offer.
__________________________________________________________
Additional Resources:
Register for the next webinar on Developing your virtual machine offer, August 20 at 9 am PT.
Register for additional Mastering the Marketplace webinars here.
Developing your virtual machine offer is a webinar offered regularly through the Mastering the Marketplace series. This session reviews the required technical configurations to make Virtual Machine apps and how to publish virtual machines offers to the Azure marketplace.
Looking for additional guidance with Virtual Machines? An Azure technical expert will take you through:
A brief overview of what a virtual Machine offer type is.
How to publish a Virtual machine offer and integrate the solution from the Azure Portal tool to Partner center.
How to setup Tenants.
How to create different plans to best suit your customers’ needs
How to use Cloud-init within the Azure Portal.
Attendees can also participate in a short Q&A following the session.
Below is a list of recently asked questions from this session.
Q1. Once I published the image to the gallery, does it make sense to keep the generalized VM around (if yes, then for what purpose?) or may I delete it?
A: You can delete the image after the offer is published live on the marketplace. At full publish, MS maintains a registry of your images, so you no longer have to hold on to it.
Q2. Does the standard Microsoft Marketplace agreement work both for transactable and non-transactable?
A: Yes it does. It simply is an option for your T&C if you don’t have your own.
Q3. Last time we used the Direct Shared Gallery it was in Preview and sharing was severely limited (only a few tenants and subscriptions). What is the situation now?
A: As of August 2024 it still has these limitations. You can share it across subscriptions on the same tenant but not across tenants. If that doesn’t work, you can use a vhd link to publish the VM offer.
__________________________________________________________
Additional Resources:
Register for the next webinar on Developing your virtual machine offer, August 20 at 9 am PT.
Register for additional Mastering the Marketplace webinars here. Read More
Regarding Windows 11 24H2 Pro Insider Preview Release Preview Build 26100.1301…
Hello to all. Recently today I just got this upon restarting my computer and I am wondering if it is possibly my M2 NVME SSD or just a possible glitch in Windows 11 24H2 Pro currently and if so is there any possible workaround or fix out yet to fix this problem at hand on my computer..?? Here is the exact error message upon restarting my computer and btw it does not always happen it just happens occasionally at most I believe.
Application popup: explorer.exe – Application Error : The instruction at 0x00007FFE2543981D referenced memory at 0x0000000000000024. The memory could not be written.
Click on OK to terminate the program
I am open to any ideas here in order to possible fix or workaround the problem at this time..!! Thanks in advance for your time and efforts as well as listening and Have a great day ahead and stay safe also!!..
Hello to all. Recently today I just got this upon restarting my computer and I am wondering if it is possibly my M2 NVME SSD or just a possible glitch in Windows 11 24H2 Pro currently and if so is there any possible workaround or fix out yet to fix this problem at hand on my computer..?? Here is the exact error message upon restarting my computer and btw it does not always happen it just happens occasionally at most I believe. Application popup: explorer.exe – Application Error : The instruction at 0x00007FFE2543981D referenced memory at 0x0000000000000024. The memory could not be written.Click on OK to terminate the programI am open to any ideas here in order to possible fix or workaround the problem at this time..!! Thanks in advance for your time and efforts as well as listening and Have a great day ahead and stay safe also!!.. Read More
New Shared Channels Grayed Out
Hello,
We’re having an issue as of this morning where Shared Channels do not seem to take when created. When I try to create a Shared Channel in the Admin Center it doesn’t show up in the list of channels, even when I go to manage the Team through the Teams app and look at the channels that way.
If I or a user creates a Shared Channel in Teams through the app it shows only for the person who created it, but it’s grayed out, you cannot interact with it, and does not appear in the list of channels when managing the Team through the app or the Admin Center.
Standard and Private channels are working as expected. I tried on multiple Teams to make sure it wasn’t an issue with a certain Team. I checked all the settings I could think of that could be blocking it even though none of them should have changed since the last time I was able to successfully create a Shared Channel.
Any idea as to what is going on? Anyone else experiencing this?
Update: They all decided to show up, but now I can’t delete any of the ones we created while trying to get it to work.
Hello, We’re having an issue as of this morning where Shared Channels do not seem to take when created. When I try to create a Shared Channel in the Admin Center it doesn’t show up in the list of channels, even when I go to manage the Team through the Teams app and look at the channels that way. If I or a user creates a Shared Channel in Teams through the app it shows only for the person who created it, but it’s grayed out, you cannot interact with it, and does not appear in the list of channels when managing the Team through the app or the Admin Center. Standard and Private channels are working as expected. I tried on multiple Teams to make sure it wasn’t an issue with a certain Team. I checked all the settings I could think of that could be blocking it even though none of them should have changed since the last time I was able to successfully create a Shared Channel. Any idea as to what is going on? Anyone else experiencing this? Update: They all decided to show up, but now I can’t delete any of the ones we created while trying to get it to work. Read More
Similarity checker
Can anyone advise me please, I’ve tried all the recommendations to rectify the similarity checker, but it’s still not working, can anyone help me please.
Can anyone advise me please, I’ve tried all the recommendations to rectify the similarity checker, but it’s still not working, can anyone help me please. Read More
exeal file is not working
I AMIT KHINDRI START TO EXEAL NOT WORKING FOR EXEAL PLZ CHEAK & COMNEUCATE
hello I AMIT KHINDRI START TO EXEAL NOT WORKING FOR EXEAL PLZ CHEAK & COMNEUCATE Read More
Easy HashTable Question
I’m tragically stuck on what I know is a simple query.
For context, I’m trying to update a Bookings calendar service business hours through PowerShell.
The cmdlet is Update-MgBookingBusinessService.
The relevant JSON that is returned from Get-MgBookingBusinessService is below.
“schedulingPolicy”: {
“generalAvailability”: {
“availabilityType”: “customWeeklyHours”,
“businessHours”: [
{
“day”: “monday”,
“timeSlots”: [
{
“startTime”: “10:30:00.0000000”,
“endTime”: “18:30:00.0000000”
}
]
},
{
“day”: “tuesday”,
“timeSlots”: [
{
“startTime”: “10:30:00.0000000”,
“endTime”: “18:30:00.0000000”
}
]
},
{
“day”: “wednesday”,
“timeSlots”: [
{
“startTime”: “10:30:00.0000000”,
“endTime”: “18:30:00.0000000”
}
]
},
{
“day”: “thursday”,
“timeSlots”: [
{
“startTime”: “10:30:00.0000000”,
“endTime”: “18:30:00.0000000”
}
]
},
{
“day”: “friday”,
“timeSlots”: [
{
“startTime”: “10:30:00.0000000”,
“endTime”: “18:30:00.0000000”
}
]
},
{
“day”: “saturday”,
“timeSlots”: []
},
{
“day”: “sunday”,
“timeSlots”: []
}
]
}
}
I know how to update the availabilityType:
Update-MgBookingBusinessService -BookingBusinessId <calendar> -BookingServiceId <service> -SchedulingPolicy @{“GeneralAvailability” = @{“availabilityType”=”customWeeklyHours”}}
But the amount of nested arrays to update the startTime and endTime for timeSlots has left me braindead. I feel like I’m so close, but somehow I’m just not getting it, and I’ve given up. Could someone please light the way for me? Thank you!
I’m tragically stuck on what I know is a simple query. For context, I’m trying to update a Bookings calendar service business hours through PowerShell.The cmdlet is Update-MgBookingBusinessService.The relevant JSON that is returned from Get-MgBookingBusinessService is below. “schedulingPolicy”: {
“generalAvailability”: {
“availabilityType”: “customWeeklyHours”,
“businessHours”: [
{
“day”: “monday”,
“timeSlots”: [
{
“startTime”: “10:30:00.0000000”,
“endTime”: “18:30:00.0000000”
}
]
},
{
“day”: “tuesday”,
“timeSlots”: [
{
“startTime”: “10:30:00.0000000”,
“endTime”: “18:30:00.0000000”
}
]
},
{
“day”: “wednesday”,
“timeSlots”: [
{
“startTime”: “10:30:00.0000000”,
“endTime”: “18:30:00.0000000”
}
]
},
{
“day”: “thursday”,
“timeSlots”: [
{
“startTime”: “10:30:00.0000000”,
“endTime”: “18:30:00.0000000”
}
]
},
{
“day”: “friday”,
“timeSlots”: [
{
“startTime”: “10:30:00.0000000”,
“endTime”: “18:30:00.0000000”
}
]
},
{
“day”: “saturday”,
“timeSlots”: []
},
{
“day”: “sunday”,
“timeSlots”: []
}
]
}
} I know how to update the availabilityType:Update-MgBookingBusinessService -BookingBusinessId <calendar> -BookingServiceId <service> -SchedulingPolicy @{“GeneralAvailability” = @{“availabilityType”=”customWeeklyHours”}} But the amount of nested arrays to update the startTime and endTime for timeSlots has left me braindead. I feel like I’m so close, but somehow I’m just not getting it, and I’ve given up. Could someone please light the way for me? Thank you! Read More
July 2024 Recap: Azure PostgreSQL Flexible Server
Hello Azure Community,
This July, Azure Database for PostgreSQL Flexible Server introduced several important updates. These updates make our database services even better and easier to use. We’ve added new features for security, better monitoring, and improved how you can set up and manage databases. Here’s what’s new and exciting in July 2024.
Feature Highlights
System Assigned Managed Identity – Generally available
Recovery improvements for Point-in-time-Recovery (PITR) – Generally available
Database Size monitoring metric – Generally available
Index tuning enhancements – Preview
CLI enhancements – Generally available
Improvements in the Azure Database for PostgreSQL connector in Azure Data Factory – Generally available
Recap of Microsoft team participation in PGConf.dev 2024
System Assigned Managed Identity
Azure Database for PostgreSQL – Flexible Server now supports enabling system-assigned managed identities. This feature allows customers to use the flexible server’s identity to interact with other Azure services. Additionally, it was a prerequisite for integrating the Flexible Server into the fabric ecosystem. This integration will enable customers to set up continuous mirroring or replication of their existing Azure PostgreSQL Flexible Server database into Fabric’s One Lake storage in the future.
Key Benefits:
Seamless Integration: You can now configure System Assigned Managed Identity for your PostgreSQL Flexible Server, enabling it to securely interact with other Azure services.
Enhanced Security: Utilize the robust security features of Microsoft Entra to manage and protect your database access.
To learn more visit our documentation: System Assigned Managed Identity
Recovery improvements for Point-in-time-Recovery (PITR)
We’ve updated the Recovery Point Objective (RPO) for Azure Database for PostgreSQL Flexible Servers, reducing it from 15 minutes to just 5 minutes for setups without high availability. This change means if there’s a system issue, the most you could lose is 5 minutes of data, not 15. This is a big step in making sure your data is safe and can be quickly restored, reducing downtime.
Main Benefits:
Better Data Protection: Less data is at risk during disruptions.
Quicker Recovery: Systems bounce back faster, reducing downtime.
Advantages for Customers: Your data is safer and gets back to normal quicker if something goes wrong.
For more details, check out RPO and RTO guidelines for Azure Database for PostgreSQL Flexible Server.
Database Size monitoring metric
The new “Database Size” metric in Azure Database for PostgreSQL Flexible Server significantly enhances database management by providing precise, granular insights into the storage consumption of individual databases.
This feature aids in detailed monitoring, supports effective capacity planning by offering exact data on database sizes, and promotes operational efficiency through actionable insights, crucial for optimizing database performance and resource utilization in a multi-database environment. For a complete list of monitoring metrics available for Azure PostgreSQL Flexible Server, please refer our monitoring documentation.
Index tuning enhancements
Index tuning is a feature in Azure Database for PostgreSQL flexible server that automatically improves the performance of your workload by analyzing the tracked queries and providing index recommendations. It is a built-in offering in Azure Database for PostgreSQL flexible server, which builds on top of Monitor performance with Query Store functionality. Index tuning analyzes the workload tracked by Query Store and produces index recommendations to improve the performance of the analyzed workload or to drop duplicate or unused indexes.
Available in all regions where Azure Database for PostgreSQL Flexible Server is available.
Supported in instances deployed with Private access (VNET Integration) connectivity method.
Portal now includes a better experience to configure index tuning settings in the context of Index tuning (preview) page, with parameters grouped logically and easier to understand names and descriptions.
If you haven’t started using it yet, read more about index tuning and begin using it today.
CLI enhancements
We’ve recently updated the Azure CLI module for PostgreSQL, addressing 16 issues reported by the community. A big thank you to everyone who contributed suggestions! Your feedback helps us make continuous improvements. For ongoing updates or to suggest new features, visit our issues page: Azure CLI PostgreSQL Issues.
You can now download Azure CLI version 2.62.0 and enjoy these enhancements: Download Azure CLI 2.62.0.
Azure Data Factory (ADF) connector improvements
Azure Data Factory is a fully managed, serverless data integration service built to orchestrate and operationalize complex hybrid extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects.
A variety of conditions can cause a connection to fail with error 11775, when using Azure Database for PostgreSQL connector in Azure Data Factory. We have simplified the error message returned when the connection attempt fails and have improved Data Factory’s connector troubleshooting guide to cover all possible causes of that error and to provide guidance for all of them. Based on customer feedback, we’ve also made a major revision of our guide that explains how to connect from an Azure Data Factory pipeline using Azure Private Link.
Azure Postgres Team at PGConf.dev 2024
Microsoft demonstrated its commitment to the PostgreSQL community through its sponsorship of PostgreSQL Development Conference 2024 (PGConf.dev 2024), held in Vancouver, Canada. The Azure Postgres team engaged in numerous activities, including delivering talks and managing a well-received booth.
ANALYZING CACHELINE CONTENTION USING PERF C2C – @andresfreund
HOW TO ENGINEER YOUR DEVELOPER BLOG POSTS TO HAVE BIGGER IMPACT – @clairegiordano
THE POSTGRESQL PROTOCOL: THE GOOD, THE BAD AND THE FUTURE – @JelteF
ENHANCING POSTGRESQL PLASTICITY: NEW FRONTIERS IN MEMORY MANAGEMENT – @Krishnakumar Ravi (KK)
MAKING POSTGRESQL HACKING MORE INCLUSIVE – Panel Discussion with @Melanie Plageman
These sessions are a valuable resource for anyone looking to deepen their understanding of PostgreSQL and its various applications. For a complete list refer to the PGConf.Dev 2024 session schedule.
Customer Spotlight – Posten Bring – Setting the logistics sector up for the future using Microsoft Azure
Posten Bring, a Norwegian logistics giant, has dramatically transformed its operations by moving to Microsoft Azure, utilizing Azure Database for PostgreSQL among other services. This shift allowed them to abandon outdated systems in favor of a modern, scalable, and reliable cloud-based solution. The new system is crucial for handling peak periods like Christmas and Black Friday effectively.
With Azure, Posten Bring has enhanced its operational efficiency and data management capabilities. The integration of Azure Database for PostgreSQL has enabled real-time data monitoring and management, significantly improving their service reliability and customer delivery times. This technological advancement supports their mission to deliver goods effectively across the Nordics, reinforcing their legacy with modern solutions.
This move to Azure has not only optimized their daily operations but also positioned Posten Bring for future innovations in data-driven services and AI, proving the pivotal role of Azure in their ongoing success. Read more about their journey here.
Conclusion
In summary, the updates we introduced this July aim to enhance how you use Azure Database for PostgreSQL Flexible Server. With new features like Managed Identity and advanced tools for database tuning, we’re committed to providing you with the best resources. Try out these new features and see how they can improve your projects. Your feedback is important to us and helps us continue improving our services. Keep an eye out for more updates as we strive to better serve your needs.
Microsoft Tech Community – Latest Blogs –Read More
Why I can’t save my data in a .mat when using WebAppServer?
My application is used to take a test to several people.
At each instance, Scores.mat is opened. It contains the structure Scores which stores the scores of the previous participants. The number of participants is retrieved. The new participant takes the test and the new scores are added to the strucure Scores. At the end of the test, the structure Scores is saved in Scores.mat, and so on.
% Load the scores table
load Scores.mat
app.Scores = Scores;
% Increment the participant index
app.idxParticipant = length(app.Scores) + 1;
% (…)
% Save scores (code has been modified for better clarity)
app.Scores(app.idxParticipant).Model(1) = app.EditField.Value;
app.Scores(app.idxParticipant).Model(2) = app.EditField_2.Value;
app.Scores(app.idxParticipant).Model(3) = app.EditField_3.Value;
% (…)
% Save listener scores
Scores = app.Scores;
save(‘Scores.mat’,’Scores’)
Locally, everything runs well, of course. But when I test the Matlab WebApp, the very last step doesn’t work: the structure Scores is not saved in Scores.mat and there is no errors in the logs.
Scores.mat is well embedded in the WebApp as I am able to open it and retrieve the Scores structure. The structure is well updated, I’ve checked it, but I am not able to save the updated structure back into Scores.mat.
I hope someone could help me here. Many thanks!My application is used to take a test to several people.
At each instance, Scores.mat is opened. It contains the structure Scores which stores the scores of the previous participants. The number of participants is retrieved. The new participant takes the test and the new scores are added to the strucure Scores. At the end of the test, the structure Scores is saved in Scores.mat, and so on.
% Load the scores table
load Scores.mat
app.Scores = Scores;
% Increment the participant index
app.idxParticipant = length(app.Scores) + 1;
% (…)
% Save scores (code has been modified for better clarity)
app.Scores(app.idxParticipant).Model(1) = app.EditField.Value;
app.Scores(app.idxParticipant).Model(2) = app.EditField_2.Value;
app.Scores(app.idxParticipant).Model(3) = app.EditField_3.Value;
% (…)
% Save listener scores
Scores = app.Scores;
save(‘Scores.mat’,’Scores’)
Locally, everything runs well, of course. But when I test the Matlab WebApp, the very last step doesn’t work: the structure Scores is not saved in Scores.mat and there is no errors in the logs.
Scores.mat is well embedded in the WebApp as I am able to open it and retrieve the Scores structure. The structure is well updated, I’ve checked it, but I am not able to save the updated structure back into Scores.mat.
I hope someone could help me here. Many thanks! My application is used to take a test to several people.
At each instance, Scores.mat is opened. It contains the structure Scores which stores the scores of the previous participants. The number of participants is retrieved. The new participant takes the test and the new scores are added to the strucure Scores. At the end of the test, the structure Scores is saved in Scores.mat, and so on.
% Load the scores table
load Scores.mat
app.Scores = Scores;
% Increment the participant index
app.idxParticipant = length(app.Scores) + 1;
% (…)
% Save scores (code has been modified for better clarity)
app.Scores(app.idxParticipant).Model(1) = app.EditField.Value;
app.Scores(app.idxParticipant).Model(2) = app.EditField_2.Value;
app.Scores(app.idxParticipant).Model(3) = app.EditField_3.Value;
% (…)
% Save listener scores
Scores = app.Scores;
save(‘Scores.mat’,’Scores’)
Locally, everything runs well, of course. But when I test the Matlab WebApp, the very last step doesn’t work: the structure Scores is not saved in Scores.mat and there is no errors in the logs.
Scores.mat is well embedded in the WebApp as I am able to open it and retrieve the Scores structure. The structure is well updated, I’ve checked it, but I am not able to save the updated structure back into Scores.mat.
I hope someone could help me here. Many thanks! wepappserver MATLAB Answers — New Questions
Why do I receive the error “This email is not linked to a license. Use a different email address…” when I try to launch MATLAB?
Why do I see the following error when I try to launch MATLAB?
This email is not linked to a license.
Use a different email address or go to your MathWorks Account to link a license. After the license is linked, try again.Why do I see the following error when I try to launch MATLAB?
This email is not linked to a license.
Use a different email address or go to your MathWorks Account to link a license. After the license is linked, try again. Why do I see the following error when I try to launch MATLAB?
This email is not linked to a license.
Use a different email address or go to your MathWorks Account to link a license. After the license is linked, try again. MATLAB Answers — New Questions
