Category: Microsoft
Category Archives: Microsoft
How do I fix a 404 error in Quick-Books?
I’m encountering a 404 error while using Quick-Books and can’t access certain features. What steps can I take to resolve this issue? Are there specific troubleshooting methods or settings I should check within Q.B to fix the 404 error? Any detailed guidance would be appreciated.
I’m encountering a 404 error while using Quick-Books and can’t access certain features. What steps can I take to resolve this issue? Are there specific troubleshooting methods or settings I should check within Q.B to fix the 404 error? Any detailed guidance would be appreciated. Read More
ms project for the web에서 작업시간 나누는 법
ms project for the web 에서 ms project 처럼 작업시간 나누는 법은? 대체기능이라도 알려주세요.
How to split task time in MS Project for the Web like in MS Project? If there are alternative functions, please let me know.
Since I am a beginner using MS Project, which one should I use in the long term, MS Project for the web or MS Project Online?
ms project for the web 에서 ms project 처럼 작업시간 나누는 법은? 대체기능이라도 알려주세요. How to split task time in MS Project for the Web like in MS Project? If there are alternative functions, please let me know. Since I am a beginner using MS Project, which one should I use in the long term, MS Project for the web or MS Project Online? Read More
Microsoft Learn Student Ambassadors Program Interview Series Episode 1
Welcome to the Microsoft Learn Student Ambassadors Program Interview Series!
In this series, we will hear and learn from current and old Microsoft Learn Student Ambassadors about their personal experiences with the Microsoft Learn Student Ambassadors Program and why they think students should join and be a part of the program and community.
Today, I will be interviewing Favour Adeshina, he is a Gold Microsoft Learn Student Ambassador from Nigeria, in the EMEA region, and a graduate of Computer Science Education, at Ekiti State University, Ado-Ekiti. And also a Full-Stack Software developer and Community Manager.
What year did you join the Program and how did you hear about the Microsoft Learn Student Ambassadors Program?
I joined the Microsoft Learn Student Ambassadors program in 2020 because a senior friend in school then told me about it and shared the benefits of the program.
What are your personal experiences and how have you benefited from the Microsoft Learn Student Ambassadors Program?
The benefits of the program are truly enormous and one benefit I love the most is the network that the program comes with. Having to collaborate with other students in the program within the country outside the country, and region is significant. This has made me build sustainable relationships that have bolstered my career growth and journey in tech.
The fact that I have the opportunity to organise upskilling events (workshops, Bootcamps), has made me pick up a lot of skills both technical and soft skills such as event planning, collaboration, public speaking, etc. Also the resources available to me as a Microsoft Learn Student Ambassador alongside the vouchers, and Azure credits. These and several others are the benefits I have gained from the program.
My experience as an ambassador has been truly amazing, I have picked up leadership skills as an ambassador and have been able to truly stand out as a Force for Good in my local community, providing technical guidance for young teenagers and youths within my environment.
So far the program has enlightened me, giving me resources to learn everything I need and massively upskill.
What advice do you have for students?
As a student joining the Microsoft Learn Student Ambassadors program, it will set you up right for your career and personal development. Such that even before you are done with school, you have an internship and other opportunities available to you. It is very important as a student you join the MLSA program and you are active in the community.
You can join the Microsoft Learn Student Ambassadors Program by visiting this website.
Microsoft Tech Community – Latest Blogs –Read More
Dynamically Updating Azure IP Ranges with PowerShell and DevOps
Introduction
Keeping your Azure IP ranges up-to-date is crucial for maintaining the security and efficiency of your cloud environment. This blog post will guide you through the process of dynamically updating your Azure IP ranges using the official Azure documentation, PowerShell scripts, and DevOps practices.
Table of Contents
Understanding Azure IP Ranges
Official Azure Documentation
Using PowerShell to Retrieve and Update IP Ranges
Automating Updates with Azure DevOps
Conclusion
1. Understanding Azure IP Ranges
Azure IP ranges are used to define the network boundaries for your services in Azure. These ranges are periodically updated by Microsoft, and it’s essential to ensure that your network configurations are aligned with these changes to avoid any disruptions.
2. Official Azure Documentation
Microsoft provides comprehensive documentation on Azure IP ranges, which includes a list of all the IP addresses used by Azure services. You can find this documentation here.
3. Using Power BI to Visualize the IP Address Changes
I wrote a small Power BI Dashboard to visualize the changes. The thinking behind it was that Network engineers could search and view the Updated IPs. Even though this did not automate their firewall processes it was a quick way to lookup an IP. You can find a copy of the below Power BI in my GitHub Repo –> RallTheory/AzureAndOffice365IPAddresses at main · WernerRall147/RallTheory (github.com)
4. Using PowerShell to Retrieve and Update IP Ranges
PowerShell is a powerful scripting tool that can help you automate the retrieval and updating of Azure IP ranges. Below is a sample script that demonstrates how to fetch the latest IP ranges and update your network configurations.
# Import necessary modules
Import-Module Az
# Define the URL for the Azure IP ranges JSON file
$ipRangesUrl = “https://www.microsoft.com/en-us/download/confirmation.aspx?id=56519”
# Download the JSON file
Invoke-WebRequest -Uri $ipRangesUrl -OutFile “AzureIPRanges.json”
# Parse the JSON file
$ipRanges = Get-Content -Path “AzureIPRanges.json” | ConvertFrom-Json
# Example: Update network security group rules with new IP ranges
$nsgName = “YourNetworkSecurityGroup”
$resourceGroupName = “YourResourceGroup”
foreach ($range in $ipRanges.values) {
New-AzNetworkSecurityRuleConfig -Name “AllowAzureIPs” `
-Description “Allow Azure IP Ranges” `
-Access Allow `
-Protocol * `
-Direction Inbound `
-Priority 100 `
-SourceAddressPrefix $range `
-SourcePortRange * `
-DestinationAddressPrefix * `
-DestinationPortRange 80 `
| Add-AzNetworkSecurityGroupSecurityRuleConfig -NetworkSecurityGroupName $nsgName -ResourceGroupName $resourceGroupName
}
# Apply the updated NSG configuration
Set-AzNetworkSecurityGroup -NetworkSecurityGroupName $nsgName -ResourceGroupName $resourceGroupName
5. Automating Updates with Azure DevOps
To fully automate the process, you can use Azure DevOps to run your PowerShell script on a schedule. Here’s a step-by-step guide to setting up a pipeline in Azure DevOps:
Create a New Pipeline: Go to your Azure DevOps project, and under Pipelines, click on “New Pipeline”.
Select the Repository: Choose the repository where your PowerShell script is stored.
Configure the Pipeline: Use the YAML editor to define your pipeline. Below is an example YAML configuration.
trigger:
– main
schedules:
– cron: “0 0 * * *” # Runs every day at midnight
displayName: Daily midnight build
branches:
include:
– main
pool:
vmImage: ‘ubuntu-latest’
steps:
– task: UseDotNet@2
inputs:
packageType: ‘sdk’
version: ‘5.x’
installationPath: $(Agent.ToolsDirectory)/dotnet
– task: PowerShell@2
inputs:
targetType: ‘filePath’
filePath: ‘$(Build.SourcesDirectory)/UpdateAzureIPRanges.ps1’
arguments: ‘-ResourceGroupName YourResourceGroup -NsgName YourNetworkSecurityGroup’
pwsh: true
Save and Run: Save your pipeline and run it to ensure everything is configured correctly.
6. Conclusion
By following these steps, you can ensure that your Azure IP ranges are always up-to-date, enhancing the security and reliability of your cloud environment. Automating this process using PowerShell and Azure DevOps not only saves time but also minimizes the risk of human error.
This article would not have been possible without the help from my colleague Alan Serzysko, Customer Support Engineer for Microsoft.
Disclaimer
The sample scripts are not supported under any Microsoft standard support program or service. The sample scripts or Power BI Dashboards are provided AS IS without warranty of any kind. Microsoft further disclaims all implied warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample scripts and documentation remains with you. In no event shall Microsoft, its authors, or anyone else involved in the creation, production, or delivery of the scripts or Power BI Dashboards be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample scripts or documentation, even if Microsoft has been advised of the possibility of such damages. This blog post was written with the help of generative AI.
Microsoft Tech Community – Latest Blogs –Read More
hey guys pls help me to resolve a very annoyng problem
this microsoft terms poping up and also when i press Fn+Esc then F11 key got repeated press automatically Read More
What Do When Getting Error code 9000 when submitting pay-roll after recent update?
I am encountering Error Code 9000 when submitting pay-roll in our system. This error stops the submission process, and I’m unable to proceed with pay-roll tasks. What could be causing this issue, and what steps can I take to resolve it?
I am encountering Error Code 9000 when submitting pay-roll in our system. This error stops the submission process, and I’m unable to proceed with pay-roll tasks. What could be causing this issue, and what steps can I take to resolve it? Read More
What to Do When Getting Quick-Books Error 1903 after new update?
I encountered Quick-Books Error 1903 while installing or updating the software. It says, “This error occurs when there is an issue with the Windows operating system.” Can you provide detailed troubleshooting steps to resolve this error?
I encountered Quick-Books Error 1903 while installing or updating the software. It says, “This error occurs when there is an issue with the Windows operating system.” Can you provide detailed troubleshooting steps to resolve this error? Read More
Copilot Outlook addin – Tracking saving recurring Appointment
Hello,
Is it possible to track a series of meetings in the Copilot add-in?
In the Dynamics App for Outlook application, there was such an option, I can open the entire series and save it to Dynamics 365. In the copilot add-on, a message appears about the inability to track the reccuring meeting. In Copilot presentations, Microsoft indicates that all Dynamics App for Outllok functionalities are (or will be) included in Copilot. Does anyone know anything more about recurring meetings in Copliot Outlook ad in?
Hello,Is it possible to track a series of meetings in the Copilot add-in? In the Dynamics App for Outlook application, there was such an option, I can open the entire series and save it to Dynamics 365. In the copilot add-on, a message appears about the inability to track the reccuring meeting. In Copilot presentations, Microsoft indicates that all Dynamics App for Outllok functionalities are (or will be) included in Copilot. Does anyone know anything more about recurring meetings in Copliot Outlook ad in? Read More
How to Resolve Quick-Books error ps107 after recent update?
I’m encountering Quick-Books error PS107, which is preventing me from updating pay-roll. The error message mentions an internal file that cannot be read. How can I fix this issue to continue processing pay-roll smoothly?
I’m encountering Quick-Books error PS107, which is preventing me from updating pay-roll. The error message mentions an internal file that cannot be read. How can I fix this issue to continue processing pay-roll smoothly? Read More
How can I resolve Quick-Books Error 40001 after latest update?
I’m encountering “Quick-Books Error 40001” when trying to update my pay-roll. Can you provide some troubleshooting steps to resolve this issue?
I’m encountering “Quick-Books Error 40001” when trying to update my pay-roll. Can you provide some troubleshooting steps to resolve this issue? Read More
“In-page search” feature in Edge 128 now opens in the sidebar. I want this feature Block
It seems that the “In-page search” feature in Edge 128 now opens in the sidebar. This sidebar can also open other websites, creating potential loopholes for filters, which is very troublesome.
Does anyone know how to prevent the sidebar from opening?
It seems that the “In-page search” feature in Edge 128 now opens in the sidebar. This sidebar can also open other websites, creating potential loopholes for filters, which is very troublesome.Does anyone know how to prevent the sidebar from opening? Read More
Azure Arc enabled SQL Server – determine your Azure SQL target with ease and confidence
Azure Arc enabled SQL Server enables you to manage, secure and govern your SQL Server estate from Azure. At the same time, it also enables you to streamline your Azure migration and modernization journey.
Azure SQL migration assessment runs continuously on a schedule (every Sunday at 11:00 PM local time as configured on the server) and helps provide
Readiness assessment: Discover, assess, and measure the Azure SQL readiness of the Arc-enabled SQL Servers. This will help identify the SQL Server workloads that are ready to migrate, identify any migration risks, and provide mitigation recommendations.
Azure SQL Size recommendations: Get best-fit recommendations, with right-sizing based on performance history and service tier recommendations.
With the release of the on-demand assessment capability, you now can trigger this assessment as required. Simply click Run assessment to trigger a new assessment request. The on-demand assessment does not interrupt any subsequent scheduled runs.
An important scenario where this would be very useful is after you have taken remedial action(s) to address any compatibility issues previously detected. If you prefer not to wait for the next schedule run of the assessment, you can trigger one right away.
Another scenario would be where no assessment has been created so far because the scheduled run has not yet been triggered. Again, you can trigger one right away.
Once the assessment completes the last assessment time is updated and the fresh assessment results are displayed:
You can now review the migration assessment result and get the latest readiness information and suggested target Azure configuration.
With this feature, when you decide that a SQL Server instance is eligible for migration to Azure, you can have the updated information readily available to make a confident choice and move forward.
Ready to transform the way you manage, secure and govern your SQL Server instances? Learn how to Arc enable your SQL Servers today and get started right away!
Microsoft Tech Community – Latest Blogs –Read More
Hyper-V Application Issues
So I have moved a client from an old HP server to a new HP Gen 11 server running Server 2022 and Hyper-V.
Everything is patched and running the newest firmware releases from HP>
In the VM running server 2022 there is an application that runs very slowly when moved to the new hardware.
We can not find the cause of the issue, but once moved back it runs fine.
A new VM was created to run the application and it was the same.
Everything else is fine and running as expected.
If anyone can suggest what the cause could be?
So I have moved a client from an old HP server to a new HP Gen 11 server running Server 2022 and Hyper-V.Everything is patched and running the newest firmware releases from HP> In the VM running server 2022 there is an application that runs very slowly when moved to the new hardware.We can not find the cause of the issue, but once moved back it runs fine.A new VM was created to run the application and it was the same. Everything else is fine and running as expected. If anyone can suggest what the cause could be? Read More
how to merge data from one table to another, student id assign
Good Morning,
how to assign query one results to query 2 student id, each record should have each value, rather assigning one to all 20k students. please advise. i tried one but it is assigned same id to all STG_Student. please
— Query 1
SELECT STATESTUDENTID
FROM DEV_SLDS.LEGACY.STUDENTIDPOOL
WHERE IDSTATUS = ‘UNASSIGNED’
AND DATEINITIALASSIGNED IS NULL
— This query resylts gives several thousands of studentid numbers that are never assigned to student.
— Query 2 this STATEIDENTIFICATIONNUMBER need to populate with query 1 each record should have one unique record from query 1
SELECT * FROM STAGE.STG_STUDENT s
SET STATEIDENTIFICATIONNUMBER = Assign from STUDENTIDPOOL.STATESTUDENTID
WHERE COMMENTS = ‘NEW ID FROM POOL REQUIRED’
and trim(FILEID) = trim(‘a0xHv000000fNWqIAM ‘)
AND STATEIDENTIFICATIONNUMBER IS NULL;
Thank you,
Asit
Good Morning, how to assign query one results to query 2 student id, each record should have each value, rather assigning one to all 20k students. please advise. i tried one but it is assigned same id to all STG_Student. please — Query 1SELECT STATESTUDENTIDFROM DEV_SLDS.LEGACY.STUDENTIDPOOLWHERE IDSTATUS = ‘UNASSIGNED’AND DATEINITIALASSIGNED IS NULL— This query resylts gives several thousands of studentid numbers that are never assigned to student.– Query 2 this STATEIDENTIFICATIONNUMBER need to populate with query 1 each record should have one unique record from query 1SELECT * FROM STAGE.STG_STUDENT sSET STATEIDENTIFICATIONNUMBER = Assign from STUDENTIDPOOL.STATESTUDENTIDWHERE COMMENTS = ‘NEW ID FROM POOL REQUIRED’and trim(FILEID) = trim(‘a0xHv000000fNWqIAM ‘)AND STATEIDENTIFICATIONNUMBER IS NULL; Thank you,Asit Read More
Windows 7 32 bit activation loss after VM reboot
Dear All,
My client whose system is still an old VMWare system (Vphere 5.5/EXSi 5.5), running windows 7 32bit VM, recently report that the windows 7 become non genuine after a scheduled reboot. What would be the cause and how to fix the issue so the windows 7 32 bit VM can resume genuine version?
Dear All, My client whose system is still an old VMWare system (Vphere 5.5/EXSi 5.5), running windows 7 32bit VM, recently report that the windows 7 become non genuine after a scheduled reboot. What would be the cause and how to fix the issue so the windows 7 32 bit VM can resume genuine version? Read More
One of check for difference
Hi Team
I am looking for ways to look for differences between Columns B and AA. B is from my main sheet and AA is from a different Dbase. In our list of over 250 addresses, we are missing 8 from the main sheet.
This is probably a one of check so it doesn’t have to be pretty
Cheers
Hi Team I am looking for ways to look for differences between Columns B and AA. B is from my main sheet and AA is from a different Dbase. In our list of over 250 addresses, we are missing 8 from the main sheet.This is probably a one of check so it doesn’t have to be prettyCheers Read More
How to remove Exchange Mgmt. Tools and re-install them?
I have a single Exchange 2016 server (CU 23) that in a hybrid configuration with M365. Something has happened and now I can’t use Exchange Mgmt. Shell on the Exchanger Server.
(“CannotConnect,PSSessionOpenFailed” is the ultimate error I see in the PS window when I launch it)
As a work-around I install the mgmt tools on another server (non-Exchange) and am successful in connecting to the exchange server with Exchange mgmt shell remotely. I would like to remove and reinstall the management tools on the server to try and resolve this issue. Presently, I’m not getting good backups so this is rather important. (my backup SW needs to connect to exchange server via PowerShell)
When I launch the CU 23 setup process the option to remove management tools is greyed out. (coincidentally so is the option to install Edge transport role which isn’t installed)
What is the best course of action to attempt to remove and reinstall the exchange management tools?
Since this is a hybrid setup I’m a bit concerned about doing anything that could break it.
Since this is a VM in Azure, I could deploy a second Exchange Server and move all the mailboxes to that server so I could at least get good backups of the mailboxes. Not ideal, but an option.
Thanks.
I have a single Exchange 2016 server (CU 23) that in a hybrid configuration with M365. Something has happened and now I can’t use Exchange Mgmt. Shell on the Exchanger Server. (“CannotConnect,PSSessionOpenFailed” is the ultimate error I see in the PS window when I launch it) As a work-around I install the mgmt tools on another server (non-Exchange) and am successful in connecting to the exchange server with Exchange mgmt shell remotely. I would like to remove and reinstall the management tools on the server to try and resolve this issue. Presently, I’m not getting good backups so this is rather important. (my backup SW needs to connect to exchange server via PowerShell) When I launch the CU 23 setup process the option to remove management tools is greyed out. (coincidentally so is the option to install Edge transport role which isn’t installed) What is the best course of action to attempt to remove and reinstall the exchange management tools? Since this is a hybrid setup I’m a bit concerned about doing anything that could break it. Since this is a VM in Azure, I could deploy a second Exchange Server and move all the mailboxes to that server so I could at least get good backups of the mailboxes. Not ideal, but an option. Thanks. Read More
Recall menu appears in start menu?
Just looked at my start menu to clean up some clutter and saw Recall (preview) on the list.
Just looked at my start menu to clean up some clutter and saw Recall (preview) on the list. Read More
Why doesn’t my Bing.com have the ‘Work’ option?
I’ve logged into my enterprise account, but the ‘Work’ option is missing. Could it be related to my Bing settings in Microsoft M365?
I’ve logged into my enterprise account, but the ‘Work’ option is missing. Could it be related to my Bing settings in Microsoft M365? Read More
Centralized and consolidated view of metrics
Hi,
how can I setup a consolidated view of the key scores of each individual admin center? E.g. 365 health, Compliance, Secure score, Vulnerability, etc…
Thanks
Hi,how can I setup a consolidated view of the key scores of each individual admin center? E.g. 365 health, Compliance, Secure score, Vulnerability, etc… Thanks Read More