Category: Microsoft
Category Archives: Microsoft
How to remove PIN password from login?
I was forced to set up a PIN password for login during the installation. Now, I successfully added a local administrator account to my computer and look for a way to remove PIN from login screen. How can I do that?
I was forced to set up a PIN password for login during the installation. Now, I successfully added a local administrator account to my computer and look for a way to remove PIN from login screen. How can I do that? Read More
No Font Support in Excel Power Query Editor
Hi experts,
Hope you are well!
In my Excel Power Query Editor, there is no font support.
the numbers are shown but the text is not
so anyone know about this help me !!!
Hi experts, Hope you are well! In my Excel Power Query Editor, there is no font support. the numbers are shown but the text is not so anyone know about this help me !!! Read More
Problem creating booking page
Hello,
actually we have a Problem creating a Microsoft Booking page. The User has an M365 E3 Licence and Bookings ist activated. It is a SharedMailbox.
When whe try to create a Bookings page we got this error:
Could you please help to fix it?
Thanks
Hello, actually we have a Problem creating a Microsoft Booking page. The User has an M365 E3 Licence and Bookings ist activated. It is a SharedMailbox.When whe try to create a Bookings page we got this error: Could you please help to fix it?Thanks Read More
SharePoint Sharing with External
We need to share one specific folder from our SharePoint Online setup with an external company that do not have Office365 accounts in our tenant. For the standard setup, this is simple. However, our SharePoint sharing policy currently blocks external sharing. I know how to modify this policy but I was hoping for a different suggestion or solution. Are there any methods to keep the existing tight policy enabled and simply create exceptions from within the SharePoint admin portal for a single external domain of 6 users? The single folder we need to share is new and empty so I can move it however necessary. And we currently only have a single SharePoint documents site, which is the default created automatically.
Thanks for any input or suggestions.
Ken
We need to share one specific folder from our SharePoint Online setup with an external company that do not have Office365 accounts in our tenant. For the standard setup, this is simple. However, our SharePoint sharing policy currently blocks external sharing. I know how to modify this policy but I was hoping for a different suggestion or solution. Are there any methods to keep the existing tight policy enabled and simply create exceptions from within the SharePoint admin portal for a single external domain of 6 users? The single folder we need to share is new and empty so I can move it however necessary. And we currently only have a single SharePoint documents site, which is the default created automatically. Thanks for any input or suggestions.Ken Read More
Outlook Notifications not working
I’ve been having this issue for the past few months (had been using Outlook in browser in the interim) and have only gotten around to addressing it now.
I went to Options > Message Arrival tab and it’s set up as follows,
None of the selected features occur when I receive an email and I’ve taken to wearing a headset at all times in order to hear the notification when I receive an email in my web version of Outlook.
In addition to the notifications issue, Outlook is extremely slow on opening (and has been for 12 months plus), and regulalry freezes when navigating between emails.
I have a E3 M365 license and am on the Enterprise Monthly channel, however, the current version is 2311, and we are unable to update (despite more recent versions being released).
Some of these issues existed prior to this update though so don’t think I can blame it solely on lack of update, and it’s only 5 months out of date.
I uninstalled O365 suite using scrubbing tool today and reinstalled and this hasn’t solved any of the issues.
We do have add-ons which slow Outlook down a bit (1 mandatory slows it 2/3 secs on opening) but sometimes I’m waiting a minute before being able to switch between emails, and even then, I have to leave deliberate pauses between each email otherwise it’ll freeze.
If anyone has experienced this or has any advice I’m all ears.
Thanks in advance,
Chris
I’ve been having this issue for the past few months (had been using Outlook in browser in the interim) and have only gotten around to addressing it now. I went to Options > Message Arrival tab and it’s set up as follows, None of the selected features occur when I receive an email and I’ve taken to wearing a headset at all times in order to hear the notification when I receive an email in my web version of Outlook. In addition to the notifications issue, Outlook is extremely slow on opening (and has been for 12 months plus), and regulalry freezes when navigating between emails. I have a E3 M365 license and am on the Enterprise Monthly channel, however, the current version is 2311, and we are unable to update (despite more recent versions being released). Some of these issues existed prior to this update though so don’t think I can blame it solely on lack of update, and it’s only 5 months out of date. I uninstalled O365 suite using scrubbing tool today and reinstalled and this hasn’t solved any of the issues. We do have add-ons which slow Outlook down a bit (1 mandatory slows it 2/3 secs on opening) but sometimes I’m waiting a minute before being able to switch between emails, and even then, I have to leave deliberate pauses between each email otherwise it’ll freeze. If anyone has experienced this or has any advice I’m all ears. Thanks in advance, Chris Read More
SWITCH OUT FROM INSIDER
Need help with fully switching out from Windows Insider Dev Channel, encountered issues during update. Tried to perform clean install but failed to finish with error-0xC1900101.
Do you have any suggestion to fully switch out from Insider? yo
Need help with fully switching out from Windows Insider Dev Channel, encountered issues during update. Tried to perform clean install but failed to finish with error-0xC1900101. Do you have any suggestion to fully switch out from Insider? yo Read More
Site Templates using power shell
Hi all
I hope someone could help me, i have created a site within SharePoint, This site has multiple document libraries along with folders and sub folders. also using a template that is already within SharePoint i have designed the look of the site with quick links (the link to the folders within the document libraries) and hero’s with images on the buttons.
I am wanting to use Power Shell (PnP) to copy this site and make it a template. (i understand i probably wont be able to recreate the links as on the creation of the new site the folders will have different file paths).
In the test i have already done i was able to create a template however all it did was add the document libraries (with no folders) and the design of the site was not there either.
Please see below and image of the command that was used, could you please advise what is missing.
As you can see we used the include all function but this seams to be missing the majority of the site.
Any Help would be appreciated.
Kind Regards
Hi all I hope someone could help me, i have created a site within SharePoint, This site has multiple document libraries along with folders and sub folders. also using a template that is already within SharePoint i have designed the look of the site with quick links (the link to the folders within the document libraries) and hero’s with images on the buttons. I am wanting to use Power Shell (PnP) to copy this site and make it a template. (i understand i probably wont be able to recreate the links as on the creation of the new site the folders will have different file paths). In the test i have already done i was able to create a template however all it did was add the document libraries (with no folders) and the design of the site was not there either. Please see below and image of the command that was used, could you please advise what is missing. As you can see we used the include all function but this seams to be missing the majority of the site. Any Help would be appreciated. Kind Regards Read More
install Microsoft Azure Service Fabric updates
Hi All,
What is the process for upgrading the Microsoft Azure Service Fabric installed as a prerequisite for SharePoint Workflow Manager? we are required to upgrade version 9.1.1583.9590 to 9.1.1799.9590 on a 3 node cluster, not able to find any proper documentation on this subject, can anyone help here?
Hi All,What is the process for upgrading the Microsoft Azure Service Fabric installed as a prerequisite for SharePoint Workflow Manager? we are required to upgrade version 9.1.1583.9590 to 9.1.1799.9590 on a 3 node cluster, not able to find any proper documentation on this subject, can anyone help here? Read More
Issue with Outlook Desktop Calendar
Issue with Outlook Desktop Calendar:
I’m currently experiencing an issue with Outlook desktop calendar. After scheduling an appointment with attendees, I cannot see the appointment on my calendar, but the attendees can still see it normally. How can I resolve this issue?
Canceling Booking without Attendee Assistance:
In addition, I want to be able to proactively cancel this booking from my end without having to ask the attendees to cancel it from their side. How can I do this? since I can’t see the booking calendar on my calendar anymore?
Issue with Outlook Desktop Calendar:I’m currently experiencing an issue with Outlook desktop calendar. After scheduling an appointment with attendees, I cannot see the appointment on my calendar, but the attendees can still see it normally. How can I resolve this issue?Canceling Booking without Attendee Assistance:In addition, I want to be able to proactively cancel this booking from my end without having to ask the attendees to cancel it from their side. How can I do this? since I can’t see the booking calendar on my calendar anymore? Read More
On-Premises users to Online users
Good Morning,
So bit of backstory, our company has bought two other small companies. These two smaller companies are all cloud based, which includes Teams. We were an on-prem company until three tears ago.
We migrated all our mailboxes to O365, connected users to Azure AD etc and all seemed fine. Now most of our users can’t communicate with the other companies via Teams. We did a quick search and most of our users are on-prem and those that joined after the mailbox migration are Teams only.
I’ve done some reading and it seems that we need to make some changes in our Skype for Business servers, which was decommed and we have no way to get it back.
Is there something we can do to get all our users their directory status to online?
Thank you,
David
TLDR; our company has bought other companies and having issues communicating via Teams as our users are on-premises and we no longer have the SfB servers.
Good Morning, So bit of backstory, our company has bought two other small companies. These two smaller companies are all cloud based, which includes Teams. We were an on-prem company until three tears ago.We migrated all our mailboxes to O365, connected users to Azure AD etc and all seemed fine. Now most of our users can’t communicate with the other companies via Teams. We did a quick search and most of our users are on-prem and those that joined after the mailbox migration are Teams only.I’ve done some reading and it seems that we need to make some changes in our Skype for Business servers, which was decommed and we have no way to get it back.Is there something we can do to get all our users their directory status to online? Thank you,DavidTLDR; our company has bought other companies and having issues communicating via Teams as our users are on-premises and we no longer have the SfB servers. Read More
In Project Web App: Where to find the Current Max Units of an Enterprise Resource using Rest-API?
I’m trying to find the Current Max. Units of an Enterprise Resource in the Rest-API of Project Web App. I can’t find it in the ProjectServer/EnterpriseResources(‘ID’) endpoint. Also i can’t find it in Assignments, BaseCalendar, CostRateTables etc within the EnterpriseResource. Does anyone know, where i can find it?
I’m trying to find the Current Max. Units of an Enterprise Resource in the Rest-API of Project Web App. I can’t find it in the ProjectServer/EnterpriseResources(‘ID’) endpoint. Also i can’t find it in Assignments, BaseCalendar, CostRateTables etc within the EnterpriseResource. Does anyone know, where i can find it? Read More
How to track my screen time on Windows 11?
I’m trying to find a way to track and monitor my screen time on my Windows 11 desktop. I want to know how much time I’ve spent using my computer, which apps and websites I’ve been using, and maybe even set some limits or goals for myself. The thing is, I’m not sure where to find this information or how to set it up. I’ve tried searching online and looking through my settings, but I can’t seem to find anything that does what I’m looking for. Can someone help me figure out how to track my screen time on Windows 11?
I’m trying to find a way to track and monitor my screen time on my Windows 11 desktop. I want to know how much time I’ve spent using my computer, which apps and websites I’ve been using, and maybe even set some limits or goals for myself. The thing is, I’m not sure where to find this information or how to set it up. I’ve tried searching online and looking through my settings, but I can’t seem to find anything that does what I’m looking for. Can someone help me figure out how to track my screen time on Windows 11? Read More
Power automate we want stop sending email when i file is deleted
Hi,
we usually use power automate to send an email when a file is created o modify (only properties), but we would like to stope sending them when a file is deleted, as the trigger do it.
Anyone could help me please?
Thank You in advance
Hi, we usually use power automate to send an email when a file is created o modify (only properties), but we would like to stope sending them when a file is deleted, as the trigger do it.Anyone could help me please?Thank You in advance Read More
Pivot table filters not offering text format options like Begins with
I have 3 columns of data, as set of system names, the versions they are at and who’s responsible for them. I create a pivot table counting the number of systems at each version.
I then want to filter to only see the the systems that begin with “PRD”. I select the filter next to the Systems column, Select field=Machine and Filter > By Label, but rather than the text options I expect, like Begins with, Does Not Begins with, but I only see date related filters (Before, After, Between etc).
Likewise Filter > By Value only shows number related filters (Equals, Greater than etc).
I’ve tried making sure that column of data is formatted as Text (in the data and the pivot table) – though I didn’t do this previously when it was working. I’m using Excel Version 16.84 (24041420).
Any suggestions?
I have 3 columns of data, as set of system names, the versions they are at and who’s responsible for them. I create a pivot table counting the number of systems at each version.I then want to filter to only see the the systems that begin with “PRD”. I select the filter next to the Systems column, Select field=Machine and Filter > By Label, but rather than the text options I expect, like Begins with, Does Not Begins with, but I only see date related filters (Before, After, Between etc).Likewise Filter > By Value only shows number related filters (Equals, Greater than etc). I’ve tried making sure that column of data is formatted as Text (in the data and the pivot table) – though I didn’t do this previously when it was working. I’m using Excel Version 16.84 (24041420).Any suggestions? Read More
Lesson Learned #486: Snapshot Isolation Transaction Failed Due to a Concurrent DDL Statement
Today, we worked on a service request that our customer faced the following error message: Msg 3961, Level 16, State 1, Line 4 Snapshot isolation transaction failed in database ‘DbName’ because the object accessed by the statement has been modified by a DDL statement in another concurrent transaction since the start of this transaction. It is disallowed because the metadata is not versioned. A concurrent update to metadata can lead to inconsistency if mixed with snapshot isolation.
What is Snapshot Isolation?
Snapshot isolation allows transactions to read consistent versions of the data without blocking other transactions. However, this isolation level does not version metadata changes, such as table definitions, indexes, etc. Therefore, if a snapshot isolation transaction encounters a metadata change, it can lead to inconsistencies.
Example
First, let’s enable snapshot isolation in our database.
ALTER DATABASE DbName SET ALLOW_SNAPSHOT_ISOLATION ON;
ALTER DATABASE DBName SET READ_COMMITTED_SNAPSHOT ON;
Then, let’s create a sample table.
CREATE TABLE Employees (
EmployeeID INT PRIMARY KEY,
Name NVARCHAR(50)
);
Let’s create two different transactions:
Transaction #1:
SET TRANSACTION ISOLATION LEVEL SNAPSHOT;
BEGIN TRANSACTION;
SELECT * FROM Employees;
— Transaction A remains open
Transaction #2:
BEGIN TRANSACTION;
ALTER TABLE Employees ADD Email NVARCHAR(100);
COMMIT;
When trying to access the Employees table again in Transaction #1, the mentioned error will occur. Msg 3961, Level 16, State 1, Line 4
Snapshot isolation transaction failed in database ‘DbName’ because the object accessed by the statement has been modified by a DDL statement in another concurrent transaction since the start of this transaction. It is disallowed because the metadata is not versioned. A concurrent update to metadata can lead to inconsistency if mixed with snapshot isolation.
Solution and Best Practice
To avoid this error, it is recommended to avoid performing DDL operations in transactions that use snapshot isolation. If DDL operations are unavoidable, consider using a different isolation level or designing your application to minimize concurrency between DDL operations and long-running transactions.
Microsoft Tech Community – Latest Blogs –Read More
How to Apply Easy Auth on Web App under a High-security policy environment
With increasing emphasis on security issues, enterprises are imposing significant restrictions on internal resources and operations accessible to employees. If your Azure account does not have sufficient AAD (i.e., of Microsoft Entra) permissions, you will be unable to swiftly create easy auth in a web app. This article serves as a simple guide to walk you through the process of setting up easy authentication for your web app.
Step 1: Create a Web App
You may choose any combination of region/sku/stack/OS, as it does not affect the overall process.
After this step, we will obtain a callback URL for use in the next step, with the following format:
https://<my-web-app-name>.azurewebsites.net/.auth/login/aad/callback
Here is my example.
https://easyauth-myapp.azurewebsites.net/.auth/login/aad/callback
Step 2: Create an App Registration
Input
Value
Who can use this application or access this API?
Accounts in this organizational directory only (Microsoft Non-Production only – Single tenant)
Redirect URI (optional)
Platform
Web
Redirect URI (optional)
URL
The callback URL you’ve setup in Step 1
Example: https://easyauth-myapp.azurewebsites.net/.auth/login/aad/callback
After this step, we will obtain an Application ID and a Tenant ID for use in the next step.
Meanwhile, we will obtain a issuer URL for use in the next step, with the following format:
https://sts.windows.net/<my-tenant-id>/v2.0
Step 3: Setup ID Token from App Registration
Go to Authentication page and check the “ID tokens (used for implicit and hybrid flows)” and save.
Step 4: Setup Easy Auth from Web App
Go to Authentication page, create a new authentication.
Input
Value
Identity provider
Microsoft
App registration type
Provide the details of an existing app registration
Application (client) ID
The Application (client) ID you’ve setup in Step 2
Issuer URL
The Issuer URL you’ve setup in Step 2
Allowed token audiences
It’s done!
Step 5: Try to use it.
If it’s your first time using it, you’ll see this authorization screen. Just click “Accept.”
Microsoft Tech Community – Latest Blogs –Read More
The Extremely Useful Meeting Follow Response
The Follow response is a new option for people invited to a meeting to indicate that they can’t attend but are interested in what happens. Replying with a Follow response means that the user gains access to the meeting artifacts (like the chat and recap). It also means that the allotted time is not blocked in their calendar. The feature will be most valuable to people who have heavily-used calendars.
https://office365itpros.com/2024/05/14/follow-response-meetings/
The Follow response is a new option for people invited to a meeting to indicate that they can’t attend but are interested in what happens. Replying with a Follow response means that the user gains access to the meeting artifacts (like the chat and recap). It also means that the allotted time is not blocked in their calendar. The feature will be most valuable to people who have heavily-used calendars.
https://office365itpros.com/2024/05/14/follow-response-meetings/ Read More
how to use CONCAT and WHERE statement in the same query
Hi, I need to write a query:
SELECT
TBVL.VLASC + ‘ – ‘ + .TBVL.DSVL
WHERE
TBVL.NMFI= ‘ANAR’ and TBVL.NMCA= ‘TPGE’
AS columnName
how do i write this to sql server management studio?
Thank you!
Hi, I need to write a query:SELECTTBVL.VLASC + ‘ – ‘ + .TBVL.DSVLWHERETBVL.NMFI= ‘ANAR’ and TBVL.NMCA= ‘TPGE’AS columnNamehow do i write this to sql server management studio?Thank you! Read More
How to connect Windows 11 24H2 version to HLK
Hello,
I have been using the HLK 23H2 version without any issues, but after upgrading to Windows 11 24H2 version, I am unable to connect to HLK.
As far as I know, HLK versions are updated along with Windows versions, but I couldn’t find the HLK 24H2 version.
I tried connecting with the HLK 23H2 version, but it failed.
Is there any way to resolve this issue?
Hello, I have been using the HLK 23H2 version without any issues, but after upgrading to Windows 11 24H2 version, I am unable to connect to HLK. As far as I know, HLK versions are updated along with Windows versions, but I couldn’t find the HLK 24H2 version. I tried connecting with the HLK 23H2 version, but it failed. Is there any way to resolve this issue? Read More
Vert.zoeken formule niet zichtbaar in formulebalk
Hallo deskundigen,
Ik heb een probleem met mijn formule in Excel. De formule geeft wel een waarde aan alleen in de formulebalk is de formule niet meer te zien. Ik gebruik hierbij Vert.Zoeken vanuit een ander werkblad. Dit is een voorbeeld hiervan: =a4=(VERT. ZOEKEN($a 4;’ Soll matrix september 2023′!$A$4:$FX$434; 7; ONWAAR)). Ik weet niet wat hier fout gaat.
Hallo deskundigen,Ik heb een probleem met mijn formule in Excel. De formule geeft wel een waarde aan alleen in de formulebalk is de formule niet meer te zien. Ik gebruik hierbij Vert.Zoeken vanuit een ander werkblad. Dit is een voorbeeld hiervan: =a4=(VERT. ZOEKEN($a 4;’ Soll matrix september 2023′!$A$4:$FX$434; 7; ONWAAR)). Ik weet niet wat hier fout gaat. Read More