Category: Microsoft
Category Archives: Microsoft
Why are Answers only showing in tenant search?
When we enable Microsoft Search Answers (Bookmarks, locations, Q&A…), they are only shown in the highest search level – Organization. Why is that?
If , for example, a users searches for an office location and search in the HR site on the Intranet, the user doesn’t get any result if he/she doesn’t move up in search hierarchy to Organization level.
This is not intuitive and in my and my colleagues opinions, make the features pretty useless.
When we enable Microsoft Search Answers (Bookmarks, locations, Q&A…), they are only shown in the highest search level – Organization. Why is that?If , for example, a users searches for an office location and search in the HR site on the Intranet, the user doesn’t get any result if he/she doesn’t move up in search hierarchy to Organization level. This is not intuitive and in my and my colleagues opinions, make the features pretty useless. Read More
Reset Entra ID User Password Playbook error “NotFound” | Microsoft Sentinel Automation
Dear all,
Has anyone ever used and activated the playbook ‘Reset-EntraIDUserPassword-EntityTrigger‘ and encountered a ‘NotFound‘ error as shown in the following image?
I want to activate this playbook as protection against the misuse of disabled Azure accounts and password brute-force attempts on Azure accounts. However, in the ‘HTTP – reset a password‘ step, there is a ‘NotFound’ error displaying the message ‘Resource ‘@’ does not exist or one of its queried reference-property objects are not present.
A little help and insight would be greatly appreciated.
Dear all,Has anyone ever used and activated the playbook ‘Reset-EntraIDUserPassword-EntityTrigger’ and encountered a ‘NotFound’ error as shown in the following image? I want to activate this playbook as protection against the misuse of disabled Azure accounts and password brute-force attempts on Azure accounts. However, in the ‘HTTP – reset a password’ step, there is a ‘NotFound’ error displaying the message ‘Resource ‘@’ does not exist or one of its queried reference-property objects are not present.A little help and insight would be greatly appreciated. Read More
How to Fix “This PC can’t run Windows 11” Error when booting from Install USB?
Hello everyone,
I’m having trouble installing Windows 11 from a bootable USB. Every time I try, I get an error message saying, “This PC can’t run Windows 11.” This pops up instantly after skipping the license key screen.
I’m not sure what the issue is, as I believe my hardware should be compatible with Windows 11. Has anyone else encountered this problem? Any advice on how to resolve it would be greatly appreciated.
Hello everyone,I’m having trouble installing Windows 11 from a bootable USB. Every time I try, I get an error message saying, “This PC can’t run Windows 11.” This pops up instantly after skipping the license key screen. I’m not sure what the issue is, as I believe my hardware should be compatible with Windows 11. Has anyone else encountered this problem? Any advice on how to resolve it would be greatly appreciated. Read More
Is it yet possible to remove the link to a Teams Recording from a chat?
Hello!
I’ve read previous posts on how to remove the Teams Meeting Recording list from a chat and it wasn’t possible – is it now?? My user has deleted the file from their OneDrive (Delete a meeting recording in Microsoft Teams – Microsoft Support)
but now wants to also delete the system generated link to the recording from the chat.
Hello! I’ve read previous posts on how to remove the Teams Meeting Recording list from a chat and it wasn’t possible – is it now?? My user has deleted the file from their OneDrive (Delete a meeting recording in Microsoft Teams – Microsoft Support) but now wants to also delete the system generated link to the recording from the chat. Read More
login failed for user sa sql server 2022 on windows server 2022
i got the login failed error for user sa, but not always
so I went to server properties – security – server authentication
change to windows authentication mode
and change again to sql server and windows authentication mode, and restart sql server. this happened when i upgraded to sql 2022,
I have Service Pack 13 installed, can anyone help?
i got the login failed error for user sa, but not alwaysso I went to server properties – security – server authenticationchange to windows authentication modeand change again to sql server and windows authentication mode, and restart sql server. this happened when i upgraded to sql 2022,I have Service Pack 13 installed, can anyone help? Read More
How to create Windows 11 Installation media?
Hey there, tech enthusiasts!
I hope you’re all doing well. I really need some guidance for creating a Windows 11 installation media. I’m planning to install Windows 11 on my PC, but I’m not entirely sure about the steps involved in creating the installation media.
Could someone provide me with a step-by-step guide on how to create the Windows 11 installation media with the USB drive? Additionally, if there are any specific requirements or things I should be aware of before starting the process, please let me know.
Thank you in advance for your help!
Hey there, tech enthusiasts! I hope you’re all doing well. I really need some guidance for creating a Windows 11 installation media. I’m planning to install Windows 11 on my PC, but I’m not entirely sure about the steps involved in creating the installation media. Could someone provide me with a step-by-step guide on how to create the Windows 11 installation media with the USB drive? Additionally, if there are any specific requirements or things I should be aware of before starting the process, please let me know. Thank you in advance for your help! Read More
Creating a form and/or power app timesheet
I have a design question, more so than coding:
I am trying to think of a way to create a timesheet in SharePoint lists that runs concurrently with someone in the field, while they are working, to capture their work hours with the following aspects: (I think these are essentially list column headers?)
Yes/no buttons for various thingsStart time as a “driving time” button (not as a time input) that generates a timestamp based on local time zone.A “non-driving time” start and stop button + time stamp for bothA “non-work time” start and stop button + time stamp for bothA “finish shift” button that ends that rowA “new shift” button that starts a new row using the persons name (or their login)
I have started to build some lists which do kind of work, but I am not sure how to get the time stamp and new rows to generate?
I have a design question, more so than coding:I am trying to think of a way to create a timesheet in SharePoint lists that runs concurrently with someone in the field, while they are working, to capture their work hours with the following aspects: (I think these are essentially list column headers?)Yes/no buttons for various thingsStart time as a “driving time” button (not as a time input) that generates a timestamp based on local time zone.A “non-driving time” start and stop button + time stamp for bothA “non-work time” start and stop button + time stamp for bothA “finish shift” button that ends that rowA “new shift” button that starts a new row using the persons name (or their login)I have started to build some lists which do kind of work, but I am not sure how to get the time stamp and new rows to generate? Read More
Interaction
When you go to the interaction section, nothing appears as it seems to be loading, I changed the browser and refreshed the page, but the problem still persists
When you go to the interaction section, nothing appears as it seems to be loading, I changed the browser and refreshed the page, but the problem still persists Read More
Possible to save Facebook videos on my computer?
I came across a few nice Facebook videos and they are all public available (no copyright issue). I want to save those facebook videos for offline watching but the download option is not there. I’ve tried a couple of online tools, but none of them seem to work properly. Can someone guide me on the best way to save or download videos from Facebook?
Any tips or reliable tools you recommend would be greatly appreciated.
Best regards,
Philips
I came across a few nice Facebook videos and they are all public available (no copyright issue). I want to save those facebook videos for offline watching but the download option is not there. I’ve tried a couple of online tools, but none of them seem to work properly. Can someone guide me on the best way to save or download videos from Facebook? Any tips or reliable tools you recommend would be greatly appreciated. Best regards,Philips Read More
Join us in July for Securing AI Apps on Azure!
Join us in July for a series of free live-streams sharing best practices for securing your AI apps on Azure. You’ll learn about managed identity (keyless authentication), user sign-in with Microsoft Entra (for both internal and public-facing apps), data access control for RAG apps, and deployment of a RAG app to a fully private network.
Check out the session details below, or register for the entire series now. And don’t worry, if you miss a session, you can catch up on the YouTube recording after.
Using Keyless Auth with Azure AI Services
July 2nd, 2024
5:00 PM – 6:00 PM (UTC)
Ready to go keyless and never worry about compromised keys again? All the Azure AI services support keyless authentication using role-based access control, making it possible for you to authenticate to the services with either your logged in local user identity or your deployed app’s managed identity. We’ll show you how to use keyless authentication with Azure OpenAI, demonstrating how to set up the access controls in the Portal, with the Azure CLI, or with infrastructure-as-code (Bicep). Then we’ll connect to that Azure OpenAI service in our application code, using both the OpenAI SDK and the popular Langchain SDK. Our examples will be in Python, but you can use keyless auth with most modern OpenAI packages. Join us to go keyless today! Part of our Reactor series on Securing AI Apps on Azure!
Add User Login to AI Apps using Built-in Auth
July 8, 2024
5:00 PM – 6:00 PM (UTC)
Building an AI app on Azure and want to know the easiest way to let users sign-in? We’ll show you how to setup built-in authentication on Azure App Service and Azure Container Apps. With built-in auth, employees can sign-in to either a workforce tenant or, thanks to Entra External ID, consumers can sign-in with a one-time passcode, username/password, or Google/Facebook login. Then your Azure app can display user details like their name, with minimal code changes. We’ll demonstrate how to setup built-in auth to your apps using either the Graph SDK and the newly released Graph Bicep provider, and provide links to samples with full code provided.
Add User Login to AI Apps using MSAL SDK
July 9, 2024
7:00 PM – 8:00 PM (UTC)
Need a user sign-in feature for your AI app? We’ll show you how to setup an OAuth2 OIDC flow in Python using the the MSAL SDK with the open source identity package. You can use this approach to either enable employees to sign-in to a workforce tenant or, thanks to Entra External ID, let customers sign-in with a one-time passcode, username/password, or Google/Facebook login. Then your app can use user details from the Graph SDK, like their name and email. We’ll also demonstrate how to automate the creation of Microsoft Entra applications using the Graph SDK.
Handling User Auth for a SPA App on Azure
July 10, 2024
7:00 PM – 8:00 PM (UTC)
Many modern web applications use a SPA architecture: a single-page web app for the frontend and an API for the backend. In this talk, we’ll discover how you can add user authentication to a SPA app using Microsoft Entra, using the MSAL.JS SDK on the frontend and the MSAL Python SDK on the backend. Learn how to set up Entra applications correctly, one for the client and one for the server, and how to use the on-behalf-of-flow on the server for handling tokens sent from the client. Our example application will be an AI RAG application with a React frontend and Python backend, but you can apply the same principles to any SPA applications that need user authentication.
Data Access Control for AI RAG Apps on Azure
July 17, 2024
7:00 PM – 8:00 PM (UTC)
If you’re trying to get an LLM to accurately answer questions about your own documents, you need RAG: Retrieval Augmented Generation. With a RAG approach, the app first searches a knowledge base for relevant matches to a user’s query, then sends the results to the LLM along with the original question. What if you have documents that should only be accessed by a subset of your users, like a group or a single user? Then you need data access controls to ensure that document visibility is respected during the RAG flow. In this session, we’ll show an approach using Azure AI Search with data access controls to only search the documents that can be seen by the logged in user. We’ll also demonstrate a feature for user-uploaded documents that uses data access controls along with Azure Data Lake Storage Gen2.
Deploying an AI App to a Private Network on Azure
July 25, 2024
11:00 PM – 12:00 AM (UTC)
To ensure that your AI app can only be accessed within your enterprise network, you should deploy it to an Azure virtual network with private endpoints for each Azure service used. In this session, we’ll show how to deploy an AI RAG application to a virtual network that includes App Service, AI Search, OpenAI, Document Intelligence, and Blob storage, and we’ll do it entirely with infrastructure-as-code (Bicep) so that you can do the same deployment. Then we’ll log in to the virtual network using Azure Bastion with a virtual machine to demonstrate that we can access the RAG app from inside the network, and only inside the network.
Microsoft Tech Community – Latest Blogs –Read More
Try out SLMs with Ollama in GitHub Codespaces
If you haven’t tried it already, Ollama is a great tool built on top of llama.cpp that makes it easier to run small language models (SLMs) like Phi-3 and Llama3-8B on your own machine, even if your personal computer has no GPU or has an ARM chip. Ollama provides both a command-line interface to chat with the language model, as well as an OpenAI-compatible chat completion endpoint.
What if your personal computer can’t run Ollama for some reason, like if you’re using a ChromeBook or iPad without the ability to install? GitHub Codespaces to the rescue! Codespaces is a way to open any GitHub repository in the browser, inside a web-based VS Code running a containerized development environment, all customizable via a devcontainer.json file.
We can add Ollama to the Codespace for a repository by adding this community-created feature in devcontainer.json:
“features”: {
“ghcr.io/prulloac/devcontainer-features/ollama:1”: {}
},
Once we open a repository with that feature added, we can open the terminal of the Codespace in the browser and run a model from the Ollama models catalog:
We can also call that Ollama server programmatically, either via its standard endpoint or via its OpenAI-compatible endpoint using an OpenAI SDK:
import openai
client = openai.OpenAI(
base_url=”http://localhost:11434/v1″,
api_key=”nokeyneeded”,
)
response = client.chat.completions.create(
model=”phi3:mini”,
messages=[
{“role”: “system”, “content”: “You are a helpful assistant.”},
{“role”: “user”, “content”: “Write a haiku about a hungry cat”},
],
)
print(response.choices[0].message.content)
Ollama Python Playground
To make it easy for you to get started using Ollama with Python, open the Codespace for this repository:
https://github.com/pamelafox/ollama-python-playground/
That repo includes the Ollama feature, OpenAI SDK, a notebook with demonstrations of few-shot and RAG, and a Python script for an interactive chat. It’s designed to be a helpful resource for teachers and students who want a quick and easy way to get started with small language models.
Ollama C# Playground
If you want to use Ollama from .NET instead, open this C# playground in Codespaces:
https://github.com/elbruno/Ollama-CSharp-Playground
That repo also includes sample code for common tasks with the SLMs. Bruno put together a video walking through it as well:
Phi-3 CookBook
We’ve also added the Ollama feature to the Phi-3Cookbook repository:
https://github.com/microsoft/Phi-3CookBook
If you open that repo in a GitHub Codespace, then you can use Ollama while reading through the guides. Of course, there is a limit to what you can do in a Codespace, due to the lack of a GPU and general resource constraints. Ollama does a great job optimizing for those scenarios, but that cookbook also contains Jupyter notebooks that use the transformers package, which is not optimized for the non-GPU case. When I tried to run the Phi-3 inference notebook, it took my Codespace a full 1.5 hours to complete the inference. :face_screaming_in_fear:
We hope that this lowers the barrier even more for everyone interested in trying out small language models! Let us know in the comments if you’ve added Ollama support to any repositories or if you have other ways that you like to experiment with small language models.
Microsoft Tech Community – Latest Blogs –Read More
Dotnet core Oracle 23c SSL connection not working on Linux environment and works on Windows
Our data direct ADO.NET oracle driver is having an issue with SSL connection on Linux platform and the same connection is working on windows environment with Oracle23c server.
Are there any known limitations with dotnet core on linux environment with SSL/TLS connections.
Trace :
InnerException: System.IO.IOException
Message: Unable to read data from the transport connection: Connection reset by peer.
Source: System.Net.Sockets
Stack Trace
at System.Net.Sockets.NetworkStream.Read(Span`1 buffer)
at System.Net.Security.SslStream.EnsureFullTlsFrameAsync[TIOAdapter](TIOAdapter adapter)
at System.Net.Security.SslStream.ReadAsyncInternal[TIOAdapter](TIOAdapter adapter, Memory`1 buffer)
at System.Net.Security.SslStream.Read(Byte[] buffer, Int32 offset, Int32 count)
The same application works on Windows environment.
Our data direct ADO.NET oracle driver is having an issue with SSL connection on Linux platform and the same connection is working on windows environment with Oracle23c server. Are there any known limitations with dotnet core on linux environment with SSL/TLS connections. Trace : InnerException: System.IO.IOExceptionMessage: Unable to read data from the transport connection: Connection reset by peer.Source: System.Net.SocketsStack Traceat System.Net.Sockets.NetworkStream.Read(Span`1 buffer)at System.Net.Security.SslStream.EnsureFullTlsFrameAsync[TIOAdapter](TIOAdapter adapter)at System.Net.Security.SslStream.ReadAsyncInternal[TIOAdapter](TIOAdapter adapter, Memory`1 buffer)at System.Net.Security.SslStream.Read(Byte[] buffer, Int32 offset, Int32 count) The same application works on Windows environment. Read More
Azure OpenAI Quota
Hi all,
I have a question about the Azure OpenAI deployment quota and hope someone can help me understand.
I understand the quota is shared among deployments in the same region (Japan East) and the same subscription.
If we deploy instances of GPT-4 (Japan East) in separate subscriptions called Tech-dev and Support-dev, would the quota still be shared?
The subscriptions are separate and used by different groups, but they are owned by the same company.
I was wondering if the quotas are shared only when deployments are under the same subscription, or if the quota is shared as long as the subscriptions are owned by the same company.
have an awesome day,
Thank you,
Hi all, I have a question about the Azure OpenAI deployment quota and hope someone can help me understand. I understand the quota is shared among deployments in the same region (Japan East) and the same subscription. If we deploy instances of GPT-4 (Japan East) in separate subscriptions called Tech-dev and Support-dev, would the quota still be shared?The subscriptions are separate and used by different groups, but they are owned by the same company. I was wondering if the quotas are shared only when deployments are under the same subscription, or if the quota is shared as long as the subscriptions are owned by the same company. have an awesome day, Thank you, Read More
Power query: Custom Columns
Hi,
I am trying to use power query to create custom columns with formula.
The file I am using has six power queries.
I have appended the six queries and removed columns and duplicates.
But I want to add custom columns with formula like below image.
There are two formulas for each column (item# and qty#):
item columns:
=IF(IFERROR(SUMIF(INDIRECT(“‘” & J$2 & “‘!J:J”), $E13, INDIRECT(“‘” & J$2 & “‘!R:R”)), 0) = 0,””,IFERROR(SUMIF(INDIRECT(“‘” & J$2 & “‘!J:J”), E13, INDIRECT(“‘” & J$2 & “‘!R:R”)), “Not Found”))
qty coulmns:
=IF(J13=””,””,IFERROR(SUMIF(INDIRECT(“‘” & J$2 & “‘!J:J”), $E13, INDIRECT(“‘” & J$2 & “‘!Q:Q”)), “Not Found”))
The reason of these formula is that user can type sheet name.
Then it will show the corresponding code and supplier and show the item and qty based on the sheet name.
Is this doable in power query? or is it better to do script to accomplish this?
Thank you all in advance.
Hi, I am trying to use power query to create custom columns with formula. The file I am using has six power queries. I have appended the six queries and removed columns and duplicates.But I want to add custom columns with formula like below image. There are two formulas for each column (item# and qty#):item columns: =IF(IFERROR(SUMIF(INDIRECT(“‘” & J$2 & “‘!J:J”), $E13, INDIRECT(“‘” & J$2 & “‘!R:R”)), 0) = 0,””,IFERROR(SUMIF(INDIRECT(“‘” & J$2 & “‘!J:J”), E13, INDIRECT(“‘” & J$2 & “‘!R:R”)), “Not Found”)) qty coulmns: =IF(J13=””,””,IFERROR(SUMIF(INDIRECT(“‘” & J$2 & “‘!J:J”), $E13, INDIRECT(“‘” & J$2 & “‘!Q:Q”)), “Not Found”)) The reason of these formula is that user can type sheet name.Then it will show the corresponding code and supplier and show the item and qty based on the sheet name. Is this doable in power query? or is it better to do script to accomplish this? Thank you all in advance. Read More
Custom TTS Avatar pricing
Hi,
We are looking to generate a custom TTS avatar to use on Azure. Apart from the upfront avatar generation and batch synthesis fees, are there any other costs involved? What is the endpoint hosting fee?
https://azure.microsoft.com/en-us/pricing/details/cognitive-services/speech-services/
Thank You
Hi, We are looking to generate a custom TTS avatar to use on Azure. Apart from the upfront avatar generation and batch synthesis fees, are there any other costs involved? What is the endpoint hosting fee?https://azure.microsoft.com/en-us/pricing/details/cognitive-services/speech-services/ Thank You Read More
WAC and S2D: Disks are not populating
Unable to get WAC to show Disks for a Windows server 2022 DC Failover Cluster with S2D
WAC is throwing error: “RemoteException: The variable ‘$clusterDisk’ cannot be retrieved because it has not been set.”
Ran a: Test-Cluster -Node <node1,node2,node3> -Include “Storage Spaces Direct”, “Inventory”, “Network”, “System Configuration”
S2D shows all green.
I’m at a loss. Thanks for any help you can give
Unable to get WAC to show Disks for a Windows server 2022 DC Failover Cluster with S2D WAC is throwing error: “RemoteException: The variable ‘$clusterDisk’ cannot be retrieved because it has not been set.”Ran a: Test-Cluster -Node <node1,node2,node3> -Include “Storage Spaces Direct”, “Inventory”, “Network”, “System Configuration”S2D shows all green. I’m at a loss. Thanks for any help you can give Read More
Scroll between two different excel spreadsheets
Usually (on my personal macbook laptop) if I have two excel spreadsheets open, I can scroll between either as long as my mouse is on the spreadsheet.
At work, on my Asus computer, if I have two excel spreadsheets, I have to click on that spreadsheet to scroll.
For example, say I am doing some data entry and using info from one spreadsheet to put into another – I want to be able to type in one spreadsheet, while scrolling up and down the other to find the information I need. I do not want to have to click on one spreadsheet to scroll, only to then click back into the other to type, if that makes sense.
Is there a way that I can change/fix this?
(Note, both excels are on the desktop, not for web)
Usually (on my personal macbook laptop) if I have two excel spreadsheets open, I can scroll between either as long as my mouse is on the spreadsheet. At work, on my Asus computer, if I have two excel spreadsheets, I have to click on that spreadsheet to scroll. For example, say I am doing some data entry and using info from one spreadsheet to put into another – I want to be able to type in one spreadsheet, while scrolling up and down the other to find the information I need. I do not want to have to click on one spreadsheet to scroll, only to then click back into the other to type, if that makes sense. Is there a way that I can change/fix this? (Note, both excels are on the desktop, not for web) Read More
New Tab Page Default Engine
Hello I have reccomendation to make for Microsoft Edge. Given the Google Chrome lawsuit about how Google Search collected searches users data for years. without their consent. Google had to pay 1 billion in damages. I think this is a solid argument for Microsoft Edge Private Mode to be locked only to Microsoft Bing. Whilist the normal Search Engine can still be changed. I think this is tiny overlooked security issue where people can have their privacy betrayed
Hello I have reccomendation to make for Microsoft Edge. Given the Google Chrome lawsuit about how Google Search collected searches users data for years. without their consent. Google had to pay 1 billion in damages. I think this is a solid argument for Microsoft Edge Private Mode to be locked only to Microsoft Bing. Whilist the normal Search Engine can still be changed. I think this is tiny overlooked security issue where people can have their privacy betrayed Read More
Automate running of Power Query when new file is uploaded to Sharepoint
I have a SharePoint/OneDrive folder where every week I upload an excel file containing data in a fixed format. I have made power queries to do some transformations on the excel data and output the transformed data within that excel in a separate sheet. I also need to connect the excel data (before transformation) to Power BI to display graphs.
I want something which automatically detects that a new excel file has been uploaded to SharePoint/OneDrive, run the power queries on the data in the excel, and also create a connection to Power BI and display the graphs.
I tried using Power Automate but it has a limitation that it can’t run power queries automatically on the excel file. PLEASE HELP me with a solution that can automate this process, I have been stuck for a week trying to find a way.
I have a SharePoint/OneDrive folder where every week I upload an excel file containing data in a fixed format. I have made power queries to do some transformations on the excel data and output the transformed data within that excel in a separate sheet. I also need to connect the excel data (before transformation) to Power BI to display graphs. I want something which automatically detects that a new excel file has been uploaded to SharePoint/OneDrive, run the power queries on the data in the excel, and also create a connection to Power BI and display the graphs. I tried using Power Automate but it has a limitation that it can’t run power queries automatically on the excel file. PLEASE HELP me with a solution that can automate this process, I have been stuck for a week trying to find a way. Read More