Please FIX THIS Onedrive authenticator issue through Apple Watch! This is CRY FOR HELP!!!
Address me as Infectedtoes, I need yall to help me and possibly other people with this Apple watch double authentication access. My onedrive has log in authentication set up. My Iphone and apple watch has microsoft authenticator installed. My phone has…
Locating my Microsoft Certification
I recently passed my MOS-200 Excel Exam, and am getting an error message when I try and view the certificate on my Microsoft Learning Dashboard. My Microsoft Certification ID is 990593274.
Best practices to apply GPO to only one computer in an OU
Hi All, I am currently running 2012R2 DC in my environment. I am going to add on another 2016 or 2019 as the 2nd DC. I do need to apply some setting via GPO (as requested by Security Team) on the new DC. There is an existing GPO for the 2012R2 but…
Install of SQL Server 2017 Express Failed with and error 2147467259 and message "%1 is not a valid Win32 application."
I have tried installing numerous versions of evaluation in addition to 2017 Express and get the same error every time. From Summary_MikeHP_20201114_140946.txt in C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20201114_140946 I have one…
Azure DevOps 2020 - Getting definitions from yaml builds through rest api
Hey everyone. We have been using the rest api to retrieve the 'Demands' from our build definitions, but once we switched to yaml this and many other parts of the response is missing. Do I need to look somewhere else for this? We are currently…
Azure data factory - query pipeline by data annotations
Is there a way to programmatically query (using .net SDK) list of data factory pipelines by data annotations? I can set data annotation when I run pipeline as explained here, but not sure how to query pipelines or filter pipelines using the same?…
Azure Data Catalog -Relationship tab
Hi, I have created a Data Catalog (Free version) on my subscription and registered few assets. I know these table have relationships defined and I have registered them all together. However I do not get the relationship tab on the details pane. My last…
Advanced string and number transformations to a power query table
Hello all, I need to split out specific rows that are labeled under the Line column "Project Wide" into two rows with halved quantities and changed Reference numbers from REF.#.L-PW to REF.#.L-49 and REF.#.L-50. The reindexing is simple…
How we can get uptime for all the resources in azure.
Hi guys, I have to check the uptime for the resources in Azure. As for some resources, we can check directly from the Azure portal. I'm able to see uptime for the storage account and SQL database but how can I get the uptime for other resources such…
How to pivot table?
I have a table with following values. Type New Closed Reopen Claim 32 14 97 Line 14 37 7 How do…
Using "-or" in powershell
Hello, please help me to filter this sample: $obj = New-Object psobject -Property @{ FirstName = "Dave" LastName = "Gahan" Band = "Depeche Mode" } if (($obj.FirstName) -or (($obj.Band…
Expiry Datetime incorrect for Tumbling Window Trigger Catchup Run?
I have a pipeline that primarily has 2 copy activities . The sink for the copy activities is ADLS Gen 1, so it also sets an expiry datetime for each of the files copied over. It uses a tumbling window trigger with a self-dependency. Recently, the…
DMV : sys.dm_os_volume_stats
Hello, Is there a way to get historical data from querying with this DMV : sys. dm_os_volume_stats ? I would like to see what the size of the a drive was for each day in the month. Please advise. Thank you, Veena
B2C Multi-Tenant Management
Hi, a (hopefully) quick question: We're looking into the following setup for a client: Azure AD B2C Instance Web App 1 (remotely hosted) Web App 2 (remotely hosted) Web App 3 (remotely hosted) Admin App (hosted on Azure App Service) …
Logs are missing in the Log Analytics Workspace - Azure Data Factory starting 10/23/2020
Hello, Our ADF and the log analytic workspace are hosted under West US2, same as our ADF, and since 10/23, we’ve noticed several pipeline runs do not come with the Succeeded or Failed log, but just InProgress or Queued. It threw off our query since…
Asynchronous execution of statements in stored procedure in Synapse
I have a stored procedure that creates tables and indexes. Is there a way to run these asynchronously inside the stored proc?
Register the service principal for Azure Front Door as an app in your Azure Active Directory via PowerShell
Register the service principal for Azure Front Door as an app in your Azure Active Directory via PowerShell Hi - are you able to tell me if this will cause any type of outage? Especially if other front doors already in use in the environment, but with…
Data Factory Loading multiple csv files. Is there any way of dealing with column header differences?
I have csvs in a datalake. Im coping them into SQL using the copy activity the File Path type is a wildcard file path Very occasionally there are slight differences between the column headers. Is there any way that this can be dealt with rather…
copying data from azure file share to synapse
Hi , I have one requirement like - 1)my users will load some data to azure file share that is mounted on there machine 2) now i want to copy that data from azure file share to container in storage account 3)from that container i want to serve data to…
remove user from sphere tenant, company migrated to Office 365
I need to remove a user from Azure Sphere. The user registered using a company email that was assigned to a Microsoft Tenant user. The company has since migrated to Office 365 using Active Directory sync. The existing registered user was removed so…