Category: Microsoft
Category Archives: Microsoft
Copy data task in pipeline gives error “InternalServerError executing request”
I am getting this error when running the pipeline either on a trigger or manually. It goes into a queued status for 3-4 minutes and then fails. Each copy task is copying data from an Azure SQL database to an Azure SQL Managed instance. The connectivity on all source and destination datasets is good and I am able to preview the data. I’ve checked the timeout settings (set to default) and the health monitor of the ADF shows online and available. Can someone please tell me why this error is occurring and what I can do about it?
I am getting this error when running the pipeline either on a trigger or manually. It goes into a queued status for 3-4 minutes and then fails. Each copy task is copying data from an Azure SQL database to an Azure SQL Managed instance. The connectivity on all source and destination datasets is good and I am able to preview the data. I’ve checked the timeout settings (set to default) and the health monitor of the ADF shows online and available. Can someone please tell me why this error is occurring and what I can do about it? Read More
Important Update: Azure Automation Update Management and Log Analytics Agent Retirement
Important Update: Azure Automation Update Management and Log Analytics Agent Retirement
Attention Azure users!
This is a critical notice regarding the retirement of two key services: Azure Automation Update Management and the Log Analytics agent.
Both will be discontinued on August 31, 2024.
To ensure uninterrupted update management for your virtual machines, migrating to Azure Update Manager is essential before the retirement date.
Why the Change?
Microsoft is streamlining its update management offerings by focusing on Azure Update Manager, a robust solution with several advantages. These include:
Simplified onboarding: Azure Update Manager leverages existing Azure features for effortless integration.Enhanced control: Granular access controls allow for precise management of update deployment.Flexible automation: Automatic patching capabilities streamline the update process.
Taking Action: Migrate to Azure Update Manager
To avoid disruptions after August 31st, migrating to Azure Update Manager is necessary. Microsoft provides a comprehensive guide to facilitate this transition:
Move from Automation Update Management to Azure Update Manager
https://learn.microsoft.com/en-us/azure/automation/update-management/overview
This guide details the migration process, ensuring a smooth transfer to the new platform.
Don’t wait! Begin the migration process today to ensure your virtual machines receive updates seamlessly after the retirement of Azure Automation Update Management and the Log Analytics agent.
Important Update: Azure Automation Update Management and Log Analytics Agent Retirement Attention Azure users!This is a critical notice regarding the retirement of two key services: Azure Automation Update Management and the Log Analytics agent.Both will be discontinued on August 31, 2024.To ensure uninterrupted update management for your virtual machines, migrating to Azure Update Manager is essential before the retirement date. Why the Change?Microsoft is streamlining its update management offerings by focusing on Azure Update Manager, a robust solution with several advantages. These include:Simplified onboarding: Azure Update Manager leverages existing Azure features for effortless integration.Enhanced control: Granular access controls allow for precise management of update deployment.Flexible automation: Automatic patching capabilities streamline the update process. Taking Action: Migrate to Azure Update ManagerTo avoid disruptions after August 31st, migrating to Azure Update Manager is necessary. Microsoft provides a comprehensive guide to facilitate this transition: Move from Automation Update Management to Azure Update Managerhttps://learn.microsoft.com/en-us/azure/automation/update-management/overviewThis guide details the migration process, ensuring a smooth transfer to the new platform. Don’t wait! Begin the migration process today to ensure your virtual machines receive updates seamlessly after the retirement of Azure Automation Update Management and the Log Analytics agent. Read More
RETIREMENT ANNOUCEMENT: AZ-1001: Deploy and manage containers using Azure Kubernetes Service
June 16th, 2024
ILT Retirement Announcement:
Microsoft strives to provide the best learning experience for our Microsoft Learn global community.
As we continue to explore and enhance the delivery experience of Applied Skills for our Learners, we have decided to officially retire the Applied Skills assessment for AZ-1001: Deploy and manage containers using Azure Kubernetes Service, as of June 16th, 2024.
Deploy containers by using Azure Kubernetes Service Assessment
What does this mean for ILT deliveries of AZ-1001: Deploy and manage containers using Azure Kubernetes Service?
The ILT for this course will be retired on July 31st, 2024. This will ensure any future scheduled deliveries are accommodated.
All Trainer materials and assets on the Learning Download Center (LDC) will be retired on July 31st, 2024.
If my Trainer did not take the Applied Skills assessment for this course, can they still deliver a scheduled ILT?
This will be left to the discretion of the Training Services Partner.
We highly recommend following the 1-Day ILT with no credential standard, outlined in the Title Plan, under the MCT Competencies tab, and stated below.
Teaching this type of course is at the discretion of the MCT and/or the Training Services Partner.
We strongly suggest that the MCT has relevant expertise in the technical area of the course content.
Thank you,
Training Products Team
Worldwide Learning
June 16th, 2024
ILT Retirement Announcement:
Microsoft strives to provide the best learning experience for our Microsoft Learn global community.
As we continue to explore and enhance the delivery experience of Applied Skills for our Learners, we have decided to officially retire the Applied Skills assessment for AZ-1001: Deploy and manage containers using Azure Kubernetes Service, as of June 16th, 2024.
Deploy containers by using Azure Kubernetes Service Assessment
What does this mean for ILT deliveries of AZ-1001: Deploy and manage containers using Azure Kubernetes Service?
The ILT for this course will be retired on July 31st, 2024. This will ensure any future scheduled deliveries are accommodated.
All Trainer materials and assets on the Learning Download Center (LDC) will be retired on July 31st, 2024.
If my Trainer did not take the Applied Skills assessment for this course, can they still deliver a scheduled ILT?
This will be left to the discretion of the Training Services Partner.
We highly recommend following the 1-Day ILT with no credential standard, outlined in the Title Plan, under the MCT Competencies tab, and stated below.
Teaching this type of course is at the discretion of the MCT and/or the Training Services Partner.
We strongly suggest that the MCT has relevant expertise in the technical area of the course content.
Thank you,
Training Products Team
Worldwide Learning
Combining Excel Files
I have 5 separate spreadsheet files (example below) laid out like this that all need combining.
Each file contains different data but the headers in bold are the same.
I tried to combine these using power query but came across 2 main issues and didnt get very far:
1. I have no option to select ‘folder’ as a data source (all the 5 spreadsheets are kept in 1 folder)
2. All the examples I could find are using data spread across columns, not in rows like mine. I have tried transposing my data but it needs to be kept in these rows.
Can anybody please advise me the best solution here?
(I am using a mac and will receive new data every month)
I have 5 separate spreadsheet files (example below) laid out like this that all need combining.Each file contains different data but the headers in bold are the same. I tried to combine these using power query but came across 2 main issues and didnt get very far:1. I have no option to select ‘folder’ as a data source (all the 5 spreadsheets are kept in 1 folder) 2. All the examples I could find are using data spread across columns, not in rows like mine. I have tried transposing my data but it needs to be kept in these rows. Can anybody please advise me the best solution here? (I am using a mac and will receive new data every month) Read More
generate a list of instances
Hello. Please see this example of what I’m trying to do. I don’t want to have to come manually filter my table every time. I want a formula that will generate a list of all case numbers that have a severity C type Dog. My actual table is enormous, and this list will actually be on a different sheet. Thanks so much!
Hello. Please see this example of what I’m trying to do. I don’t want to have to come manually filter my table every time. I want a formula that will generate a list of all case numbers that have a severity C type Dog. My actual table is enormous, and this list will actually be on a different sheet. Thanks so much! Read More
MS List no space for unique value
I made this List over a year ago and have been using it since with no issues. Then when I entered a new item this week, the columns where I can enter unique values as an option is gone and I can’t enter values anymore. Here are the things I did to troubleshoot:
Check Column Settings – Can add values manually is selected Check List Settings – In the column where unique value is enabled – Allow ‘fill-in’ choices is selected Tried adding a new Choice column with Can add values manually as an option – still not showing a space to enter unique value
Does anyone know what is happening and/or has a solution?
I made this List over a year ago and have been using it since with no issues. Then when I entered a new item this week, the columns where I can enter unique values as an option is gone and I can’t enter values anymore. Here are the things I did to troubleshoot:Check Column Settings – Can add values manually is selected Check List Settings – In the column where unique value is enabled – Allow ‘fill-in’ choices is selected Tried adding a new Choice column with Can add values manually as an option – still not showing a space to enter unique valueDoes anyone know what is happening and/or has a solution? Read More
Help! – Excel formatting shifts columns after filtering
Hello,
I have a gannt chart in Excel that displays 6 weeks of data. I currently have 30,000 rows of data to filter through based on different departments. I am getting a weird visual bug now after filtering where my columns appear to have shifted, yet the formulas and formatting are all consistent. Clearing the filters then returned the formatting back to normal.
Hello, I have a gannt chart in Excel that displays 6 weeks of data. I currently have 30,000 rows of data to filter through based on different departments. I am getting a weird visual bug now after filtering where my columns appear to have shifted, yet the formulas and formatting are all consistent. Clearing the filters then returned the formatting back to normal. Read More
SharePoint Online – How can I add managed properties to search results?
Dear Ladies and Gentlemen,
How can I add managed properties to search results in SharePoint Online?
I have some crawled properties matched with manged properties and also with refinable properties like RefinableString01.
I have also created custom search result page.
I have also updated the CustomString.js file like that:
But how ca I add these properties to the results of the search. So that these values will be displayed with the information about documents like title and URL address?
In the SharePoint Server it was possible to do.
Thank you
Ladislav Stupak
Dear Ladies and Gentlemen, How can I add managed properties to search results in SharePoint Online? I have some crawled properties matched with manged properties and also with refinable properties like RefinableString01. I have also created custom search result page. I have also updated the CustomString.js file like that: // Add your custom localized strings and then include these string dictionaries in your display templates using the $includeLanguageScript function $registerResourceDictionary(“en-us”, { “sampleCustomStringId”: “Sample custom string”, “rf_RefinementTitle_ManagedPropertyName”: “Sample Refinement Title for ManagedPropertyName”,”rf_RefinementTitle_RefinableString01″: “Document ID”,”rf_RefinementTitle_RefinableString02″: “Document ID URL”,”rf_RefinementTitle_RefinableString03″: “Project Name” }); But how ca I add these properties to the results of the search. So that these values will be displayed with the information about documents like title and URL address? In the SharePoint Server it was possible to do. Thank youLadislav Stupak Read More
Public Preview: Customer Managed Planned Failover for Azure Storage
Azure Storage is excited to announce customer managed Planned Failover for Azure Storage is now available in public preview.
Over the past few years Azure Storage has offered customer managed (unplanned) failover as a disaster recovery solution for geo-redundant storage accounts. This has enabled our users to meet their business requirements for disaster recovery testing and compliance. Planned failover now provides the same benefits while introducing additional benefits to our storage users.
Planned Failover provides the ability to swap your geo primary and secondary region while the storage service endpoints are still healthy. As a result, a user can now failover their storage account while keeping geo-redundancy and with no data loss or additional cost. Users will no longer need to reconfigure geo-redundant storage (GRS) after their planned failover operation which will save them both time and cost. Once the planned failover operation is completed all new writes will be made to your original secondary region, which will now be your primary region.
After the planned failover is complete, the original primary region becomes the new secondary and the original secondary region becomes the new primary.
There are multiple scenarios where Planned Failover can be utilized including:
Planned disaster recovery testing drills to validate business continuity and disaster recovery.
Recovering from a partial outage that occurs in the primary region where storage is not impacted. For example, if your storage service endpoints are healthy in both regions, but another Microsoft or 3rd party service is facing an outage in the primary region you can failover your storage services. In this scenario, once you failover the storage account and all other services your workloads can continue to work.
A proactive solution in preparation of large-scale disasters that may impact a region. To prepare for a disaster such as a hurricane, users can leverage Planned Failover to failover to their secondary region then failback once things are resolved.
Planned failover supports Blob, ADLS Gen2, Table, File and Queue data.
Key differences between our customer managed (unplanned) failover and planned failover are highlighted below:
Unplanned Failover
Planned Failover
After an unplanned failover is completed the storage account is converted to Locally Redundant Storage (LRS) and the secondary region becomes the new primary region.
After a planned failover is completed the storage account remains Geo Redundant Storage (GRS). The secondary region becomes the new primary region, and the primary region becomes the new secondary region.
Once an unplanned failover is initiated the operation begins immediately. Writes that were pending replication to the secondary region (made after the Last Sync Time) will potentially be lost. Users can utilize their Last Sync Time to determine the recovery point of their storage account.
Once a planned failover is initiated the first step is replicating pending writes (writes made after the Last Sync Time) to the secondary region. As a result, the Last Sync Time is caught up before the and there should be no data loss.
Primary use case: a storage related outage in the primary region.
Primary use case: to test the Failover workflow or a non-storage related outage in the primary region.
An unplanned failover can be used when the primary storage endpoints are unavailable (there is a storage related outage on the primary region).
A planned failover works while the primary and secondary storage endpoints are available.
Regions Planned Failover currently supports
Southeast Asia
East Asia
West Europe
France Central
East US 2
Central US
UK South
Australia East
Switzerland North
Switzerland West
India Central
India West
To learn more about Planned Failover and to track the expansion of the preview into additional regions see, How customer managed planned failover works
Getting started
Getting started is simple, to learn more about the step-by-step process to initiate a planned failover review, Initiate account failover
The Azure Portal user experience for Planned Failover.
Feedback
If you have questions or feedback, do not hesitate to reach out at storagefailover@service.microsoft.com
Microsoft Tech Community – Latest Blogs –Read More
Sales & Pre-sales Enablement for Partners OnDemand webinars
Gain insights on how to go to market faster and engage customers more effectively with this on-demand webinar! You will learn the benefits of combining Through Partner Marketing resources with Generative AI tools like Microsoft copilot for your marketing activities. The webinar provides deeper insight into marketing and AI trends, allowing you to deliver faster end-to-end campaigns with customized content for customers to accelerate sales pipeline.
Whether you are new to sales or want to dive deeper into a specific Microsoft solution area, there are training options that fit your knowledge level, role, and, most importantly, your schedule. This hub provides resources to build a flexible learning journey across the depth and breadth of our partner sales and pre-sales training programs. Register now to access on-demand content straight away and enroll for new events as they become available.
On-Demand Training:
To simplify discoverability of on-demand content, we have centralized on-demand videos in the Partner Sales Enablement Hub.
FY24 Solution Play Sales Bootcamp
Day 1 – Azure
Day 2 – Business Applications
Day 3 – Modern Work & Security
Microsoft Low Code Sales Bootcamp
Day 1 – Low Code Solution Play
Day 2 – Selling the Full Value of the Platform
Day 3 – Sales Best Practices and Resources
Microsoft Copilot Partner Bootcamp
Day 1 – Azure
Day 2 – Business Applications
Day 3 – Modern Work & Security
SMB Sales Bootcamp
Day 1 – Azure
Day 2 – Business Applications
Day 3 – Modern Work & Security
Microsoft Copilot Partner Bootcamp
Day 1 – Business Applications
Day 2 – Modern Work & Security
Day 3 – Azure & GitHub
Microsoft Copilot for Security Sales Training
60-minute Virtual session led by Microsoft Security leaders to understand the value propositions that Microsoft Copilot for Security brings to customers.
Boost Your Marketing with Generative AI and Microsoft Through Partner Marketing Webinar
This on-demand webinar shows you how to accelerate your go-to-market campaign strategy by incorporating AI tools like Microsoft Copilot.
Microsoft Cloud Executive Enablement Series
Series 1: Core Concepts
Series 2: Solutions
Series 3: AI and Copilot (coming soon)
Series 4: Industry (coming soon)
Partner Sales Acceleration Program (PSAP)
Azure Apps & Infrastructure
Azure Data & AI
Azure SMB
Business Applications
Business Applications SMB
Modern Work
Modern Work & Security SMB
Security, Compliance, & Identity
Microsoft FY24 Solution Play Enablement for Sales & Pre-Sales
14 Mainstream & SMB Solution Plays
Sales & Pre-Sales tracks available
Knowledge checks
FY23 Bootcamps
Business Applications Sales Bootcamp
Security Sales Bootcamp
Modern Work Sales Bootcamp
Azure Sales Bootcamp
Do More with less Sales Bootcamp
Sales Acceleration Bootcamp
REGISTER TODAY!
Microsoft Tech Community – Latest Blogs –Read More
Solved Windows 11 Explorer bug
My explorer sometimes looks like it does in the picture. How can I fix this?
My explorer sometimes looks like it does in the picture. How can I fix this? Read More
Cash Flow Projections formula
My Cash Flow Projection sheet is displaying inaccuracies (i.e., positive Red figures, #REF!, etc.), so how to change my sheet to avoid these challenges?
My Cash Flow Projection sheet is displaying inaccuracies (i.e., positive Red figures, #REF!, etc.), so how to change my sheet to avoid these challenges? Read More
Formula Bar behind ribbon in Excel for web
For several weeks, on different computers and various sized monitors, I have been unable to access the formula bar when the ribbon is Always showing or Adjusting automatically, whether that ribbon is classic or single line.
On the attached screen captures, you see that the formula bar is checked in the View Menu. The first image you don’t see the formula bar at all, but on the second image you can see the bottom of the formula bar if it is adjusted to be 2 or more lines tall.
Any suggestions?
For several weeks, on different computers and various sized monitors, I have been unable to access the formula bar when the ribbon is Always showing or Adjusting automatically, whether that ribbon is classic or single line. On the attached screen captures, you see that the formula bar is checked in the View Menu. The first image you don’t see the formula bar at all, but on the second image you can see the bottom of the formula bar if it is adjusted to be 2 or more lines tall. Any suggestions? Read More
App password for service account when using Security Defaults
We are using M365 Business Standard licenses and have security defaults enabled. We need to have a service account setup to allow devices (printers, scanners, etc…) to send mail outside our tenant. I cannot find a way to setup an app password or exclude this account from MFA since we can’t use conditional access. Is there a way to do this without disabling security defaults? Hoping I’m missing something here.
Thanks!
We are using M365 Business Standard licenses and have security defaults enabled. We need to have a service account setup to allow devices (printers, scanners, etc…) to send mail outside our tenant. I cannot find a way to setup an app password or exclude this account from MFA since we can’t use conditional access. Is there a way to do this without disabling security defaults? Hoping I’m missing something here. Thanks! Read More
How to change a device name like mouse or keyboard in Settings?
Hi everyone, can anyone tell me how to change the device name? Thanks
Hi everyone, can anyone tell me how to change the device name? Thanks Read More
iPhone only showing like 2 days of email…..
Anyone come across the issue where you are only seeing two day’s worth of emails in the Oulook Mobile App.
Anyone come across the issue where you are only seeing two day’s worth of emails in the Oulook Mobile App. Read More
Ctrl C or V not working constantly with Grid View in SharePoint List
Recently – I’m no longer use Copy&Paste short cuts …on SharePoint List while in Grid View editing
I experience this randomly, on many Lists and web browsers
I have noticed this since introducing new features, such as opening the List Webview App, adding a New built-in Form ….etc.
I never had any similar issues in the past 3 years
P.S. Dont suggest switching to classic view, the switch is not working at all 🙂 !
Recently – I’m no longer use Copy&Paste short cuts …on SharePoint List while in Grid View editingI experience this randomly, on many Lists and web browsers I have noticed this since introducing new features, such as opening the List Webview App, adding a New built-in Form ….etc. I never had any similar issues in the past 3 years P.S. Dont suggest switching to classic view, the switch is not working at all 🙂 ! Read More
D365 Customer Voice – Free Trial
Hi all,
Just wondering if there is a free trial for Customer Voice that still exists?
Is it a case that I could sign up for a free trial of Sales or Customer Service Enterprise and gain access to Customer Voice for 30-days through this?
If someone could kindly let me know for clarity that would be great.
Thank you
Hi all, Just wondering if there is a free trial for Customer Voice that still exists? Is it a case that I could sign up for a free trial of Sales or Customer Service Enterprise and gain access to Customer Voice for 30-days through this? If someone could kindly let me know for clarity that would be great. Thank you Read More
Open Workspaces within the same window
I’m on macOS Sonoma 14.5.
While (trying) working with Workspaces I saw the following.
If you have many spaces (mine are 6) then having N separate windows for every WS is just garbaging your screen.
In my not humble opinion, Workspaces must reuse one window rather than open next one for each one.
Examples of suggested: Vivaldi, Opera.
Please, fix/implement this.
I’m on macOS Sonoma 14.5.While (trying) working with Workspaces I saw the following.If you have many spaces (mine are 6) then having N separate windows for every WS is just garbaging your screen.In my not humble opinion, Workspaces must reuse one window rather than open next one for each one.Examples of suggested: Vivaldi, Opera. Please, fix/implement this. Read More
Windows 11 Slowness issue after upgrading from Windows 10
Some users are complaining about slowness issue after upgrading to Windows 11
When switching tasks the response is slowSpellcheck is slowWhen you click on something it takes 10-30 second’s delaySlow when opening email, typing in excel, taking screenshot
These are some of the Dell models. Out of 35 laptops upgraded already 4 people have complained of slowness.
Model #ProcessorTPM VersionBIOS Version0Memory
Latitude 5420 2.0, 0, 1.381.34.116GBLatitude 5420 2.0, 0, 1.381.34.116GBLatitude 5440 2.0, 0, 1.591.4.532GB
Some users are complaining about slowness issue after upgrading to Windows 11 When switching tasks the response is slowSpellcheck is slowWhen you click on something it takes 10-30 second’s delaySlow when opening email, typing in excel, taking screenshot These are some of the Dell models. Out of 35 laptops upgraded already 4 people have complained of slowness. Model #ProcessorTPM VersionBIOS Version0MemoryLatitude 5420 2.0, 0, 1.381.34.116GBLatitude 5420 2.0, 0, 1.381.34.116GBLatitude 5440 2.0, 0, 1.591.4.532GB Read More
