Month: June 2024
MS Build Recap and Upcoming Events
Wow, what a week at Microsoft Build 2024. We had a fantastic experience watching the amazing innovations in AI and Copilot world and connecting with so many of you from our developer community.
As we reflect on the excitement and enthusiasm created by the event, we wanted to provide a short summary of Azure Communication Services’ announcements and direct you to upcoming learning opportunities in June. We announced the following features at Build –
Enhancements to custom video app experiences connected to Microsoft Teams
Deep noise suppression
Picture in Picture for iOS and Android
PowerPoint Live
Live reactions
File sharing during a meeting
Real time transcription using Azure AI Speech
Closed Captions
Stream live audio using the Audio Streaming API
Copilot for Call Diagnostics
WhatsApp message analysis through Azure OpenAI Service. This is in limited preview, and you can request access here. Here is a sample for you to try it on your own.
Please check out our Build announcement blog to learn more about the new capabilities listed above.
If you missed Build or want to catch up on Azure Communication sessions, we have a series of upcoming online events that are free to join. The content that was streamed live on the Build website is now available on YouTube and embedded below for you to watch –
Here are the upcoming free to join events that you can register for –
11th June, 8:00 AM (PST)– Click to Call demo on M365 and Power Platform community call – Add to calendar
13th June, 9:00 AM (PST) – How to build AI-powered multi-channel notification – a step-by-step guide. Register here.
18th June, 8:00 AM (PST) – Extend your copilot using Azure Communication Services demo – Add to calendar
We hope to see you join us for the community calls and the Reactor event. As always, eager to hear your feedback and ideas on how to make Azure Communication Services the best platform for your communication needs.
Microsoft Tech Community – Latest Blogs –Read More
EPS Figure Not Saving As Vectorized Plot For Illustrator
I am trying to generate figures in matlab and save them as eps files to further edit them in adobe illustrator. When I open the eps plot in adobe illustrator it is not vectorized and is essentially just an image. Here is what it looks like in illustrator:I am trying to generate figures in matlab and save them as eps files to further edit them in adobe illustrator. When I open the eps plot in adobe illustrator it is not vectorized and is essentially just an image. Here is what it looks like in illustrator: I am trying to generate figures in matlab and save them as eps files to further edit them in adobe illustrator. When I open the eps plot in adobe illustrator it is not vectorized and is essentially just an image. Here is what it looks like in illustrator: eps, illustrator MATLAB Answers — New Questions
Command Window No Output
Upon typing anything into the command window, the answer is only outputted into the workspace, and not into the command window as the typically expected "ans = ___" line:
Even typing gibberish generates no output or any error handling. It just prompts the next line:
Running a program with internal error handling will work, but it seems things such as type errors or other MATLAB-handled errors are ignored, and there are no ways to generate outputs, unless I force it with disp(). But I obviously don’t want to keep doing that nor is that a viable solution going forward.
A coworker was trying to help me with this and we discovered that running "evalc" in the command window generates the same problem on his MATLAB as my current issue. I don’t remember ever running "evalc" unless I ran a script at some point that had that included. There seems to be no known solution out there for how to reverse the effect of this "evalc" and/or turn it off.Upon typing anything into the command window, the answer is only outputted into the workspace, and not into the command window as the typically expected "ans = ___" line:
Even typing gibberish generates no output or any error handling. It just prompts the next line:
Running a program with internal error handling will work, but it seems things such as type errors or other MATLAB-handled errors are ignored, and there are no ways to generate outputs, unless I force it with disp(). But I obviously don’t want to keep doing that nor is that a viable solution going forward.
A coworker was trying to help me with this and we discovered that running "evalc" in the command window generates the same problem on his MATLAB as my current issue. I don’t remember ever running "evalc" unless I ran a script at some point that had that included. There seems to be no known solution out there for how to reverse the effect of this "evalc" and/or turn it off. Upon typing anything into the command window, the answer is only outputted into the workspace, and not into the command window as the typically expected "ans = ___" line:
Even typing gibberish generates no output or any error handling. It just prompts the next line:
Running a program with internal error handling will work, but it seems things such as type errors or other MATLAB-handled errors are ignored, and there are no ways to generate outputs, unless I force it with disp(). But I obviously don’t want to keep doing that nor is that a viable solution going forward.
A coworker was trying to help me with this and we discovered that running "evalc" in the command window generates the same problem on his MATLAB as my current issue. I don’t remember ever running "evalc" unless I ran a script at some point that had that included. There seems to be no known solution out there for how to reverse the effect of this "evalc" and/or turn it off. command window, output, evalc MATLAB Answers — New Questions
how to find code of power sharing between fuel cell and battery written in FCEV reference examples
Please guide me how I am able to find code of power sharing between fuel cell and battery written in controller of FCEV refernces example in MATLAB 2022Please guide me how I am able to find code of power sharing between fuel cell and battery written in controller of FCEV refernces example in MATLAB 2022 Please guide me how I am able to find code of power sharing between fuel cell and battery written in controller of FCEV refernces example in MATLAB 2022 code generation MATLAB Answers — New Questions
MS Bookings | One-Time Use Link Errors
Hello! I am encountering a new error with MS Bookings that I have not encountered previously. I am wondering if there were any changes made to Bookings recently that can explain what is happening.
I am sending out single-use links to multiple people for a Private Booking I have created. The goal is for individuals to book a 1:1 meeting with me using my availability. In the past, I have sent the same single-use link to multiple people at once (through a single email) and have had no issues.
Now, once one person books from the link, no one else is able to use the link. At least, I believe this is what’s happening. The error is not encountered when using a normal link.
I use the one-time link option because it is the best fit for my work. We do not want people to be able to reopen to same link and rebook times at their whim. Due to this, the one-time use links end up being the best option.
Some troubleshooting methods I have tried on my own:
Recopied the link and sent it again to an individual. They were still met with an error.
I have copied a single-use link for each individual, sent them their own unique link separately, and still they were not able to book any times.
I have made a duplicate of the original Private Booking, attempted to copy that link and send it to ONE individual, and still it resulted in an error.
Thanks in advance!
Hello! I am encountering a new error with MS Bookings that I have not encountered previously. I am wondering if there were any changes made to Bookings recently that can explain what is happening. I am sending out single-use links to multiple people for a Private Booking I have created. The goal is for individuals to book a 1:1 meeting with me using my availability. In the past, I have sent the same single-use link to multiple people at once (through a single email) and have had no issues. Now, once one person books from the link, no one else is able to use the link. At least, I believe this is what’s happening. The error is not encountered when using a normal link.I use the one-time link option because it is the best fit for my work. We do not want people to be able to reopen to same link and rebook times at their whim. Due to this, the one-time use links end up being the best option. Some troubleshooting methods I have tried on my own:Recopied the link and sent it again to an individual. They were still met with an error.I have copied a single-use link for each individual, sent them their own unique link separately, and still they were not able to book any times.I have made a duplicate of the original Private Booking, attempted to copy that link and send it to ONE individual, and still it resulted in an error. Thanks in advance! Read More
Keeping the Word file formatting into a SharePoint
Dears Greetings
I am trying to copy a text from a Word file (docx) into a SharePoint page text field. but the format after I pasted the text is different from the original docx file. any idea how to fix it?
org Docx file
SharePoint
Dears GreetingsI am trying to copy a text from a Word file (docx) into a SharePoint page text field. but the format after I pasted the text is different from the original docx file. any idea how to fix it?org Docx file SharePoint Read More
Azure Pipeline PowerShell SQL Script
Hello all –
I am hoping to get some help in understanding what I need to do in order to be able to execute a PowerShell script from a release pipeline that executes .sql files in my DevOps repository. We have created a deployment group which includes an agent being set up on our server.
I am able to connect to the SQL Server via my PowerShell script, but I am not able to execute anything in my repository.
How do I reference a specific .sql file that I have stored in a repository? I would like to use it in my command that I am trying to use in my PowerShell script:
Invoke-SqlCmd -ServerInstance “MyServerInstance” -Database “MyDB” -InputFile ???
I have tried using $System.DefaultWorkingDirectory but that just references a folder on the server. What do I need to put into the ??? placeholder?
Thank you in advance
Hello all – I am hoping to get some help in understanding what I need to do in order to be able to execute a PowerShell script from a release pipeline that executes .sql files in my DevOps repository. We have created a deployment group which includes an agent being set up on our server. I am able to connect to the SQL Server via my PowerShell script, but I am not able to execute anything in my repository. How do I reference a specific .sql file that I have stored in a repository? I would like to use it in my command that I am trying to use in my PowerShell script: Invoke-SqlCmd -ServerInstance “MyServerInstance” -Database “MyDB” -InputFile ??? I have tried using $System.DefaultWorkingDirectory but that just references a folder on the server. What do I need to put into the ??? placeholder? Thank you in advance Read More
Join the Ask Microsoft Anything (AMA) on Designing your Mesh Event starting today at 9amPT
We are very excited to host another ‘Ask Microsoft Anything’ (AMA) specific on how to create a great immersive experience.
The AMA will take place on Tuesday, June 4th, 2024 from 9:00 a.m. to 10:00 a.m. PT.
An AMA is a live online event similar to an “Ask Me Anything” on Reddit. This AMA gives you the opportunity to connect with members of the product engineering team who will be on hand to answer your questions and listen to feedback.
Designing Your Mesh Event: How to Create a Great Immersive Experience – Microsoft Community Hub
We are very excited to host another ‘Ask Microsoft Anything’ (AMA) specific on how to create a great immersive experience.
The AMA will take place on Tuesday, June 4th, 2024 from 9:00 a.m. to 10:00 a.m. PT.
An AMA is a live online event similar to an “Ask Me Anything” on Reddit. This AMA gives you the opportunity to connect with members of the product engineering team who will be on hand to answer your questions and listen to feedback.
Designing Your Mesh Event: How to Create a Great Immersive Experience – Microsoft Community Hub Read More
Auto record all Teams meetings and calls?
Is it possible to record all Teams meeting and calls automatically?
This is for my organization’s compliance policy.
Unfortunately, even with Teams Premium I can’t find an option to enable automatic recording for all future meetings and calls. You can only set the feature for separate or recurring meetings once you schedule meetings.
Is it possible to record all Teams meeting and calls automatically? This is for my organization’s compliance policy. Unfortunately, even with Teams Premium I can’t find an option to enable automatic recording for all future meetings and calls. You can only set the feature for separate or recurring meetings once you schedule meetings. Read More
Regarding the Compliance of corporate owned dedicated devices
Hi All,
May I ask if anyone has used the corporate owned dedicated devices profile?
Because my Android device is considered compliant on Intune but displays N/A on Azure after using the Compliance of corporate owned dedicated profile, which is blocked by the compliant set on the conditional access policy.
If anyone has encountered similar problems, please reply again.
Thanks.
Intune
Azure
Conditional Access log
Hi All, May I ask if anyone has used the corporate owned dedicated devices profile?Because my Android device is considered compliant on Intune but displays N/A on Azure after using the Compliance of corporate owned dedicated profile, which is blocked by the compliant set on the conditional access policy.If anyone has encountered similar problems, please reply again.Thanks. IntuneAzureConditional Access log Read More
Tracking system for submission packages
As part of my job, I am required to assemble document packages and submit them to a governmental regulatory agency. I am trying to develop a system to track the submissions and to save the relevant documentation, and I am wondering what approach is best.
The data I am tracking includes project names and numbers, names of people, milestone dates, contact information, review status, etc. The submission packages are large and can include 20 or more individual files. We receive communication back from the agency during the review and approval process, and these letters need to be saved and easy to locate.
I initially created a table in Excel to track the submissions and a network folder to sort the files. This worked very well, but I suspect there is a more modern approach that would work better with our company’s systems.
My second attempt was to use MS Lists. Lists allows me to display the data very nicely, but I find the ability to attach files to each entry is lacking. As far as I’m aware, there is no way to create folders within a Lists entry. Without being able to sort my files into subfolders, important communications are time consuming to find among all the submission files.
My most recent attempt has been to create a SharePoint document library. This seems to work well enough. I can create a folder and customize the columns to list the tracking data I’m concerned with. Within the folder, I can create all the folders and subfolders I want. My complaints with this approach are that it seems to lack the colour coding that conditional formatting in Excel and Lists allows, and it’s not very user friendly to create a new library entry or update an existing one (compared to Lists or Excel).
Does anyone have any recommendations? Is there a better tool or approach I could be using?
As part of my job, I am required to assemble document packages and submit them to a governmental regulatory agency. I am trying to develop a system to track the submissions and to save the relevant documentation, and I am wondering what approach is best. The data I am tracking includes project names and numbers, names of people, milestone dates, contact information, review status, etc. The submission packages are large and can include 20 or more individual files. We receive communication back from the agency during the review and approval process, and these letters need to be saved and easy to locate. I initially created a table in Excel to track the submissions and a network folder to sort the files. This worked very well, but I suspect there is a more modern approach that would work better with our company’s systems. My second attempt was to use MS Lists. Lists allows me to display the data very nicely, but I find the ability to attach files to each entry is lacking. As far as I’m aware, there is no way to create folders within a Lists entry. Without being able to sort my files into subfolders, important communications are time consuming to find among all the submission files. My most recent attempt has been to create a SharePoint document library. This seems to work well enough. I can create a folder and customize the columns to list the tracking data I’m concerned with. Within the folder, I can create all the folders and subfolders I want. My complaints with this approach are that it seems to lack the colour coding that conditional formatting in Excel and Lists allows, and it’s not very user friendly to create a new library entry or update an existing one (compared to Lists or Excel). Does anyone have any recommendations? Is there a better tool or approach I could be using? Read More
What is an “MSX Opportunity ID” and what are the steps to obtain this information for MCI engagement
This is an Incentives related question. Some of the Pre-Sales engagement customer eligibility require an “MSX Opportunity ID”. I’ve seen various instructions to contact either a “PDM” or “Your Microsoft sales or partner point person” for this, but we don’t have such individuals in our list of contacts.
How does this work?
Is it possible to reach one through the standard support portal?
Or are these activities simply not accessible to partners who don’t have any of the above?
This is an Incentives related question. Some of the Pre-Sales engagement customer eligibility require an “MSX Opportunity ID”. I’ve seen various instructions to contact either a “PDM” or “Your Microsoft sales or partner point person” for this, but we don’t have such individuals in our list of contacts.How does this work?Is it possible to reach one through the standard support portal?Or are these activities simply not accessible to partners who don’t have any of the above? Read More
Freely move toolbar and optimize video in Microsoft Teams screensharing
Hey, Microsoft 365 Insiders!
Great news! You can now enhance your Microsoft Teams experience with the new movable Presenter toolbar and one-click video optimization. Tailor your screensharing to fit your needs and elevate your virtual collaboration.
Read all about it in our latest blog: Freely move toolbar and optimize video in Microsoft Teams screensharing
Thanks,
Perry Sjogren
Microsoft 365 Insider Social Media Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Hey, Microsoft 365 Insiders!
Great news! You can now enhance your Microsoft Teams experience with the new movable Presenter toolbar and one-click video optimization. Tailor your screensharing to fit your needs and elevate your virtual collaboration.
Read all about it in our latest blog: Freely move toolbar and optimize video in Microsoft Teams screensharing
Thanks,
Perry Sjogren
Microsoft 365 Insider Social Media Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android Read More
Partner Alert: Announcing Microsoft Dynamics 365 Contact Center
Summary
On June 4 at the Customer Contact Week event, Microsoft announced the Microsoft Dynamics 365 Contact Center, which will become generally available (GA) on July 1, 2024. Dynamics 365 Contact Center is a Copilot-first contact center solution that delivers generative AI to every customer engagement and enables customers to keep their current CRM, whether Dynamics 365, Salesforce, or other custom CRMs. With this launch, Microsoft reaches the latest milestone in the journey toward modernizing customer service with generative AI throughout the contact center workflow—spanning the channels of communication, self-service, intelligent routing, agent-assisted service, and operations to help contact centers solve problems faster, empower agents, and reduce costs.
Existing customers using the digital and voice channel add-ins with Dynamics 365 Customer Service will benefit from Dynamics 365 Contact Center and have a transition path to the new solution. Pricing and other information will be disclosed at GA.
Microsoft Dynamics 365 Contact Center
Dynamics 365 Contact Center is a contact center as a service (CCaaS) offering, enabling customers to bring the best of generative AI and omnichannel support to their contact center. Key capabilities include:
Effortless self-service
Customers have the freedom to engage in their channel of choice across voice, SMS, chat, email, and social media apps.
Sophisticated pre-integrated copilots for digital channels drive context-aware, personalized conversations for rich self-service experiences.
Provide a frictionless conversational IVR experience in real time through natural, human-like interactions.
Accelerated human-assisted service
Intelligent unified routing steers incoming requests that require a human touch to the agent best suited to help, enhancing service quality and minimizing wasted effort.
Agents gain a 360-degree view of customers and AI tools for real-time sentiment analysis, translation, transcription, and more to help streamline service.
Let Copilot automate repetitive agent tasks such as conversation summary, drafting emails, suggested responses, and knowledge search.
Operational efficiency
Generative AI based real-time reporting allows service leaders to optimize contact center operations across all support channels including their workforce.
Maximize Copilot by connecting it to an organization’s existing data and business applications using more than 1,200 pre-built connectors that eliminate the need for expensive IT integration.
Empower employee helpdesk and human resources functions using Microsoft Teams as a secure, integrated engagement channel.
Call to Action
Learn more about Dynamics 365 Contact Center and the value that it will provide to customers. Understand how this exciting news complements and reinforces Microsoft’s core strategy of landing Dynamics 365 Service solutions into every organization. In addition, the announcement is supported by promotion June 4-6 at Customer Contact Week (CCW) in Las Vegas, the largest contact center event in North America.
Find more information on the Dynamics 365 Partner Hub
Read the announcement on the official Microsoft blog for an overview of Microsoft’s offer and market viewpoint
Leverage the following new partner assets now available in on Partner Hub:
Microsoft Dynamics 365 Contact Center BDM Pitch Deck
Microsoft Dynamics 365 Contact Center Demo video
Microsoft Dynamics 365 Contact Center Sizzle video
More resources will roll out aligned with GA on July 1st. Visit the Partner Hub for the latest updates
Stay Connected with Business Applications Partner Resources
NEW! Sign up for the Dynamics 365 and Power Platform Partner Newsletters
Follow the Dynamics 365 and Power Platform partner LinkedIn channels
Bookmark the Dynamics 365 and Power Platform Partner Hub pages
Join and engage in the Business Applications Microsoft Partner Community
Summary
On June 4 at the Customer Contact Week event, Microsoft announced the Microsoft Dynamics 365 Contact Center, which will become generally available (GA) on July 1, 2024. Dynamics 365 Contact Center is a Copilot-first contact center solution that delivers generative AI to every customer engagement and enables customers to keep their current CRM, whether Dynamics 365, Salesforce, or other custom CRMs. With this launch, Microsoft reaches the latest milestone in the journey toward modernizing customer service with generative AI throughout the contact center workflow—spanning the channels of communication, self-service, intelligent routing, agent-assisted service, and operations to help contact centers solve problems faster, empower agents, and reduce costs.
Existing customers using the digital and voice channel add-ins with Dynamics 365 Customer Service will benefit from Dynamics 365 Contact Center and have a transition path to the new solution. Pricing and other information will be disclosed at GA.
Microsoft Dynamics 365 Contact Center
Dynamics 365 Contact Center is a contact center as a service (CCaaS) offering, enabling customers to bring the best of generative AI and omnichannel support to their contact center. Key capabilities include:
Effortless self-service
Customers have the freedom to engage in their channel of choice across voice, SMS, chat, email, and social media apps.
Sophisticated pre-integrated copilots for digital channels drive context-aware, personalized conversations for rich self-service experiences.
Provide a frictionless conversational IVR experience in real time through natural, human-like interactions.
Accelerated human-assisted service
Intelligent unified routing steers incoming requests that require a human touch to the agent best suited to help, enhancing service quality and minimizing wasted effort.
Agents gain a 360-degree view of customers and AI tools for real-time sentiment analysis, translation, transcription, and more to help streamline service.
Let Copilot automate repetitive agent tasks such as conversation summary, drafting emails, suggested responses, and knowledge search.
Operational efficiency
Generative AI based real-time reporting allows service leaders to optimize contact center operations across all support channels including their workforce.
Maximize Copilot by connecting it to an organization’s existing data and business applications using more than 1,200 pre-built connectors that eliminate the need for expensive IT integration.
Empower employee helpdesk and human resources functions using Microsoft Teams as a secure, integrated engagement channel.
Call to Action
Learn more about Dynamics 365 Contact Center and the value that it will provide to customers. Understand how this exciting news complements and reinforces Microsoft’s core strategy of landing Dynamics 365 Service solutions into every organization. In addition, the announcement is supported by promotion June 4-6 at Customer Contact Week (CCW) in Las Vegas, the largest contact center event in North America.
Find more information on the Dynamics 365 Partner Hub
Read the announcement on the official Microsoft blog for an overview of Microsoft’s offer and market viewpoint
Leverage the following new partner assets now available in on Partner Hub:
Microsoft Dynamics 365 Contact Center BDM Pitch Deck
Microsoft Dynamics 365 Contact Center Demo video
Microsoft Dynamics 365 Contact Center Sizzle video
More resources will roll out aligned with GA on July 1st. Visit the Partner Hub for the latest updates
Stay Connected with Business Applications Partner Resources
NEW! Sign up for the Dynamics 365 and Power Platform Partner Newsletters
Follow the Dynamics 365 and Power Platform partner LinkedIn channels
Bookmark the Dynamics 365 and Power Platform Partner Hub pages
Join and engage in the Business Applications Microsoft Partner Community Read More
Azure Database for PostgreSQL – Latency comparison between PGBouncer and Npgsql
Introduction:
Azure Database for PostgreSQL Flexible Server comes with PGBouncer – a built-in connection manager which you can leverage for connections. Npgsql is an open-source ADO .NET Data provider for PostgreSQL, it allows programs written in C# to access Azure Database for PostgreSQL Flexible Server and offers similar functionality as PGBouncer. It is a free and open source resource.
Recently one of our customers came with the question: Should I leverage the built in connection pooler (PGBouncer) or should I use the connection pooling provided by Npgsql – .NET access for PostgreSQL.
We decided to run some tests to see what is the latency impact of both options in order to better answer the question posed and we would like to share the results in this post.
The setup:
We are using an Azure Database for PostgreSQL instance created in AZ1 in the West Europe region.
The .NET 6.0 application is also deployed on an Azure VM in AZ1 in the West Europe region.
Test C# code setup snippet:
using Npgsql;
var connstring = “Server=serverconnection;Username=username;Database=postgres;Port=port;Password=pass;SSLMode=Prefer;Pooling=False”;
Console.WriteLine(connstring);
using (var conn1 = new NpgsqlConnection(connstring))
{
var timer = System.Diagnostics.Stopwatch.StartNew();
conn1.Open();
Console.WriteLine(“Time spent waiting for the 1 connection to open: {0}ms {1} elapsed time”, timer.ElapsedMilliseconds, timer.Elapsed);
}
using (var conn2 = new NpgsqlConnection(connstring))
{
var timer = System.Diagnostics.Stopwatch.StartNew();
conn2.Open();
Console.WriteLine(“Time spent waiting for the 2 connection to open: {0}ms {1} elapsed time”, timer.ElapsedMilliseconds, timer.Elapsed);
}
using (var conn3 = new NpgsqlConnection(connstring))
{
var timer = System.Diagnostics.Stopwatch.StartNew();
conn3.Open();
Console.WriteLine(“Time spent waiting for the 3 connection to open: {0}ms {1} elapsed time”, timer.ElapsedMilliseconds, timer.Elapsed);
}
using (var conn4 = new NpgsqlConnection(connstring))
{
var timer = System.Diagnostics.Stopwatch.StartNew();
conn4.Open();
Console.WriteLine(“Time spent waiting for the 4 connection to open: {0}ms {1} elapsed time”, timer.ElapsedMilliseconds, timer.Elapsed);
}
using (var conn5 = new NpgsqlConnection(connstring))
{
var timer = System.Diagnostics.Stopwatch.StartNew();
conn5.Open();
Console.WriteLine(“Time spent waiting for the 5 connection to open: {0}ms {1} elapsed time”, timer.ElapsedMilliseconds, timer.Elapsed);
}
using (var conn6 = new NpgsqlConnection(connstring))
{
var timer = System.Diagnostics.Stopwatch.StartNew();
conn6.Open();
Console.WriteLine(“Time spent waiting for the 6 connection to open: {0}ms {1} elapsed time”, timer.ElapsedMilliseconds, timer.Elapsed);
}
Console.ReadLine();
Test 1: No connection pool (Baseline)
Test 2: Using PGBouncer as connection pooling method:
You can connect to PGBouncer on Azure Database for PostgreSQL Flexible Server by connecting through port 6432. You can read more about PGBouncer here and you can find default connection pool settings for PGBouncer in Azure Database for PostgreSQL Flexible Server here.
Test 3: Using Npgsql as connection pooling method:
You can use this connection method by setting the Pooling Flag in the connection string to True.
Results
From the test runs above we can see that the latency is lower using Npgsql as the connection polling method and this is expected as the connection pool resides directly in the same server as the application. PGBouncer however may be a more viable choice if the slightly higher latency is acceptable, as it is seamlessly integrated with Azure Database for PostgreSQL Flexible Server, so there is no need for a separate installation as is the case with Npgsql.
A few other considerations would be:
If there are multiple apps connecting to the database, then pgbouncer would be a better choice as you can share connections between apps.
In case of failover, pgbouncer would be automatically restarted in the standby.
No matter which option you decide to use, you should thoroughly test your application and ensure you are using one of the above methods in order to not encounter connection exhaustion issues.
Feedback and Suggestions
If you have feedback or suggestions for improving this data migration asset, please contact the Azure Databases SQL Customer Success Engineering Team. Thanks for your support!
Microsoft Tech Community – Latest Blogs –Read More
Symbolic expression simplification and shortening
I have an extremely long symbolic expression after simplification which I am unable to simplify further. I want to know how to reduce the expression further, or to find repeating sub expressions inside the expression which can be replaced by another variable?
For an example, my expression looks somewhat like this:
U =
108*A^2*e^7*e1^3*e2^7*h2^4 + 153*A^2*e^7*e1^5*e2^7*h2^2 + 108*A^2*e^7*e1^7*e2^3*h3^4 + 153*A^2*e^7*e1^7*e2^5*h3^2 +…
24*B^2*e^3*e1^7*e2^7*h1^4 + 95*B^2*e^5*e1^7*e2^7*h1^2 + 24*B^2*e^7*e1^3*e2^7*h2^4 + 95*B^2*e^7*e1^5*e2^7*h2^2 + …
24*B^2*e^7*e1^7*e2^3*h3^4 + 95*B^2*e^7*e1^7*e2^5*h3^2 + 9*A^2*e^2*e1^7*h1^5*h3^7 + 9*A^2*e^2*e2^7*h1^5*h2^7 +…
9*A^2*e1^2*e2^7*h1^7*h2^5 + 9*A^2*e^7*e1^2*h2^5*h3^7 + 9*A^2*e^7*e2^2*h2^7*h3^5 + 9*A^2*e1^7*e2^2*h1^7*h3^5 -…
41*B^2*e^2*e1^7*h1^5*h3^7 – 41*B^2*e^2*e2^7*h1^5*h2^7 – 12*B^2*e^4*e1^7*h1^3*h3^7 – 12*B^2*e^4*e2^7*h1^3*h2^7 -….
41*B^2*e1^2*e2^7*h1^7*h2^5 – 12*B^2*e1^4*e2^7*h1^7*h2^3 – 41*B^2*e^7*e1^2*h2^5*h3^7 – 12*B^2*e^7*e1^4*h2^3*h3^7 – …
41*B^2*e^7*e2^2*h2^7*h3^5 – 12*B^2*e^7*e2^4*h2^7*h3^3 – 41*B^2*e1^7*e2^2*h1^7*h3^5 – 12*B^2*e1^7*e2^4*h1^7*h3^3 -…
504*A^2*e^3*h1^4*h2^7*h3^7 + 9*A^2*e^5*h1^2*h2^7*h3^7 – 504*A^2*e1^3*h1^7*h2^4*h3^7 + 9*A^2*e1^5*h1^7*h2^2*h3^7 -…
504*A^2*e2^3*h1^7*h2^7*h3^4 + 9*A^2*e2^5*h1^7*h2^7*h3^2 + 2860*B^2*e^3*h1^4*h2^7*h3^7 – 377*B^2*e^5*h1^2*h2^7*h3^7 +…
2860*B^2*e1^3*h1^7*h2^4*h3^7 – 377*B^2*e1^5*h1^7*h2^2*h3^7 + 2860*B^2*e2^3*h1^7*h2^7*h3^4 – 377*B^2*e2^5*h1^7*h2^7*h3^2 +…
162*A*B*e^7*e1^7*e2^7 – 6*A*B*e^7*h2^7*h3^7 – 6*A*B*e1^7*h1^7*h3^7 – 6*A*B*e2^7*h1^7*h2^7 + 1944*A^2*e*h1^6*h2^7*h3^7 + …
1944*A^2*e1*h1^7*h2^6*h3^7 + 1944*A^2*e2*h1^7*h2^7*h3^6 – 5400*B^2*e*h1^6*h2^7*h3^7 – 5400*B^2*e1*h1^7*h2^6*h3^7 -…
245*B^2*e^6*e1^7*e2^4*h1*h3^3 + 147*B^2*e^7*e1*e2^3*h2^6*h3^4 + 48*B^2*e^7*e1*e2^5*h2^6*h3^2 – 60*B^2*e^7*e1^2*e2^6*h2^5*h3 + …
147*B^2*e^7*e1^3*e2*h2^4*h3^6 – 245*B^2*e^7*e1^4*e2^6*h2^3*h3 + 48*B^2*e^7*e1^5*e2*h2^2*h3^6 – 60*B^2*e^7*e1^6*e2^2*h2*h3^5 -…
where e , e1, e2, h1, h2, h3, A, B are the symbolic variables.I have an extremely long symbolic expression after simplification which I am unable to simplify further. I want to know how to reduce the expression further, or to find repeating sub expressions inside the expression which can be replaced by another variable?
For an example, my expression looks somewhat like this:
U =
108*A^2*e^7*e1^3*e2^7*h2^4 + 153*A^2*e^7*e1^5*e2^7*h2^2 + 108*A^2*e^7*e1^7*e2^3*h3^4 + 153*A^2*e^7*e1^7*e2^5*h3^2 +…
24*B^2*e^3*e1^7*e2^7*h1^4 + 95*B^2*e^5*e1^7*e2^7*h1^2 + 24*B^2*e^7*e1^3*e2^7*h2^4 + 95*B^2*e^7*e1^5*e2^7*h2^2 + …
24*B^2*e^7*e1^7*e2^3*h3^4 + 95*B^2*e^7*e1^7*e2^5*h3^2 + 9*A^2*e^2*e1^7*h1^5*h3^7 + 9*A^2*e^2*e2^7*h1^5*h2^7 +…
9*A^2*e1^2*e2^7*h1^7*h2^5 + 9*A^2*e^7*e1^2*h2^5*h3^7 + 9*A^2*e^7*e2^2*h2^7*h3^5 + 9*A^2*e1^7*e2^2*h1^7*h3^5 -…
41*B^2*e^2*e1^7*h1^5*h3^7 – 41*B^2*e^2*e2^7*h1^5*h2^7 – 12*B^2*e^4*e1^7*h1^3*h3^7 – 12*B^2*e^4*e2^7*h1^3*h2^7 -….
41*B^2*e1^2*e2^7*h1^7*h2^5 – 12*B^2*e1^4*e2^7*h1^7*h2^3 – 41*B^2*e^7*e1^2*h2^5*h3^7 – 12*B^2*e^7*e1^4*h2^3*h3^7 – …
41*B^2*e^7*e2^2*h2^7*h3^5 – 12*B^2*e^7*e2^4*h2^7*h3^3 – 41*B^2*e1^7*e2^2*h1^7*h3^5 – 12*B^2*e1^7*e2^4*h1^7*h3^3 -…
504*A^2*e^3*h1^4*h2^7*h3^7 + 9*A^2*e^5*h1^2*h2^7*h3^7 – 504*A^2*e1^3*h1^7*h2^4*h3^7 + 9*A^2*e1^5*h1^7*h2^2*h3^7 -…
504*A^2*e2^3*h1^7*h2^7*h3^4 + 9*A^2*e2^5*h1^7*h2^7*h3^2 + 2860*B^2*e^3*h1^4*h2^7*h3^7 – 377*B^2*e^5*h1^2*h2^7*h3^7 +…
2860*B^2*e1^3*h1^7*h2^4*h3^7 – 377*B^2*e1^5*h1^7*h2^2*h3^7 + 2860*B^2*e2^3*h1^7*h2^7*h3^4 – 377*B^2*e2^5*h1^7*h2^7*h3^2 +…
162*A*B*e^7*e1^7*e2^7 – 6*A*B*e^7*h2^7*h3^7 – 6*A*B*e1^7*h1^7*h3^7 – 6*A*B*e2^7*h1^7*h2^7 + 1944*A^2*e*h1^6*h2^7*h3^7 + …
1944*A^2*e1*h1^7*h2^6*h3^7 + 1944*A^2*e2*h1^7*h2^7*h3^6 – 5400*B^2*e*h1^6*h2^7*h3^7 – 5400*B^2*e1*h1^7*h2^6*h3^7 -…
245*B^2*e^6*e1^7*e2^4*h1*h3^3 + 147*B^2*e^7*e1*e2^3*h2^6*h3^4 + 48*B^2*e^7*e1*e2^5*h2^6*h3^2 – 60*B^2*e^7*e1^2*e2^6*h2^5*h3 + …
147*B^2*e^7*e1^3*e2*h2^4*h3^6 – 245*B^2*e^7*e1^4*e2^6*h2^3*h3 + 48*B^2*e^7*e1^5*e2*h2^2*h3^6 – 60*B^2*e^7*e1^6*e2^2*h2*h3^5 -…
where e , e1, e2, h1, h2, h3, A, B are the symbolic variables. I have an extremely long symbolic expression after simplification which I am unable to simplify further. I want to know how to reduce the expression further, or to find repeating sub expressions inside the expression which can be replaced by another variable?
For an example, my expression looks somewhat like this:
U =
108*A^2*e^7*e1^3*e2^7*h2^4 + 153*A^2*e^7*e1^5*e2^7*h2^2 + 108*A^2*e^7*e1^7*e2^3*h3^4 + 153*A^2*e^7*e1^7*e2^5*h3^2 +…
24*B^2*e^3*e1^7*e2^7*h1^4 + 95*B^2*e^5*e1^7*e2^7*h1^2 + 24*B^2*e^7*e1^3*e2^7*h2^4 + 95*B^2*e^7*e1^5*e2^7*h2^2 + …
24*B^2*e^7*e1^7*e2^3*h3^4 + 95*B^2*e^7*e1^7*e2^5*h3^2 + 9*A^2*e^2*e1^7*h1^5*h3^7 + 9*A^2*e^2*e2^7*h1^5*h2^7 +…
9*A^2*e1^2*e2^7*h1^7*h2^5 + 9*A^2*e^7*e1^2*h2^5*h3^7 + 9*A^2*e^7*e2^2*h2^7*h3^5 + 9*A^2*e1^7*e2^2*h1^7*h3^5 -…
41*B^2*e^2*e1^7*h1^5*h3^7 – 41*B^2*e^2*e2^7*h1^5*h2^7 – 12*B^2*e^4*e1^7*h1^3*h3^7 – 12*B^2*e^4*e2^7*h1^3*h2^7 -….
41*B^2*e1^2*e2^7*h1^7*h2^5 – 12*B^2*e1^4*e2^7*h1^7*h2^3 – 41*B^2*e^7*e1^2*h2^5*h3^7 – 12*B^2*e^7*e1^4*h2^3*h3^7 – …
41*B^2*e^7*e2^2*h2^7*h3^5 – 12*B^2*e^7*e2^4*h2^7*h3^3 – 41*B^2*e1^7*e2^2*h1^7*h3^5 – 12*B^2*e1^7*e2^4*h1^7*h3^3 -…
504*A^2*e^3*h1^4*h2^7*h3^7 + 9*A^2*e^5*h1^2*h2^7*h3^7 – 504*A^2*e1^3*h1^7*h2^4*h3^7 + 9*A^2*e1^5*h1^7*h2^2*h3^7 -…
504*A^2*e2^3*h1^7*h2^7*h3^4 + 9*A^2*e2^5*h1^7*h2^7*h3^2 + 2860*B^2*e^3*h1^4*h2^7*h3^7 – 377*B^2*e^5*h1^2*h2^7*h3^7 +…
2860*B^2*e1^3*h1^7*h2^4*h3^7 – 377*B^2*e1^5*h1^7*h2^2*h3^7 + 2860*B^2*e2^3*h1^7*h2^7*h3^4 – 377*B^2*e2^5*h1^7*h2^7*h3^2 +…
162*A*B*e^7*e1^7*e2^7 – 6*A*B*e^7*h2^7*h3^7 – 6*A*B*e1^7*h1^7*h3^7 – 6*A*B*e2^7*h1^7*h2^7 + 1944*A^2*e*h1^6*h2^7*h3^7 + …
1944*A^2*e1*h1^7*h2^6*h3^7 + 1944*A^2*e2*h1^7*h2^7*h3^6 – 5400*B^2*e*h1^6*h2^7*h3^7 – 5400*B^2*e1*h1^7*h2^6*h3^7 -…
245*B^2*e^6*e1^7*e2^4*h1*h3^3 + 147*B^2*e^7*e1*e2^3*h2^6*h3^4 + 48*B^2*e^7*e1*e2^5*h2^6*h3^2 – 60*B^2*e^7*e1^2*e2^6*h2^5*h3 + …
147*B^2*e^7*e1^3*e2*h2^4*h3^6 – 245*B^2*e^7*e1^4*e2^6*h2^3*h3 + 48*B^2*e^7*e1^5*e2*h2^2*h3^6 – 60*B^2*e^7*e1^6*e2^2*h2*h3^5 -…
where e , e1, e2, h1, h2, h3, A, B are the symbolic variables. symbolic, expr, collect, simplify MATLAB Answers — New Questions
Rename TIF files in a folder
Hi. I have 21841 TIF format files (in a folder) with names like: Camera_6_100fps_20240403_0956560001, and so to Camera_6_100fps_20240403_09565621841. I want to rename them to the format Camera60001 so on to Camera621841. I have tried a for loop but did not succeed. Can someone please help me with this.
Thanks.Hi. I have 21841 TIF format files (in a folder) with names like: Camera_6_100fps_20240403_0956560001, and so to Camera_6_100fps_20240403_09565621841. I want to rename them to the format Camera60001 so on to Camera621841. I have tried a for loop but did not succeed. Can someone please help me with this.
Thanks. Hi. I have 21841 TIF format files (in a folder) with names like: Camera_6_100fps_20240403_0956560001, and so to Camera_6_100fps_20240403_09565621841. I want to rename them to the format Camera60001 so on to Camera621841. I have tried a for loop but did not succeed. Can someone please help me with this.
Thanks. rename, tif files, matlab MATLAB Answers — New Questions
Calling the code behind PushButton Pressed Event
Hello, Im using appdesigner and want to call the code thats behind a pushButtom pressed event:
function GetSingleSpectrumButtonPushed(app, event)
%my Code
How would I call this code without pushing the push buttonHello, Im using appdesigner and want to call the code thats behind a pushButtom pressed event:
function GetSingleSpectrumButtonPushed(app, event)
%my Code
How would I call this code without pushing the push button Hello, Im using appdesigner and want to call the code thats behind a pushButtom pressed event:
function GetSingleSpectrumButtonPushed(app, event)
%my Code
How would I call this code without pushing the push button pushbutton, event MATLAB Answers — New Questions
How to Create an Android App to Collect Accelerometer Data and Process with MATLAB Script?
Hi everyone,
I have a MATLAB script that processes data from a CSV file containing linear accelerometer data and generates a result. I need to develop an Android app that performs the following steps:
Press a button to start.
Wait for 10 seconds.
Collect linear accelerometer data for 30 seconds and save it to a CSV file.
Once the CSV file is created, apply the MATLAB script to the file and return specific results.
Is it possible to achieve this with any MATLAB add-ons, or is there a way to execute MATLAB scripts from Kotlin in Android Studio?
Thank you very much for your help!Hi everyone,
I have a MATLAB script that processes data from a CSV file containing linear accelerometer data and generates a result. I need to develop an Android app that performs the following steps:
Press a button to start.
Wait for 10 seconds.
Collect linear accelerometer data for 30 seconds and save it to a CSV file.
Once the CSV file is created, apply the MATLAB script to the file and return specific results.
Is it possible to achieve this with any MATLAB add-ons, or is there a way to execute MATLAB scripts from Kotlin in Android Studio?
Thank you very much for your help! Hi everyone,
I have a MATLAB script that processes data from a CSV file containing linear accelerometer data and generates a result. I need to develop an Android app that performs the following steps:
Press a button to start.
Wait for 10 seconds.
Collect linear accelerometer data for 30 seconds and save it to a CSV file.
Once the CSV file is created, apply the MATLAB script to the file and return specific results.
Is it possible to achieve this with any MATLAB add-ons, or is there a way to execute MATLAB scripts from Kotlin in Android Studio?
Thank you very much for your help! transferred MATLAB Answers — New Questions
How do I check if there is a function with the same name
In addition to the functions that come with matlab, I have added some additional toolboxes, so I want to make sure that there are more than one function with the same name in my directory, who can teach me.In addition to the functions that come with matlab, I have added some additional toolboxes, so I want to make sure that there are more than one function with the same name in my directory, who can teach me. In addition to the functions that come with matlab, I have added some additional toolboxes, so I want to make sure that there are more than one function with the same name in my directory, who can teach me. function MATLAB Answers — New Questions