CMPivot query
Hello, I have this query used by CMPIVOT: Registry('HKLM:\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate') | where Property == 'WUServer' | order by Value Now I would like a query which will gives me the registry missing this WUServer…
I cannot import excel documents into SQL Server Management Studio.
It wont let me upload screenshots for some reason but I open SSMS, I create a database I try to import an Excel document into SSMS by right clicking the database, selecting Tasks, and import Excel.. . I then select my excel worksheet document and try to…
Function App Cannot Create within Azure Portal
Seems there have been two changes that are getting in the way of creating functions after having created a function ressource. There is no longer the "Function f(x)" under the left menu called Functions, and seems we can only access it now…
Use Dataverse triggers and actions in Power Automate - where is the Innovation Challenge application?
On unit 5 of 7 it mentions opening this application to start the exercise. Yet for anyone new it doesn't say or link where that application was first created? Any help would be greatly appreciated This question is related to the following Learning…
Order of upgrading OS & SQL Server
Is the following order fine for us to proceed with? Back Up of both WS & SQL DBs Upgrade SQL 2014 Enterprise RTM to SQL 2014 SP3 Enterprise Upgrade WS 2012 R2 to WS 2019 DC Upgrade Roles & File server, SCCM Upgrade SQL 2014 Enterprise SP3 to…
Azure recurring monthly $29 charge.
Our company credit card is charged $29 a month for MSFT Azure and we do not know what it relates to. How do we find out?
Unexpected truncation error when inserting from UTF8 to non-UTF8 collation
I believe I am hitting a bug with moving data from a UTF8 to a non-UTF8 collations in SQL Server 2022 CU13 (running under Linux but assuming for now this issue is not related). The issue is that MSSQL appears to be determining the width of a string for…
Change Password using Microsoft Graph Beta
I am using Microsoft Graph beta and trying to reset password for the user.. It is giving me following error "Exception of type 'Microsoft.Graph.Beta.Models.ODataErrors.ODataError' was thrown.:::: at…
D:\Allfiles\Labs\01-prepare-data-with-power-query-in-power-bi-desktop\Starter
Hello, there are no files in the Allfiles folder. I can't move on with the training module. Should I skip it and come back when this foler will be restored? D:\Allfiles\Labs\01-prepare-data-with-power-query-in-power-bi-desktop\Starter This question is…
MAUI: Plugin.InAppBilling.InAppBillingPurchaseException: Unable to process purchase. at Plugin.InAppBilling.InAppBillingImplementation
I am getting below exception when I try to pay for a subscription for play store. Plugin.InAppBilling.InAppBillingPurchaseException: Unable to process purchase. at Plugin.InAppBilling.InAppBillingImplementation.ParseBillingResult(BillingResult result,…
Restricting Third-Party Calls on Teams: Best Practices and Prevention Strategies
How can I restrict third parties from calling users on Teams? Recently, we encountered an incident where an unknown third party started calling one of our users on Teams. What are the best practices to avoid or prevent such incidents from happening in…
SSMS 20 can't show conflict viewer
Hi! Clicking on View conflicts in Object Explorer open Connect to Server dialog form instead of Conflict Viewer. If I fill in form to connect to the same server, it creates very strange error: A connection was successfully established with the server,…
Fiz a inscrição gratuita do Azure para Estudos e Me surpreendi com uma fatura
Fiz a inscrição no Azure, clicando na sugestão de conta gratuita e agora me surpreendi com uma fatura de R$ 72,00. Como revisar a conta para saber se de fato a conta é gratuita ou não?
AppRole Creation using Graph API
Hi Experts, The MS document for appRole creation json body is expecting a GUID, could someone please help what is the GUID to be given here. { "allowedMemberTypes": ["String"], "description": "String", …
Excel - How do I get cells to change colour when they are nearing future expiry dates
Hi, I have a spreadsheet with staff names down column A, and across the top I have different training courses they attend which they are required to refresh after 1, 2 or 4 years (depending on training). I want to be able to enter the date they attend,…
Issues accessing D365 Business Central API under free trial
I have a D365 Business Central API URL under free trial: "https://api.businesscentral.dynamics.com/v2.0/{tenant_id}/{environment}/api/v2.0/companies({company_ID})/items" However, we are facing issues accessing it. Every time we try to access…
ADF pipeline/dataflow creates temporary GUID folders and files and not delete them
Hi, I have a problem that my processes, from time to time, create temporary GUID folders and/or files in them but, in the end, not deleting them. Where is the problem/reason of that?
How to determine the best weights for the scoring profile?
Hi, I am new to Azure AI Search. I have successfully created an index and would like to optimize using the scoring profile, and understand that you would have to assign weights to fields. However, I am confused as to how I can determine the…
Self-hosted machine unable to access Data Lake Storage account when running a pipeline using Synapse
Hello - I need your help again: Here's the story: I have azure synapse workspace I have created managed private end point created for ADLS - working fine I have create private endpoint created for ADLS - working fine ADLS have set the public access…
In Entra Permissions Management, what does ED Group mean/stand for?
In Entra Permissions Management, when looking at the groups assigned to a user, they all show as "ED Group". Please can someone explain what this means and if possible provide some documentation.