Hi everyone! First time user here that can’t figure out a complex problem in my mind:

I am in a dental residency with other coresidents where we have to create a log of all the dental procedures that we have completed. We would like to create a Microsoft Form that we can input the information for our procedures  (ie: which location, patient age, how many of X procedure…). That data would show up on an excel sheet under one tab that has all of our aggregate inputs but then there are individual tabs for each of the residents that filters out our procedures that we have completed. That way, we can individually see our progress under my own tab while the program director can see the aggregate in tab 1. I was given a step by step in the past but it’s not working for me as to how to complete this. I’m very stuck! 

Hoping someone can understand what I am trying to do and help out please! We would really appreciate it! Happy to describe more if there is some confusion.

Thank you so much! 

​Hi everyone! First time user here that can’t figure out a complex problem in my mind:I am in a dental residency with other coresidents where we have to create a log of all the dental procedures that we have completed. We would like to create a Microsoft Form that we can input the information for our procedures  (ie: which location, patient age, how many of X procedure…). That data would show up on an excel sheet under one tab that has all of our aggregate inputs but then there are individual tabs for each of the residents that filters out our procedures that we have completed. That way, we can individually see our progress under my own tab while the program director can see the aggregate in tab 1. I was given a step by step in the past but it’s not working for me as to how to complete this. I’m very stuck! Hoping someone can understand what I am trying to do and help out please! We would really appreciate it! Happy to describe more if there is some confusion. Thank you so much!   Read More

​

Entra ID has a new Microsoft-managed conditional access policy that will be enabled from October 2024. However, Google doesn’t support the MultipleAuthN claim that ADFS (and other IdPs) do. 

Is there a work-around for this, or we just need to ensure that the new Microsoft-managed conditional access policy is disabled for all users? Otherwise, we somehow need to enable double MFA (MFA at both Google and Microsoft).

I imagine this might be an issue for any other federated IdPs that don’t support this specific SAML claim.

There is a new alternative to the `SupportsMFA` setting in the `Set-MsolDomainFederationSettings` powershell command, but it doesn’t allow you to ‘always assume MFA is utilised in the federation’ – https://learn.microsoft.com/en-us/graph/api/internaldomainfederation-update?view=graph-rest-1.0&tabs=http#federatedidpmfabehavior-values 

Thanks in advance,

Nigel

​Entra ID has a new Microsoft-managed conditional access policy that will be enabled from October 2024. However, Google doesn’t support the MultipleAuthN claim that ADFS (and other IdPs) do.  Is there a work-around for this, or we just need to ensure that the new Microsoft-managed conditional access policy is disabled for all users? Otherwise, we somehow need to enable double MFA (MFA at both Google and Microsoft). I imagine this might be an issue for any other federated IdPs that don’t support this specific SAML claim. There is a new alternative to the `SupportsMFA` setting in the `Set-MsolDomainFederationSettings` powershell command, but it doesn’t allow you to ‘always assume MFA is utilised in the federation’ – https://learn.microsoft.com/en-us/graph/api/internaldomainfederation-update?view=graph-rest-1.0&tabs=http#federatedidpmfabehavior-values  Thanks in advance,Nigel  Read More

​

We continually work to improve performance and mitigate Azure Functions cold starts – the extra time it takes for a function that hasn’t been used recently to respond to an event. We understand that no matter when your functions were last called, you want fast executions and little lag time.

In this article:

How we measure cold start and the work done to improve it in the Azure Functions platform.
What you can do to optimize your functions to improve your app’s cold start performance.
Provide your feedback on Azure Functions cold start.

How we measure Azure Functions cold start

In measuring Azure Functions performance, we prioritize the cold start of synchronous HTTP triggers in the Consumption and Flex Consumption hosting plans. That means looking at what our platform and Azure Functions host need to do to execute the first HTTP trigger function on a new instance. Then we improve it. We are also working to improve cold start for asynchronous scenarios.

To assess our progress, we run sample HTTP trigger function apps that measure cold start latencies for all supported versions of Azure Functions, in all languages, for both Windows and Linux Consumption. These sample apps are deployed in all Azure regions and subregions where Azure Functions runs. Our test function calls these sample apps every few hours to trigger a true cold start and currently generates nearly 85,000 daily cold start samples. Through this testing infrastructure we observed in past 18 months a reduction on cold start latency by approximately 53 percent across all regions and for all supported languages and platforms.

If any of the tracked metrics start to regress, we’re immediately notified and start investigating. Daily emails, alerts, and historical dashboards tell us the end-to-end cold start latencies across various percentiles. We also perform specific analyses and trigger alerts if our fiftieth percentile, ninety-ninth percentile, or maximum latency numbers regress.

