Tag Archives: microsoft
KQL Query problem with two double quotes
Hello,
We have a Sharepoint Highlighted Contents webpart with a KQL query like this:
RefinableString110:”True”
The webpart worked fine until a couple of weeks ago, then all of a sudden it didn’t return any result. When looking at the issue, we could find a workaround. We added a double quote at the end of the search query and this fixed the issue:
RefinableString110:True”
which was quite strange.
We checked with the “Search Query Tool” and we got the expected results: the first query worked and the second query returned HTTP/1.1 500 Internal Server Error, so it’s not an issue with the Microsoft service.
We tested with all combinations of quotes, capitals, etc. The only think that worked was putting one double quote at the end of the search query.
Could you please help?
Screenshots show the issue.
Thanks.
Regards,
Hello,We have a Sharepoint Highlighted Contents webpart with a KQL query like this:RefinableString110:”True”The webpart worked fine until a couple of weeks ago, then all of a sudden it didn’t return any result. When looking at the issue, we could find a workaround. We added a double quote at the end of the search query and this fixed the issue:RefinableString110:True” which was quite strange.We checked with the “Search Query Tool” and we got the expected results: the first query worked and the second query returned HTTP/1.1 500 Internal Server Error, so it’s not an issue with the Microsoft service.We tested with all combinations of quotes, capitals, etc. The only think that worked was putting one double quote at the end of the search query.Could you please help?Screenshots show the issue.Thanks.Regards, Read More
Microsoft Defender For Endpoint API Recommendations
Good Afternoon;
We have integrated with the API Endpoint to get the recommendations, we then use the recommendation id to get a list of machine references, which works fine.
We encountered an issue where one of our recommendation id had a / in the string. For example
va-_-microsoft-_-edge_chromium-based/odbc
This isn’t the exact item, but it did have a / in it.
My question is: Is the / in there supposed to be encoded, stripped away? If we then use this id to hit the next endpoint for get a list of machine References, it will error.
Good Afternoon;We have integrated with the API Endpoint to get the recommendations, we then use the recommendation id to get a list of machine references, which works fine.We encountered an issue where one of our recommendation id had a / in the string. For exampleva-_-microsoft-_-edge_chromium-based/odbcThis isn’t the exact item, but it did have a / in it.My question is: Is the / in there supposed to be encoded, stripped away? If we then use this id to hit the next endpoint for get a list of machine References, it will error. Read More
Deploy and configure Azure Monitor Applied Skills assessment not available
Does anyone know when the Applied Skills: Deploy and Configure Azure Monitor assessment will be available again?
I’ve been trying to take it for the past few weeks, but it keeps showing the message “This assessment is currently undergoing maintenance,” as shown in the screenshot.
Does anyone know when the Applied Skills: Deploy and Configure Azure Monitor assessment will be available again? I’ve been trying to take it for the past few weeks, but it keeps showing the message “This assessment is currently undergoing maintenance,” as shown in the screenshot. Read More
Word accessibility checker stuck on “updating results”
I have a weird issue with a user and the Check Accessibility feature in Word. It’s required that they use it before they send these documents out as they go to various clients. About a month ago, it just stopped working correctly, and gets stuck on “Updating Results”
New document with text added using Word desktop app – worksExisting document from SharePoint using Word desktop app – doesn’t work. Same document works with the web version of WordSave document from SharePoint to local desk using Word desktop app – worksOpening an Word attachment in email using Word desktop app – works. Saving same attachment to OneDrive then using Word desktop app – doesn’t work.
So the problem appears to be centered around files that get opened on OneDrive/SharePoint and using the Word app. It works when it’s a local file, but the same file that is saved in SharePoint will not work. The web version will work though.
We are on the monthly enterprise channel, and currently on version 2406, build 16.017726.20206 9×64).
Any ideas?
I have a weird issue with a user and the Check Accessibility feature in Word. It’s required that they use it before they send these documents out as they go to various clients. About a month ago, it just stopped working correctly, and gets stuck on “Updating Results” New document with text added using Word desktop app – worksExisting document from SharePoint using Word desktop app – doesn’t work. Same document works with the web version of WordSave document from SharePoint to local desk using Word desktop app – worksOpening an Word attachment in email using Word desktop app – works. Saving same attachment to OneDrive then using Word desktop app – doesn’t work.So the problem appears to be centered around files that get opened on OneDrive/SharePoint and using the Word app. It works when it’s a local file, but the same file that is saved in SharePoint will not work. The web version will work though. We are on the monthly enterprise channel, and currently on version 2406, build 16.017726.20206 9×64). Any ideas? Read More
How to Migrate Files from Dropbox to OneDrive While Maintaining Folder Structure
I have a corporate Dropbox account where each folder is named after a specific deal from my database. Inside each deal folder, there are subfolders representing the different stages of the deal as it progresses through the database.
Recently, I set up a Microsoft 365 business account and recreated the same folder structure in OneDrive. This means I have the deal folders with their corresponding names, and within each deal folder, I’ve already created the stage-based subfolders.
What I want to achieve is to migrate all the files from Dropbox to their respective folders in OneDrive.
Example:
In Dropbox, I have a folder named “Company1” that contains subfolders like “Emails,” “Attachments,” and “Presentations.” Each of these subfolders contains files.
In OneDrive, I’ve already created the “Company1” folder with the same subfolders: “Emails,” “Attachments,” and “Presentations.” I need to transfer the files from Dropbox so that files from “Emails” in Dropbox go into “Emails” in OneDrive under the “Company1” folder, and so on for the other subfolders.
Request:
I’m looking for the best method to perform this migration while ensuring that the folder structure and file placement remain intact. Is there a native method within Microsoft 365 to accomplish this, or do you know of any third-party applications that can handle this type of migration efficiently? Any advice or step-by-step guidance would be greatly appreciated!
I have a corporate Dropbox account where each folder is named after a specific deal from my database. Inside each deal folder, there are subfolders representing the different stages of the deal as it progresses through the database.Recently, I set up a Microsoft 365 business account and recreated the same folder structure in OneDrive. This means I have the deal folders with their corresponding names, and within each deal folder, I’ve already created the stage-based subfolders.What I want to achieve is to migrate all the files from Dropbox to their respective folders in OneDrive.Example:In Dropbox, I have a folder named “Company1” that contains subfolders like “Emails,” “Attachments,” and “Presentations.” Each of these subfolders contains files.In OneDrive, I’ve already created the “Company1” folder with the same subfolders: “Emails,” “Attachments,” and “Presentations.” I need to transfer the files from Dropbox so that files from “Emails” in Dropbox go into “Emails” in OneDrive under the “Company1” folder, and so on for the other subfolders.Request:I’m looking for the best method to perform this migration while ensuring that the folder structure and file placement remain intact. Is there a native method within Microsoft 365 to accomplish this, or do you know of any third-party applications that can handle this type of migration efficiently? Any advice or step-by-step guidance would be greatly appreciated! Read More
Is there a „=Sheetname(1)“ in Excel for direct input into a cell (no macro or VBA)
I am looking for an Excel-function „sheetname(1)“ with name of the first sheet presented in the workspace for the construction of references. Does this function exist in Excel 365 for direct input without macro or VBA?
Rolf Heller
I am looking for an Excel-function „sheetname(1)“ with name of the first sheet presented in the workspace for the construction of references. Does this function exist in Excel 365 for direct input without macro or VBA?Rolf Heller Read More
Bookings is greyed out
Hi, we’ve noticed today that bookings is grey out, we have 6 services and all are affected, I can’t see any obvious changes as to why this might be. Any initial thoughts would be grateful, thanks
Hi, we’ve noticed today that bookings is grey out, we have 6 services and all are affected, I can’t see any obvious changes as to why this might be. Any initial thoughts would be grateful, thanks Read More
Cash amortization table
Hello,
I am trying to figure which formulate would be best to populate the chart. I am currently doing basic manual formulas for each row but can be very time consuming.
For each week I have total sales. I am trying to figure how much I can expect to collect each week. For example, the cells in yellow are indicating to me in which week to expect to collect the totals sales from week number 1, $500,000
Any suggestion greatly appreciated.
Hello, I am trying to figure which formulate would be best to populate the chart. I am currently doing basic manual formulas for each row but can be very time consuming. For each week I have total sales. I am trying to figure how much I can expect to collect each week. For example, the cells in yellow are indicating to me in which week to expect to collect the totals sales from week number 1, $500,000 Any suggestion greatly appreciated. Read More
phishing emails with only a name as the sender and no visible email address
There has been a sudden surge of spam or phishing emails flooding the main inbox, with only a name as the sender and no visible email address. Could this be due to a newly exploited vulnerability in the app or web app?
Clicking on the senders just expend a empty span and holding open the “contact” of it but once again its just the name, no address.
I have received like on of them every hour ….
On webapp from Edge :
literally says “No sender address” here, c’mon it’s an email, how is this even permitted/supported/possible ??
There has been a sudden surge of spam or phishing emails flooding the main inbox, with only a name as the sender and no visible email address. Could this be due to a newly exploited vulnerability in the app or web app? Clicking on the senders just expend a empty span and holding open the “contact” of it but once again its just the name, no address. I have received like on of them every hour …. On webapp from Edge :literally says “No sender address” here, c’mon it’s an email, how is this even permitted/supported/possible ?? Read More
Simulate api failure when using the C# sdk
Hi
I use the C# SDK to call the grap api, now the tester wants to test the app, but there is a scenario that the call to API should fail, lets say the API is not reachable or request takes a long time, I tried some proxy apps to prevent outgoing request to graph api, but I did not succussed. Can you help ?
HiI use the C# SDK to call the grap api, now the tester wants to test the app, but there is a scenario that the call to API should fail, lets say the API is not reachable or request takes a long time, I tried some proxy apps to prevent outgoing request to graph api, but I did not succussed. Can you help ? Read More
Unique identifier #
Hi,
I’m trying to create a list of unique identifier numbers that users can link to their activity line items with a their expenses along with a way that shows the user if a unique identifier number was already used to avoid duplication/errors. Does excel have the functionality to do this? If so, can you kindly explain? Thank you!
Hi, I’m trying to create a list of unique identifier numbers that users can link to their activity line items with a their expenses along with a way that shows the user if a unique identifier number was already used to avoid duplication/errors. Does excel have the functionality to do this? If so, can you kindly explain? Thank you! Read More
Troubles accessing Chat
Hi all,
Since yesterday, we discover that some people of our organisation stop randomly accessing to the chat icon. The error message says Sorry … we didn’t find this application.
Anyone got it? have you solve it?
Thanks MG
Hi all, Since yesterday, we discover that some people of our organisation stop randomly accessing to the chat icon. The error message says Sorry … we didn’t find this application. Anyone got it? have you solve it? Thanks MG Read More
Talking to your relational Database using GPT not just to one table or view, but to multiple v/t
Dear Community, What is the best solution for a chat app that can interact with a relational database, not just limited to a single table or view? Thank you!
Dear Community, What is the best solution for a chat app that can interact with a relational database, not just limited to a single table or view? Thank you! Read More
How to use a template file in VBA when it is stored online (Teams or SharePoint)?
As many companies are on the brink of migrating to Microsoft 365 and moving all files from the file server to the cloud (OneDrive/SharePoint), I need to know how I can use templates stored in Teams, from VBA.
Here is an example:
I have an Excel file in which I generate a chart, using a chart template with VBA.
This works fine as long the chart template is on a file server, but when I move it to Teams, my code can’t use the template.
so the template path is:
(xxxxxxxxxxxxxxx = company id).
When I run the procedure, I get this error message:
How can I solve this?
GrtZ, BartH_NL
As many companies are on the brink of migrating to Microsoft 365 and moving all files from the file server to the cloud (OneDrive/SharePoint), I need to know how I can use templates stored in Teams, from VBA.Here is an example:I have an Excel file in which I generate a chart, using a chart template with VBA.This works fine as long the chart template is on a file server, but when I move it to Teams, my code can’t use the template.so the template path is:https://xxxxxxxxxxxxxx.sharepoint.com/sites/msteams_a046009/Shared%20Documents/General/DRR%20Test/DRR.crtx(xxxxxxxxxxxxxxx = company id).When I run the procedure, I get this error message:How can I solve this? GrtZ, BartH_NL Read More
Creating a Rubric with Checkboxes and Auto Calculations
Hello all,
I’ve been trying to figure this out on my own, but to no avail. I would like to make a scoring rubric for faculty to use on student projects that auto-calculates. If a certain box is checked, it will assign a value and the section total will be tallied up at the end. I have the Sum function no problem. What I cannot figure out is how to get the check boxes formatted so they will create a certain value for that rubric item.
For example, if B7 is checked, that should return a value of 4. If unchecked, a value of 0. If D8 is checked, that should return a value of 2 (if unchecked, then 0).
Everything would be tallied up in H11 so the instructors do not have to manually calculate the overall score. They simply check a box for each criteria listed in 7-10 and get the sum total. (I have the SUM function inserted and working properly)
Any help on how to format the check boxes to return values is much appreciated. I’ve spent hours using tutorials and articles and am stumped! Thank you.
Hello all, I’ve been trying to figure this out on my own, but to no avail. I would like to make a scoring rubric for faculty to use on student projects that auto-calculates. If a certain box is checked, it will assign a value and the section total will be tallied up at the end. I have the Sum function no problem. What I cannot figure out is how to get the check boxes formatted so they will create a certain value for that rubric item. For example, if B7 is checked, that should return a value of 4. If unchecked, a value of 0. If D8 is checked, that should return a value of 2 (if unchecked, then 0).Everything would be tallied up in H11 so the instructors do not have to manually calculate the overall score. They simply check a box for each criteria listed in 7-10 and get the sum total. (I have the SUM function inserted and working properly) Any help on how to format the check boxes to return values is much appreciated. I’ve spent hours using tutorials and articles and am stumped! Thank you. Read More
List all DL’s in on-prem Exchange with Zero members
We are trying to clean up our 1000’s of Distribution Lists before migrating them to 365.
Could somebody please help me with a script that would accomplish this?
I have tried everything I can think of and have struck out miserably.
Thanks in advance.
We are trying to clean up our 1000’s of Distribution Lists before migrating them to 365.Could somebody please help me with a script that would accomplish this?I have tried everything I can think of and have struck out miserably.Thanks in advance. Read More
New Outlook Personalization Background image
Hello – generally I like the Outlook Mail client but the new one which it seems I’m forced to switch to this year seems to be a retrograde step. I have tried all the settings and can not make it nearly as compact as the previous version. Perhaps the biggest annoyance is that the old client allowed the background image (full screen) to be a user selected photo. Now it seems the choice is a plain colour or a fairly bland microsoft background. This does not seem like a complex capability but the lack of it is stopping me switching and prompting me to explore other clients. Have I missed something?
Hello – generally I like the Outlook Mail client but the new one which it seems I’m forced to switch to this year seems to be a retrograde step. I have tried all the settings and can not make it nearly as compact as the previous version. Perhaps the biggest annoyance is that the old client allowed the background image (full screen) to be a user selected photo. Now it seems the choice is a plain colour or a fairly bland microsoft background. This does not seem like a complex capability but the lack of it is stopping me switching and prompting me to explore other clients. Have I missed something? Read More
Leveraging DotNet for SQL Builds via YAML
Introduction
Welcome back and welcome to those who are new to this series of post on SQL Databases. In the previous one we discussed how to import an existing database into your local environment. For this section will talk specifically around building our database into a .dacpac file leveraging Azure DevOps Pipelines. This SQL .dacpac will then be used for deployments. Eventually we will get to leveraging YAML Pipeline Templates to achieve this with any database project.
Wait, Why?
As with anything, by starting with the question of why we can better understand the point in this exercise. The goal here is to produce a .dacpac which can be deployed to any appropriate Azure environment. To achieve one must write the automated process to take a .sqlproj and build this into a reusable .dapac.
One important step that often gets overlooked here. This .dapac should be static! That means, if we re-run our deployment process it should re-deploy the same dacpac. This is an important concept to understand when discussing multi-stage deployments and potentially any rollbacks.
PreReqs
We will carry over the same software requirements from the last post and add a few other details:
Visual Studio Code with the SQL Database Projects Extension OR Azure Data Studio
A .sqlproj under source control
For this demo it will be just a single .sqlproj, though we will review for multiple later in this series
Version Control
I want to take a moment and call this out. Yes, it is a perquisite; however, in my experience, this can be one of the biggest gaps when implementing any type of automated database deployment. Traditionally when we think of version control technologies like git or SVN we assume these are reserved for application developers. Technologies and roles have evolved, and this is no longer the case.
Data Engineers who are leveraging Databricks, Data Factory, or SQL Development should have the expectation that they are using a version control system. By doing so they can quickly collaborate, deploy code at any moment, and provide history across all changes that have been made which will also include the history and why the changes were made.
Build Steps
When writing one of these I have found it can be helpful to write out the individual steps required for our build. In our case it will consist of:
Publishing a folder of SQL scripts for pipeline use (I used security as a placeholder, but these could be any pre/post scripts)
Get the appropriate version of the .NET SDK
Run a DotNetCore Build against the .sqlproj
Publish the .dapac file for pipeline use.
So that’s 4 tasks! I took the liberty of color coding to show dependencies between the tasks. This will dictate that we should use two jobs to optimize our build processes.
Publish Scripts Folder
This job is really optional; however, it is my experience when deploying SQL Databases there is often a need to run a script on the server pre or post deployment. I am illustrating this as it is what I would consider a common ask and one that is typically required.
jobs:
– job: Publish_security
steps:
– task: PublishPipelineArtifact@1
displayName: ‘Publish Pipeline Artifact security ‘
inputs:
targetPath: security
artifact: security
properties: ”
Pretty basic right? We effectively need to pass in the name of the source folder and what we’d like the artifact to be called. We will be leveraging the PublishPipelineArtifact@1 task.
.dacpac Build Job
This job is really the bulk of our operations. As such it is a little bit longer but have no fear. We will walk through each step.
– job: build_publish_sql_sqlmoveme
steps:
– task: UseDotNet@2
displayName: Use .NET SDK v3.1.x
inputs:
packageType: ‘sdk’
version: 3.1.x
includePreviewVersions: true
– task: DotNetCoreCLI@2
displayName: dotnet build
inputs:
command: build
projects: $(Build.SourcesDirectory)/src/sqlmoveme/*.sqlproj
arguments: –configuration Release /p:NetCoreBuild=true
– task: PublishPipelineArtifact@1
displayName: ‘Publish Pipeline Artifact sqlmoveme_dev_Release ‘
inputs:
targetPath: $(Build.SourcesDirectory)/src/sqlmoveme/bin/Release
artifact: sqlmoveme_dev_Release
properties: ”
Alright, this isn’t too bad. These tasks are included in the same job as one cannot run without the other. i.e. We can’t publish a file if it can’t be built. So, let’s dive into each one of these tasks:
This one is another one that is considered optional; however, it allows us to control which version of .NET Core SDK we will use to build our project. If none is specified it will use the latest version on the build agent. I’d suggest putting this in there as it will allow finer grain control.
This task will allow us to run a dotnet command on our build agent. This is important as it will take our .sqlproj and build it into a deployable .dacpac. As such we need to tell it a couple things:
command: build (the command we want to run)
projects: $(Build.SourcesDirectory)/src/sqlmoveme/*.sqlproj (location of our .sqlproj to build)
arguments: –configuration Release /p:NetCoreBuild=true –output sqlmoveme/Release (Any additional arguments required. For this one we are saying what project confirmation ‘Release’. We are also describing this will be a ‘NetCoreBuild’. This argument is now optional as it is now the default; however, older documentation may still show it as required. Also we are specifying the output directory for our built artifacts)
If wondering what is this $(Build.SourcesDirectory) argument is, it is a build in Azure DevOps Variable. As defined by the MS documentation it is “The local path on the agent where your source code files are downloaded.” Put another way a build agent, where your code is running, downloads the repository to a local directly. This variable represents the local directory of your code on the build agent.
End Result
We have a pipeline that publishes the following artifacts:
And here is the complete YAML Pipeline job definition:
trigger:
none
pool:
vmImage: ‘windows-latest’
stages:
– stage: bicepaadentra_build
jobs:
– job: Publish_security
steps:
– task: PublishPipelineArtifact@1
displayName: ‘Publish Pipeline Artifact security ‘
inputs:
targetPath: security
artifact: security
properties: ”
– job: build_publish_sql_sqlmoveme
steps:
– task: UseDotNet@2
displayName: Use .NET SDK v3.1.x
inputs:
packageType: ‘sdk’
version: 3.1.x
includePreviewVersions: true
– task: DotNetCoreCLI@2
displayName: dotnet build
inputs:
command: build
projects: $(Build.SourcesDirectory)/src/sqlmoveme/*.sqlproj
arguments: –configuration Release /p:NetCoreBuild=true
– task: PublishPipelineArtifact@1
displayName: ‘Publish Pipeline Artifact sqlmoveme_dev_Release ‘
inputs:
targetPath: $(Build.SourcesDirectory)/src/sqlmoveme/bin/Release
artifact: sqlmoveme_dev_Release
properties: ”
All the source code for this can be found on a public repository
Next Steps
Now that we have covered how to effectively build a .sqlproj into a .dacpac for deployments our next step will be to deploy this .dacpac to our SQL Server! Feel free to subscribe to this series on SQL Databases alternatively if you like my posts feel free to follow me.
Microsoft Tech Community – Latest Blogs –Read More
How to Resolve HTTP Error 500.35: ASP.NET Core Application Pool Conflicts on IIS
When hosting web applications on IIS, you may encounter the HTTP Error 500.35, which reads: “ASP.NET Core does not support multiple apps in the same app pool.” This error typically surfaces when you’re trying to run more than one ASP.NET Core application in the same application pool. The problem can be frustrating, especially if you’re unaware of the boundaries that lead to this issue.
Cause of the Issue
ASP.NET Core applications have specific hosting requirements, particularly when running on IIS. Unlike traditional ASP.NET applications, ASP.NET Core limit running multiple applications within the same application pool. The root cause of the HTTP Error 500.35 lies in how ASP.NET Core manages its dependencies and runtime environment. When multiple applications share the same app pool, conflicts arise because each application tries to initialize and manage its version of the .NET runtime, leading to instability and crashes.
Solution
To resolve this issue, you can follow these steps to assign separate application pools
• Open the IIS Manager.
• In the Connections pane, expand the server node and click on Application Pools.
• Right-click on the existing application pool or create a new one by selecting Add Application Pool.
• Assign each ASP.NET Core application its own dedicated application pool. Ensure the .NET CLR version is set to “No Managed Code” if using an out-of-process hosting model.
• Associate each application with its respective application pool by right-clicking on the application, selecting Manage Application > Advanced Settings, and choosing the appropriate application pool.
This should resolve the issue. You can also check event logs and stdout logs to identify where and why it’s failing.
Conclusion
The HTTP Error 500.35 occurs because ASP.NET Core limit running multiple applications within the same application pool on IIS. By assigning each application to its own application pool, checking system logs and enabling stdout logging if necessary, you can effectively resolve this issue. Ensuring that each application operates in a separate environment will prevent runtime conflicts and improve the stability of your hosted applications. For more detailed information and troubleshooting steps, you can refer to the official documentation Troubleshoot ASP.NET Core on Azure App Service and IIS | Microsoft Learn.
Microsoft Tech Community – Latest Blogs –Read More
Learn about CAST AI’s transactable partner solutions in Azure Marketplace
Microsoft partners like CAST AI deliver transact-capable offers, which allow you to purchase directly from Azure Marketplace. Learn about these offers below:
CAST AI Agent / CAST AI SaaS: Stay on top of your Microsoft Azure Kubernetes Service (AKS) clusters without spending hours handling repetitive tasks. CAST AI automates Kubernetes cost and active optimization in one simple platform. Thanks to automated rightsizing and cost monitoring, customers around the world save up to 75 percent.
CAST AI Security SaaS: Get AKS security monitoring and automation in one easy-to-use platform. CAST AI uses CIS benchmarks and other well-known frameworks to fix and report vulnerabilities and deviations from best practices. Automation features include Node OS updates as well as policy enforcement.
Microsoft Tech Community – Latest Blogs –Read More
