Category: Microsoft
Category Archives: Microsoft
The Formula Reference Slippage Problem in MS Excel for Mac
When working with a large, multi-sheet Excel workbook on MacBook Pro (M1), I started encountering a strange issue when inserting rows on one of the worksheets. What happens is that some formulas “slip” or “miss” their intended references after some row insertion/deletion (not those rows having any relation to the affected formulas or references).
In my case the formulas mistakenly referenced a different row, often one row above the original target row. It is as if Excel is confused by (multiple) row deletions or insertions.
Even worse – it was NOT possible to “undo” the action. I made a couple of tests with insert row actions. I could detect the exact moment it happens (in my case, the circular reference occurred because of the reference slip), but no “undo” could fix it. (I had to start from the last saved version, which I paranoiacally make every 15 min or so … luckily).
This makes the whole thing unusable. I took the same excel file and continued working on Windows – it doesn’t happen there.
Anyone had anything similar ever happen with Excel (on Mac)?
When working with a large, multi-sheet Excel workbook on MacBook Pro (M1), I started encountering a strange issue when inserting rows on one of the worksheets. What happens is that some formulas “slip” or “miss” their intended references after some row insertion/deletion (not those rows having any relation to the affected formulas or references). In my case the formulas mistakenly referenced a different row, often one row above the original target row. It is as if Excel is confused by (multiple) row deletions or insertions. Even worse – it was NOT possible to “undo” the action. I made a couple of tests with insert row actions. I could detect the exact moment it happens (in my case, the circular reference occurred because of the reference slip), but no “undo” could fix it. (I had to start from the last saved version, which I paranoiacally make every 15 min or so … luckily). This makes the whole thing unusable. I took the same excel file and continued working on Windows – it doesn’t happen there. Anyone had anything similar ever happen with Excel (on Mac)? Read More
where t0 find planner
SO i just got 365 personal and teams personal but cannot find planner anywhere. can anyone help?
SO i just got 365 personal and teams personal but cannot find planner anywhere. can anyone help? Read More
1000+ Ảnh gái xinh vú đẹp, to tròn, quyến rũ nhất thế giới
Vú đẹp là mong ước của hầu hết tất cả các chị em. Để sở hữu khuôn ngực đầy đặn, căng tròn, quyến rũ để có vóc dáng thêm tự tin. Khi có cặp vú đẹp, việc lựa chọn áo đồ trở nên dễ dàng hơn. Những bộ váy hoặc áo đầm dáng vừa sẽ làm nổi bật và tôn lên vóc dáng thanh mảnh. Vú đẹp là cách chỉ những chị em có vòng 1 căng tràn, tròn trịa, quyến rũ, có độ cong hoàn hảo, cân đối với vóc dáng giúp các nàng thêm phần hấp dẫnproseovip Read More
multiple Login tries from different places
hi, from a long time I’m facing a really threatening issue of SOMEONE trying to login to my account.
my sign in history shows that after like every 2 hours a new guy from new place is trying to log into my account but unable to do it coz of wrong password.
Now this is really scary coz in a way someone is just keep on trying to use different passwords until he got the right one.
I’m not getting what to do right now instead just waiting when he logs in and then log out from there.
otherwise, I have used almost kind of Secuity measures like using authenticator app and two step verification.
If anyone know anything that i can do right now from stop this then please help
hi, from a long time I’m facing a really threatening issue of SOMEONE trying to login to my account.my sign in history shows that after like every 2 hours a new guy from new place is trying to log into my account but unable to do it coz of wrong password.Now this is really scary coz in a way someone is just keep on trying to use different passwords until he got the right one.I’m not getting what to do right now instead just waiting when he logs in and then log out from there.otherwise, I have used almost kind of Secuity measures like using authenticator app and two step verification.If anyone know anything that i can do right now from stop this then please help Read More
Intel iCSL driver SSL version
Our Defender reports that the Intel iCLS driver uses an outdated and unsafe OpenSSL version.
After contacting Intel they told me to update to version 1.72.189.0.
I can find (and manually install) this driver at the MS catalog (https://www.catalog.update.microsoft.com/Search.aspx?q=intel%20icls%20windows%2011%20%201.72.189.0) but I do not whish to roll out a driver this way to 250+ devices.
The releasedate is march 7th. There are 5 files from 4 different companies (non of which is the manufacturer of my device (Dell))
My question is why the update is not pushed through Windows Update. I this something Microsoft should do or should I pressure Dell?
Our Defender reports that the Intel iCLS driver uses an outdated and unsafe OpenSSL version.After contacting Intel they told me to update to version 1.72.189.0.I can find (and manually install) this driver at the MS catalog (https://www.catalog.update.microsoft.com/Search.aspx?q=intel%20icls%20windows%2011%20%201.72.189.0) but I do not whish to roll out a driver this way to 250+ devices.The releasedate is march 7th. There are 5 files from 4 different companies (non of which is the manufacturer of my device (Dell))My question is why the update is not pushed through Windows Update. I this something Microsoft should do or should I pressure Dell? Read More
bot popup in teams
Hi, I’m trying to create a bot app in Teams that will display some information on the adaptive cards. The adaptive cards will have 2 buttons(Yes, No). Both buttons have an action type as “Action. Submit”. Earlier when the user clicked the button, the received event will have the type “invoke”, but now I received the event type as “message”.
I’m trying to show a modal popup that contains some input fields and a submit button when the no button is clicked. I’m unable to do it now.
CARD:
{
“type”: “message”,
“attachments”: [
{
“ContentType”: “application/vnd.microsoft.card.adaptive”,
“content”: {
“$schema”: “http://adaptivecards.io/schemas/adaptive-card.json”,
“type”: “AdaptiveCard”,
“version”: “1.5”,
“body”: [
{
“type”: “TextBlock”,
“text”: “Some text”,
“wrap”: true,
“size”: “medium”,
“weight”: “bolder”
},
{
“type”: “TextBlock”,
“text”: “Some text”,
“wrap”: true,
“size”: “Default”
}
],
“actions”: [
{“type”: “Action.Submit”, “title”: “Yes”, “data”: {}},
{“type”: “Action.Submit”, “title”: “No”, “data”: {}},
],
},
}
]
}
On receiving the no button clicked event, I’m responding with
{
“task”: {
“type”: “continue”,
“value”: {
“card”: {
“ContentType”: “application/vnd.microsoft.card.adaptive”,
“content”: {
“$schema”: “http://adaptivecards.io/schemas/adaptive-card.json”,
“type”: “AdaptiveCard”,
“version”: “1.5”,
“body”: [
{
“type”: “Input.Text”,
“id”: “Some text”,
“placeholder”: “Enter your text”,
“isRequired”: true,
“errorMessage”: “This field is required”,
}
],
“actions”: [
{“type”: “Action.Submit”, “title”: “Submit”, “data”:{}}
],
},
}
},
}
}
But the popup is not displayed.
Hi, I’m trying to create a bot app in Teams that will display some information on the adaptive cards. The adaptive cards will have 2 buttons(Yes, No). Both buttons have an action type as “Action. Submit”. Earlier when the user clicked the button, the received event will have the type “invoke”, but now I received the event type as “message”. I’m trying to show a modal popup that contains some input fields and a submit button when the no button is clicked. I’m unable to do it now.CARD: {
“type”: “message”,
“attachments”: [
{
“ContentType”: “application/vnd.microsoft.card.adaptive”,
“content”: {
“$schema”: “http://adaptivecards.io/schemas/adaptive-card.json”,
“type”: “AdaptiveCard”,
“version”: “1.5”,
“body”: [
{
“type”: “TextBlock”,
“text”: “Some text”,
“wrap”: true,
“size”: “medium”,
“weight”: “bolder”
},
{
“type”: “TextBlock”,
“text”: “Some text”,
“wrap”: true,
“size”: “Default”
}
],
“actions”: [
{“type”: “Action.Submit”, “title”: “Yes”, “data”: {}},
{“type”: “Action.Submit”, “title”: “No”, “data”: {}},
],
},
}
]
} On receiving the no button clicked event, I’m responding with {
“task”: {
“type”: “continue”,
“value”: {
“card”: {
“ContentType”: “application/vnd.microsoft.card.adaptive”,
“content”: {
“$schema”: “http://adaptivecards.io/schemas/adaptive-card.json”,
“type”: “AdaptiveCard”,
“version”: “1.5”,
“body”: [
{
“type”: “Input.Text”,
“id”: “Some text”,
“placeholder”: “Enter your text”,
“isRequired”: true,
“errorMessage”: “This field is required”,
}
],
“actions”: [
{“type”: “Action.Submit”, “title”: “Submit”, “data”:{}}
],
},
}
},
}
} But the popup is not displayed. Read More
Can we share site content Inside sharepoint to outsider
Can we share site content Inside sharepoint to outsider.
Sharing options are greyed out when sharing from SharePoint Online or OneDrive.
Can we share site content Inside sharepoint to outsider.Sharing options are greyed out when sharing from SharePoint Online or OneDrive. Read More
Bugs in Microsoft Defender for Cloud | Regulatory Compliance
I already enroll the required Microsoft Defender plan since yesterday, but till today the remediation has not been made till now from the Azure portal page. And not only that but for other remediation also i have finished fixing but the changes has not been reflected where it is already comply.
I already enroll the required Microsoft Defender plan since yesterday, but till today the remediation has not been made till now from the Azure portal page. And not only that but for other remediation also i have finished fixing but the changes has not been reflected where it is already comply. Read More
How can I raise my complaint in Flip+kart?
Contact no. : 06370-523-079
Upon the receipt of a Consumer Grievance on the channels specified above. …
“Consumer Care” and “Grievance Officer” shall take all the best endeavors to resolve the grievance as expeditiously within the timeline as prescribed in the applicable laws.
Contact no. : 06370-523-079Upon the receipt of a Consumer Grievance on the channels specified above. …“Consumer Care” and “Grievance Officer” shall take all the best endeavors to resolve the grievance as expeditiously within the timeline as prescribed in the applicable laws. Read More
I need to understand the intergation of my ongoing softwares with Onedrive, before purchasing produc
I am planning to get onedrive annual plan, but i am struggling to find answers to few of my queries:
1. What if different users simultaneosly editing the data on onedrive? Which version will be saved?
2. If a user is editing the data from remote location, would it automatically gets updated in my office’s server?
3. I have a software which is system specific software, how will it work with onedrive?
To be specific – my team mostly works on these two softwares
a) Tally Software
b) Winman Software
I am planning to get onedrive annual plan, but i am struggling to find answers to few of my queries: 1. What if different users simultaneosly editing the data on onedrive? Which version will be saved? 2. If a user is editing the data from remote location, would it automatically gets updated in my office’s server?3. I have a software which is system specific software, how will it work with onedrive? To be specific – my team mostly works on these two softwares a) Tally Software b) Winman Software Read More
Customizable shortcuts for ZoomIt?
The video recording feature is wonderful, but the expanding shortcuts conflict a lot with my existing settings of various programs, e.g. VSCode. Due to this reason I have to stick with v6.1.2. It would be dreamy if the shortcuts could be customized. Thanks!
The video recording feature is wonderful, but the expanding shortcuts conflict a lot with my existing settings of various programs, e.g. VSCode. Due to this reason I have to stick with v6.1.2. It would be dreamy if the shortcuts could be customized. Thanks! Read More
Industry Mentoring Matters
MVPs are helping prepare university students for the challenges and opportunities of the real world through the Microsoft Data & AI Bootcamp, hosted in partnership with Akkodis.
The two-week long bootcamp was designed to address the barriers that students may face in obtaining a technology certification by providing a flexible and accelerated learning program. In addition, the bootcamp highlighted the importance of building interpersonal skills through the power of networking, being an active participant in a wider community and empowering the students to showcase the best version of themselves on LinkedIn.
Connecting Microsoft MVPs to our next generation of leaders
Mentoring is a powerful form of professional development that connects experienced professionals in a field of interest, offering mentees guidance, feedback, and insights. During the Microsoft Data & AI Bootcamp, 28 passionate MVPs from across Australia and New Zealand put their hands up to give back as industry mentors in a Mentoring Circle session.
Microsoft MVP for M365, Cameron Dwyer, who works as a Chief Technology Officer, led a mentoring circle during the bootcamp. He describes being a mentor as a fulfilling experience, particularly in today’s rapidly evolving IT landscape.
Cameron says, “the rate of change, driven significantly by advancements in cloud computing and AI, presents both exciting opportunities and new challenges. Sharing knowledge and experiences to help navigate this dynamic environment was both rewarding and enlightening.”
“It is easy to forget how much business and industry knowledge you build up over a career. Hearing some of the questions that came out during mentoring, it wasn’t so much the technical skills that were blocking people taking the next step in their career it was more about the unknowns of the business world and how to go about finding that first role. It was a privilege to be part of their journey and growth,” continued Cameron.
The Iceberg Theory
Luke Murray, a Microsoft Azure MVP and Cloud Architect & Consultant, shared his experiences as a tech professional in the bootcamp as a mentor. Luke also provided an Azure demo to the students studying for their Microsoft AI-900 certification and revealed insights on navigating a career during a Careers in Tech panel alongside other industry leaders, including Arafat Tehsin, AI Platform MVP.
When it comes to building a career in technology, Luke believes that whilst technology is always changing, the IT industry is almost an ever-green industry. He encouraged the students to either follow their passion areas or follow what they are curious about.
Luke compared a career journey to an iceberg analogy. “What people see is above the line (above the water). However, underneath the line (underneath the surface) is persistence, failure, hard work, most of us didn’t land our ideal job or role, some of us are still looking and that ideal role you may want can change – as technology changes, or what you want to do changes based on your own experience, and that’s ok, but in the end, we are learning, adapting, growing with each step,” explained Luke.
He continued, “instead of looking for a role that suits, look for a goal – something that you may want to achieve, or be part of, then you can reach out to likeminded people, locally or globally, who might work on or be part of the same goal, a job role, then becomes a means to achieving that goal.”
Focus on understanding core concepts & experiment by building projects
Cameron recommends those navigating their career to understand the core concepts we are trying to solve with technology and not so much focus on memorising the technical details. He says, “as technologies constantly evolve, it’s crucial to grasp the underlying principles, understand the problems they aim to solve, and how they conceptually address those issues. The specifics, like syntax and commands, can always be looked up in manuals or guides. It’s impractical to memorize every technical detail, but if you focus on understanding the core concepts and their applications, you’ll be well-equipped to find the finer details when necessary.”
“That doesn’t mean just read the concepts and you’ll be ok. I encourage you to dive in and experiment with the technology by building projects yourself. Although it might seem daunting at first, I’ve seen time and again that creating something from scratch gives a profound sense of empowerment. It’s like acquiring a new tool that unlocks the ability to build things you never thought possible, opening up a world of opportunities”, explained Cameron.
A mentoring exercise from Luke Murray
For Luke, having been around formal and informal mentors during his career, has helped him navigate frustrating and uncertain times. He is passionate about giving back and sharing his knowledge as a mentor. Luke also benefits through mentoring as he gets the opportunity to talk to people at various points in their own career and different backgrounds, and learn from them directly, helping to give Luke an open-minded perspective.
Luke shared an exercise that has been useful in his own career, called Fear Setting – What If, which is inspired by author, Tim Ferriss in this TED Talk. Whether you are a mentee or mentor, feel free to use this in your own mentoring journey.
Step
Description
Define Your Fear
Write down what you are afraid of. Be specific and detailed. This could be anything from starting a new project, asking for a raise, ending a relationship, etc. Include all the worst things you can imagine happening if you take the step you’re considering.
Prevent
For each worst-case scenario you’ve listed, write down what you could do to prevent it from happening. Think of strategies or actions that could decrease the likelihood of these fears coming true.
Repair
Consider what you could do to repair the damage if the worst-case scenario does happen. This could include people you could ask for help or steps you could take to recover.
Benefits of Attempt or Partial Success
Reflect on the potential benefits of attempting the action or even achieving partial success. This helps balance out the focus on the negative and can provide motivation for moving forward.
Cost of Inaction
Consider the cost of not taking the action. This is often overlooked but is crucial. Reflect on what your life might look like in six months, a year, or three years if you don’t take this action.
How can MVPs empower student communities
MVPs bring so much value to the wider community as industry mentors and it is one of the best ways to empower students. Hearing from those who have been there and done that, can be very inspirational.
Industry professionals and MVPs can encourage students to join the Microsoft Learn Student Ambassador program, or connect directly with Student Ambassadors for community collaboration or mentoring through Find an Ambassador.
Microsoft Tech Community – Latest Blogs –Read More
Unable to Create Batch Pool in Batch Account with Batch Explorer Tool
Description:
I am encountering an issue while creating a batch pool using the Batch Explorer as mentioned in the msdn Tutorial: Run a Batch job through Azure Data Factory – Azure Batch | Microsoft Learn. Despite following the standard procedures, I am unable to successfully create the pool. I have detailed the steps and configuration below.
Issue Details:
Service: Batch AccountTool: Batch ExplorerError Message: [“resizeErrors”: [
{
“code”: “OperationsRestrictedByPolicy”,
“message”: “Assigned policy on resource has blocked pool operation.”,
“values”: [
{
“name”: “Code”,
“value”: “OperationsOnNetworkSecurityGroupRestrictedByPolicy”
},
{
“name”: “Reason”,
“value”: “Policy is forbidding operations on the Network Security Group resource, which has blocked resize/create/delete of the pool. Check policy assignment.”
}
]
}]Error Screenshot:
Steps to Reproduce: Tutorial: Run a Batch job through Azure Data Factory – Azure Batch | Microsoft Learn
Sign in to Batch Explorer with Azure credentials.Select the Batch account.Navigate to Pools on the left sidebar, and select the + icon to add a pool.Complete the Add a pool to the account form as follows:Under ID, enter custom-activity-pool.Under Dedicated nodes, enter 2.For Select an operating system configuration, select the Data science tab, and then select Dsvm Win 2019.For Choose a virtual machine size, select Standard_F2s_v2.For Start Task, select Add a start task. On the start task screen, under Command line, enter cmd /c “pip install azure-storage-blob pandas”, and then select Select.Enable network configuration with virtual network to use private endpoints.[Error is coming when we enable the network configuration with private virtual network]Select Save and close.
Description:I am encountering an issue while creating a batch pool using the Batch Explorer as mentioned in the msdn Tutorial: Run a Batch job through Azure Data Factory – Azure Batch | Microsoft Learn. Despite following the standard procedures, I am unable to successfully create the pool. I have detailed the steps and configuration below.Issue Details:Service: Batch AccountTool: Batch ExplorerError Message: [“resizeErrors”: [ { “code”: “OperationsRestrictedByPolicy”, “message”: “Assigned policy on resource has blocked pool operation.”, “values”: [ { “name”: “Code”, “value”: “OperationsOnNetworkSecurityGroupRestrictedByPolicy” }, { “name”: “Reason”, “value”: “Policy is forbidding operations on the Network Security Group resource, which has blocked resize/create/delete of the pool. Check policy assignment.” } ] }]Error Screenshot: Steps to Reproduce: Tutorial: Run a Batch job through Azure Data Factory – Azure Batch | Microsoft LearnSign in to Batch Explorer with Azure credentials.Select the Batch account.Navigate to Pools on the left sidebar, and select the + icon to add a pool.Complete the Add a pool to the account form as follows:Under ID, enter custom-activity-pool.Under Dedicated nodes, enter 2.For Select an operating system configuration, select the Data science tab, and then select Dsvm Win 2019.For Choose a virtual machine size, select Standard_F2s_v2.For Start Task, select Add a start task. On the start task screen, under Command line, enter cmd /c “pip install azure-storage-blob pandas”, and then select Select.Enable network configuration with virtual network to use private endpoints.[Error is coming when we enable the network configuration with private virtual network]Select Save and close. Read More
Network Related issues for Function App Synctriggers
In my previous blog: Simple Self-Troubleshooting Steps for Function App Not Seeing Triggers, I‘ve mentioned a simple self-check method for Synctriggers. However, more and more enterprises are leaning towards using more secure network architectures. Due to the involvement of many different components, it is easy for minor configuration issues to cause the entire app to be unusable. Therefore, in this article, I will delve into more detailed content, specifically discussing NSG, UDR, DNS, and Storage Account.
TOC
NSG rules
UDR and Firewall
DNS
Storage Account
NSG rules
Please refer to this network architecture diagram first. Most enterprises want the Function App to run in a completely private network environment, hence this setup.
For outbound traffic, since the Function App is set up with VNET integration, NSG (i.e., Network Security Group) can be used to restrict which protocols and ports are allowed, and UDR (i.e., User Defined Route / Route Table) can be used to control which routes different source and destination traffic should take.
For inbound traffic, since the Function App is set up with a Private Endpoint, NSG can be used to restrict which protocols and ports are allowed to be accepted.
Firstly, in Azure’s network architecture, an invocation passes through various resources in the following order: outbound NSG > outbound UDR > inbound NSG.
Let’s take a look at the configuration of each sample component.
1) In the outbound NSG “NSG-SNET-FUNCTION-APP” rules are matched in order of ascending priority. Therefore, this synctriggers invocation (i.e., TCP port 443) will match the first rule “Rule_1”
Name
Access
Direction
Protocol
Priority
Source Address Prefix
Source Port Range
Destination Address Prefix
Destination Port Range
Rule_1
Allow
Outbound
*
100
VirtualNetwork
*
VirtualNetwork
*
Rule_2
Deny
Outbound
*
200
*
*
*
*
2) In the outbound route table “RT-SNET-FUNCTION-APP” rules are matched based on the specificity of the target address, with more specific addresses taking precedence. In this example, this invocation will match the only one rule, directing all the traffic to firewall for additional processing.
3) In the inbound NSG “NSG-SNET-PE” the invocation will finally match “Rule_2” such that the traffic will be blocked.
Name
Access
Direction
Protocol
Priority
Source Address Prefix
Source Port Range
Destination Address Prefix
Destination Port Range
Rule_1
Deny
Inbound
Udp
100
*
*
*
*
Rule_2
Deny
Inbound
Tcp
200
*
*
*
*
The solution is to add a rule in ‘NSG-SNET-PE’ that allows TCP port 443, such as ‘Rule_3’.
Name
Access
Direction
Protocol
Priority
Source Address Prefix
Source Port Range
Destination Address Prefix
Destination Port Range
Rule_3
Allow
Inbound
TCP
50
VirtualNetwork
*
VirtualNetwork
443
Rule_1
Deny
Inbound
Udp
100
*
*
*
*
Rule_2
Deny
Inbound
Tcp
200
*
*
*
*
If you are unsure whether the relevant traffic complies with the expected NSG rules during transmission, you can temporarily record these behaviors by setting up ‘NSG flow logs’
Step 1. Please separately go to your each target NSG on the Azure Portal.
Step 2. Select “NSG flow logs” and click “Create”.
Step 3. Choose “Network security group” and then select “Select target Resource” as “Network security group”.
Step 4. Choose the Storage Account where the logs will be stored as blobs. After confirming, click “Review + Create” and then “Create”.
Step 5. After creation, wait 5 minutes for it to take effect.
Step 6. After creation, try to reproduce synctriggers connection. Please record the detailed operation time in UTC+0 format.
Step 7. After reproduction, please wait 10 minutes to ensure all logs are written to the corresponding Storage Account before exporting them.
Step 8. Go to the corresponding Storage Account, select “Containers”, then “insights-logs-networksecuritygroupflowevent”.
Step 9. Click on “Switch to Access key”.
Step 10. This step is a bit troublesome, as you need to obtain log files from different folders based on different conditions (NSG name/time). You can refer to the picture; below is the folder structure where you might need to obtain files.
Step 11. Use a JSON parser to open this file to verify the requests, it’s an example.
UDR and Firewall
The primary purpose of setting up UDR is to route outbound traffic from the VNET through a Firewall for execution and logging. In this example, all traffic from the Function App will be executed through the Firewall.
As different enterprises may use different brands of Firewalls, the log formats may vary. Generally, as shown in the diagram, it appears that all traffic from the Function App to its Private Endpoint is being blocked by the Firewall rules.
The solution is to modify the ‘default-block’ rule or add a new rule to override it, allowing all TCP port 443 traffic from 10.10.1.0/24 to 10.10.2.0/24
DNS
Most enterprises also want to maintain their own internal DNS Server. In this example, when the Function App sends a request to its Private Endpoint, the following process occurs:
1) my-function-app tries to resolve its Private Endpoint using the Custom DNS under VNET-FUNCTION-APP.
2) Since VNET-FUNCTION-APP is configured to route all traffic through the Firewall, the actual requester is the Firewall.
3) The Firewall uses the Azure DNS under VNET-FIREWALL to resolve its Private Endpoint.
4) Since the privatelink.azurewebsites.net Private DNS Zone does not have a Virtual network link with VNET-FIREWALL, the Azure DNS under VNET-FIREWALL cannot resolve my-function-app.azurewebsites.net using the recursive resolver function.
5) The request fails due to the resolution failure.
There are two solutions to this issue:
Solution 1: Modify the DNS Server in VNET-FIREWALL to 10.11.1.1, 10.11.1.2, which is the custom DNS Server.
Solution 2: Create a virtual network link for privatelink.azurewebsites.net to connect to the VNET-FIREWALL.
Assuming we use Solution 1, the process will continue as follows:
3) The Firewall uses the custom DNS Server under VNET-FIREWALL to resolve its Private Endpoint.
4) The Custom DNS Server can add an A record for my-function-app.azurewebsites.net pointing to 10.10.2.1, or implement a conditional forwarder as described in this article (Azure DNS Private Resolver – Azure Example Scenarios), forwarding unknown domains to Azure DNS for resolution using the recursive resolver function.
5) After the resolution is complete and the Private Endpoint IP is obtained, the actual request will be initiated.
Storage Account
The Synctriggers behavior saves a file named ‘last’ under the Storage blob to record the execution details using a hash.
Therefore, before each execution, the Function App communicates with the Storage Account to ensure that Synctriggers can continue to execute. Consequently, the network between the Function App and the Storage Account is a key consideration for Synctriggers. Please refer to the following architecture diagram.
In this diagram, we need to ensure:
1) The Private Endpoints for both blob and file services of the Storage are enabled.
2) The corresponding Private DNS Zones ‘privatelink.blob.core.windows.net’ and ‘privatelink.file.core.windows.net’ have established virtual network links with the relevant VNET.
3) The NSG needs to set up rules to allow or receive requests on TCP ports 443/445.
4) The Firewall also needs to set up rules to allow requests on TCP ports 443/445 from specific sources or destinations.
Microsoft Tech Community – Latest Blogs –Read More
DFCI reset verification code – where to find the documentation around this process?
I have a Surface Pro device where I need to re-enable ‘boot from USB devices’, but I need to follow the ‘Enter DFCI reset verification code’ process since ‘boot from USB devices’ is greyed out due to Company policy. None of the admins in my company have ever done this process before.
Question: where can I find documentation around DFCI and ‘Reset Requests’ that describes this process in detail?
I have a Surface Pro device where I need to re-enable ‘boot from USB devices’, but I need to follow the ‘Enter DFCI reset verification code’ process since ‘boot from USB devices’ is greyed out due to Company policy. None of the admins in my company have ever done this process before. Question: where can I find documentation around DFCI and ‘Reset Requests’ that describes this process in detail? Read More
Defender for Server without Internet access
Hi All,
I don’t want to expose my servers to internet using a proxy or any other mechanism.
Is there any possibility to deploy & manage Defender for both Windows & Linux servers?
If yes, what are the risks and challenges?
All servers are Windows 2022 servers. For definition updates, can i use either SCCM or any other product?
Hi All, I don’t want to expose my servers to internet using a proxy or any other mechanism. Is there any possibility to deploy & manage Defender for both Windows & Linux servers? If yes, what are the risks and challenges? All servers are Windows 2022 servers. For definition updates, can i use either SCCM or any other product? Read More
CoPilot Studio Learning Path for Citizen Developers/Business Users
Hello Members,
Looking for an comprehensive learning path(ready-made or custom) for CoPilot Studio. The audience are Citizen Developers/Business Users. Pls share information if you have created one for your organization/company.
Thanks,
Amit
Hello Members,Looking for an comprehensive learning path(ready-made or custom) for CoPilot Studio. The audience are Citizen Developers/Business Users. Pls share information if you have created one for your organization/company. Thanks,Amit Read More
Azure Data Factory Linked Service to connect Batch Account and Node with private endpoint
HI All,
I am trying to connect batch account and batch pool from Azure Data Factory where batch pool is configured in private network.
Steps followed.
1. created private link service to connect batch account and node by adding the domain names of batch account and node
2. tried to establish connection but it failed to connect to batch pool (pool with virtual network).
I am not clear on the steps to be implemented in loan balancer which needs to be configured for private links service. I have added front end ip as Virtual network IP, backend pool as batch pool ip.
I couldn’t find proper document for this setup. please help if anyone come across this scenario or any document which explains in detail.
Thanks,
Sathish
HI All, I am trying to connect batch account and batch pool from Azure Data Factory where batch pool is configured in private network. Steps followed. 1. created private link service to connect batch account and node by adding the domain names of batch account and node2. tried to establish connection but it failed to connect to batch pool (pool with virtual network). I am not clear on the steps to be implemented in loan balancer which needs to be configured for private links service. I have added front end ip as Virtual network IP, backend pool as batch pool ip. I couldn’t find proper document for this setup. please help if anyone come across this scenario or any document which explains in detail. Thanks,Sathish Read More
IME Not Installing after Edition Upgrade Home to Education using Company Portal.
Hi,
Currently using Company Portal on BYOD student devices to enroll in Intune.
After enrolling the BYOD device into Company Portal and the device is a Home Edition the device is upgraded to Education and prompts for a reboot to apply the settings.
A reboot is done.
After the reboot the IME does not install at all on the BYOD device, now it is Education Edition.
On another note if the device is Pro/Pro Education/Education/Enterprise and enrolled via Company Portal the device gets all settings and also the IME is installed automatically, after waiting 15 + minutes.
Any ideas to get the Intune Management Extension to install after an Edition upgrade on a Windows 10 and 11 device?
Thanks.
Hi,Currently using Company Portal on BYOD student devices to enroll in Intune.After enrolling the BYOD device into Company Portal and the device is a Home Edition the device is upgraded to Education and prompts for a reboot to apply the settings.A reboot is done.After the reboot the IME does not install at all on the BYOD device, now it is Education Edition. On another note if the device is Pro/Pro Education/Education/Enterprise and enrolled via Company Portal the device gets all settings and also the IME is installed automatically, after waiting 15 + minutes.Any ideas to get the Intune Management Extension to install after an Edition upgrade on a Windows 10 and 11 device? Thanks. Read More
Bulletproof partners with Senserva to innovate security solutions for Microsoft customers
Bulletproof partnered with Senserva to develop Drift Detector, an advanced security technology that elevates our MXDR solution through automation. Read more in our blog.
Bulletproof partnered with Senserva to develop Drift Detector, an advanced security technology that elevates our MXDR solution through automation. Read more in our blog. Read More