In addition, we collect detailed PerfView profiles of the sample apps deployed in select regions. The breakdown includes full call stacks (user mode and kernel mode) for every millisecond spent during cold start. The profiles reveal CPU usage and call stacks, context switches, disk reads, HTTP calls, memory hard faults, common language runtime (CLR) just-in-time (JIT) compiler, garbage collector (GC), type loads, and many more details about .NET internals. We report all these details in our logging pipelines and receive alerts if metrics regress. And we’re always looking for ways to make improvements based on these profiles.

Performance improvements in the platform

Since launching Azure Functions, we’ve improved performance across the Azure platform that it runs on, in order to achieve the observed reduction in cold starts. These enhancements extended to the shared platform with Azure App Service and the new Legion platform, the operating system, storage, .NET Core, and communication channels.

We aim to optimize for the ninety-ninth–percentile latency. We delve into cold start scenarios at the millisecond level and continually fine-tune the algorithms that allocate capacity. In short, we’re always working to improve Azure Functions cold start. The following areas are our current our focus:

Function app pools. In the internal architecture, we must ensure that the right number of Function app pools are warmed up and ready to handle a cold start for all supported platforms and languages. These pools serve as placeholders in effect. Exactly how many depends on the usage per region—plus enough extra capacity to meet unexpected bursts. We’re always refining our algorithms to balance the pools without increasing costs. Placeholder processes and dependencies stay hot in memory to prevent paging out.
Ninety-ninth–percentile latencies. Although it’s relatively straightforward to optimize cold start scenarios for the fiftieth percentile, we are digging deeper to address ninety-ninth–percentile latencies, particularly when multiple VMs are involved. Each runs different processes and components and is configured with unique disk, network, and memory characteristics. It’s even harder to trace the root causes of potential ninety-ninth–percentile regressions.
Profilers. We use a multitude of specialized profiling tools capable of dissecting cold start scenarios at the millisecond level. We examine detailed call stacks and tracking activities at both the application and operating system levels. The PerfView and Event Tracing for Windows (ETW) providers are great at addressing issues with Windows and .NET-based apps, but we also investigate issues across platforms and languages. We also use Profile Guided Optimization (PGO) to ensure that Functions Host and dependent libraries are fully JIT compiled and ready to minimize the impact of platform code JIT compilation during actual cold start requests.

Histograms. If our platform detects cold starts occurring at regular intervals, we fully prewarm the instance where the function app will run to avoid cold start delays during actual execution.

6 things you can do now to improve cold start in Azure Functions

Here are a few strategies you can follow to further improve cold starts for your apps:

Deploy your function as a .zip (compressed) package. Minimize its size by removing unneeded files and dependencies, such as debug symbols (.pdb files) and unnecessary image files.
For Windows deployment, run your functions from a package file. To do this, set the WEBSITE_RUN_FROM_PACKAGE=1 app setting. If your app uses storage for storing content, deploy Azure Storage in the same region as your Azure Functions app and consider using premium storage for a faster cold start.
When deploying .NET apps, publish with ReadyToRun to avoid additional costs from the JIT compiler.
In the Azure portal, navigate to your function app. Go to Diagnose and solve problems, and review any messages that appear under Risk alerts. Look for issues that may impact cold starts.
If your app uses a Premium or App Service plan, invoke warmup triggers to preload dependencies or to add any custom logic required to connect to external endpoints. This option isn’t supported for apps on Consumption plans.
To help mitigate cold starts, try the always ready instances feature of our newest hosting option for event-driven serverless functions, Flex Consumption.

Final Thoughts

If your Azure Functions app still doesn’t perform as well as you’d like, consider the following:

Share your feedback on Azure Functions cold start to get in touch with the team.
try the always ready instances feature of our newest hosting option for event-driven serverless functions, Flex Consumption.

Note: This article is a modified version of the article originally published on Newsstack.

​Microsoft Tech Community – Latest Blogs –Read More 

Q: I have a question about a customer changing plans where the pricing uses metered billing.

For example, the plan purchased by customer is plan1 with no of emails included in this plan as 100. Assume up-to-date email consumption is 500 emails, then the customer changes the plan in the middle of the month to the higher plan which will include 1000 emails included. 

-Plan1 include 100emails.

-Consumption is 500emails by mid of the month.

-Mid of the month – change plan to Plan2 include 1000emails.

Based on the documentation saying “Changes you make to a plan you are subscribed to will take effect immediately. The billing is prorated according to the billing term of the current plan.”

https://learn.microsoft.com/en-us/marketplace/saas-subscription-lifecycle-management#change-plans

Based on this scenario, how is the billing calculated? How are the exceeded emails calculated?

A: The number of included dimension units in a plan (emails in this case) is partner managed, so it’s something the ISV needs to track and measure and decide how to handle

In your case if a customer changes plan mid-month, given plan1 is $10 and includes 100 emails, and plan2 is $50 and includes 1000 emails, the flat rate cost will be prorated by Microsoft ($5 for half a month on plan1 plus $25 for half a month on plan2) but the allotted emails is at the ISV’Ss discretion (50 emails from half a month on plan1 and 500 emails for half a month on plan2).

Based on that calculation, the partner only sends metered overages when the customer goes over the 550 emails limit during that period.

There are other edge cases as well:

– if the customer used all 100 free emails in plan1 then wants to switch to a free plan, the ISV can block that plan change

– if the customer used 200 emails in plan1 and ISV already charged them the 100 extra, when the customer changed to plan2, they would have already paid for something that would be included in plan2 – the ISV cannot refund previously sent meters, but they can choose not to charge next time customer goes over their allotted emails count, or they can simply specify in the terms that switching mid-month causes this extra cost.

​Q: I have a question about a customer changing plans where the pricing uses metered billing.
For example, the plan purchased by customer is plan1 with no of emails included in this plan as 100. Assume up-to-date email consumption is 500 emails, then the customer changes the plan in the middle of the month to the higher plan which will include 1000 emails included. 
 
-Plan1 include 100emails.
-Consumption is 500emails by mid of the month.
-Mid of the month – change plan to Plan2 include 1000emails.
 
Based on the documentation saying “Changes you make to a plan you are subscribed to will take effect immediately. The billing is prorated according to the billing term of the current plan.”
https://learn.microsoft.com/en-us/marketplace/saas-subscription-lifecycle-management#change-plans
 
Based on this scenario, how is the billing calculated? How are the exceeded emails calculated?
 
A: The number of included dimension units in a plan (emails in this case) is partner managed, so it’s something the ISV needs to track and measure and decide how to handle
 
In your case if a customer changes plan mid-month, given plan1 is $10 and includes 100 emails, and plan2 is $50 and includes 1000 emails, the flat rate cost will be prorated by Microsoft ($5 for half a month on plan1 plus $25 for half a month on plan2) but the allotted emails is at the ISV’Ss discretion (50 emails from half a month on plan1 and 500 emails for half a month on plan2).
 
Based on that calculation, the partner only sends metered overages when the customer goes over the 550 emails limit during that period.
 
There are other edge cases as well:
– if the customer used all 100 free emails in plan1 then wants to switch to a free plan, the ISV can block that plan change
– if the customer used 200 emails in plan1 and ISV already charged them the 100 extra, when the customer changed to plan2, they would have already paid for something that would be included in plan2 – the ISV cannot refund previously sent meters, but they can choose not to charge next time customer goes over their allotted emails count, or they can simply specify in the terms that switching mid-month causes this extra cost.  Read More

​

With thanks to:

I am nearly finished on this project that must find the earliest, latest and peak dates in a range of dates. 
I now need to adapt the formula to be used on the Latest dates, which are always three cells on from each of the earliest dates in the range. 

Will I now be able to find the latest date (by day and month only) if I can adapt the formula that was successfully deployed for Earliest dates?

This is the formula being used for identifying Earliest dates:

 =AGGREGATE(15,6, $D3:$AQ3 /( (MONTH($D3:$AQ3)*100+DAY($D3:$AQ3)) = AGGREGATE(15,6,( MONTH($D3:$AQ3)*100+DAY($D3:$AQ3) )/NOT( MOD(COLUMN($D3:$AQ3),4) ),1)  ),1)

Here is the table so far: 

​With thanks to:Peter Bartholomew; djclementsand Sergei Baklan. I am nearly finished on this project that must find the earliest, latest and peak dates in a range of dates. I now need to adapt the formula to be used on the Latest dates, which are always three cells on from each of the earliest dates in the range. Will I now be able to find the latest date (by day and month only) if I can adapt the formula that was successfully deployed for Earliest dates?This is the formula being used for identifying Earliest dates: =AGGREGATE(15,6, $D3:$AQ3 /( (MONTH($D3:$AQ3)*100+DAY($D3:$AQ3)) = AGGREGATE(15,6,( MONTH($D3:$AQ3)*100+DAY($D3:$AQ3) )/NOT( MOD(COLUMN($D3:$AQ3),4) ),1)  ),1) Here is the table so far:     Read More

​

Hello!
So I would like to use a calculated field inside my Pivot Table. But somehow the formula is not respected.

I have the following columns:

Stock; Withdraw Rate; Usage

1000; 0,3; x

Somehow instead of displaying 1000*0,3=300 the table shows 700. Which means somehow the result of the formula is being deducted from the source value of 1000.

Does anyone know how to fix that?

Thank you

​Hello!So I would like to use a calculated field inside my Pivot Table. But somehow the formula is not respected.I have the following columns: Stock; Withdraw Rate; Usage1000; 0,3; x Somehow instead of displaying 1000*0,3=300 the table shows 700. Which means somehow the result of the formula is being deducted from the source value of 1000.Does anyone know how to fix that? Thank you   Read More

​