382,295 questions

Sort by: Updated
0 answers

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…

Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
6,932 questions
asked 2020-11-16T03:01:17.067+00:00
Aaron Liu 1 Reputation point
commented 2020-11-17T00:45:54.537+00:00
Aaron Liu 1 Reputation point
1 answer

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.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,326 questions
asked 2020-11-17T00:18:24.457+00:00
OTTO, REBEKAH ELIZABETH 1 Reputation point
answered 2020-11-17T00:45:35.047+00:00
Anonymous
2 answers One of the answers was accepted by the question author.

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…

Active Directory
Active Directory
A set of directory-based technologies included in Windows Server.
6,573 questions
asked 2020-11-09T01:34:30.317+00:00
MS Lee 61 Reputation points
answered 2020-11-17T00:39:16.96+00:00
MS Lee 61 Reputation points
7 answers One of the answers was accepted by the question author.

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,864 questions
asked 2020-11-14T20:05:35.387+00:00
Fishinforfacts 21 Reputation points
accepted 2020-11-17T00:25:13.11+00:00
Fishinforfacts 21 Reputation points
1 answer One of the answers was accepted by the question author.

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…

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,326 questions
asked 2020-11-16T23:34:19.647+00:00
Deivis Vieira 21 Reputation points
accepted 2020-11-16T23:54:57.863+00:00
Deivis Vieira 21 Reputation points
2 answers One of the answers was accepted by the question author.

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 Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,734 questions
asked 2020-10-23T21:37:28.577+00:00
JAY VORA 21 Reputation points
commented 2020-11-16T23:38:22.617+00:00
MartinJaffer-MSFT 26,086 Reputation points
1 answer One of the answers was accepted by the question author.

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…

Azure Data Catalog
Azure Data Catalog
An Azure service that serves as a system of registration and system of discovery for enterprise data assets.
102 questions
asked 2020-11-04T13:28:15.607+00:00
Janaka Hewavitharana 156 Reputation points
accepted 2020-11-16T23:26:34.59+00:00
Janaka Hewavitharana 156 Reputation points
2 answers One of the answers was accepted by the question author.

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…

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,326 questions
asked 2020-11-16T18:45:18.693+00:00
Isaiah Carleton 21 Reputation points
commented 2020-11-16T22:56:46.717+00:00
Lz._ 9,006 Reputation points
1 answer

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…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,643 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,734 questions
asked 2020-11-07T07:03:54.573+00:00
Ashima Gupta 66 Reputation points
commented 2020-11-16T22:45:46.163+00:00
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
5 answers One of the answers was accepted by the question author.

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…

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,640 questions
asked 2020-11-16T13:21:04.947+00:00
Sh AS 41 Reputation points
accepted 2020-11-16T22:43:34.947+00:00
Sh AS 41 Reputation points
8 answers One of the answers was accepted by the question author.

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…

Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,537 questions
asked 2020-11-12T09:27:18.463+00:00
Mountain Pond 1,441 Reputation points
commented 2020-11-16T22:41:37.503+00:00
Rich Matheisen 46,796 Reputation points
0 answers

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…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,734 questions
asked 2020-11-06T19:26:33.123+00:00
Rasika Athavale 1 Reputation point Microsoft Employee
commented 2020-11-16T22:40:37.95+00:00
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
3 answers One of the answers was accepted by the question author.

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

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,640 questions
asked 2020-11-13T21:22:56.957+00:00
Veena Srinivas 251 Reputation points
accepted 2020-11-16T22:35:58.347+00:00
Veena Srinivas 251 Reputation points
1 answer One of the answers was accepted by the question author.

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) …

Microsoft Entra External ID
Microsoft Entra External ID
A modern identity solution for securing access to customer, citizen and partner-facing apps and services. It is the converged platform of Azure AD External Identities B2B and B2C. Replaces Azure Active Directory External Identities.
2,890 questions
asked 2020-11-16T04:15:20.21+00:00
Dee, Matthew TPC 156 Reputation points
commented 2020-11-16T22:30:40.193+00:00
Dee, Matthew TPC 156 Reputation points
1 answer

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…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,734 questions
asked 2020-11-05T18:59:56.11+00:00
Helen Ho 1 Reputation point Microsoft Employee
answered 2020-11-16T22:28:52.45+00:00
Helen Ho 1 Reputation point Microsoft Employee
1 answer

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?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,932 questions
asked 2020-11-06T01:22:19.763+00:00
Deepthi Kodaru 1 Reputation point
commented 2020-11-16T22:26:21.583+00:00
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

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…

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
21,891 questions
asked 2020-05-11T13:15:20.143+00:00
Jen F 21 Reputation points
commented 2020-11-16T22:17:08.717+00:00
Mick Badran 1 Reputation point MVP
2 answers

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…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,734 questions
asked 2020-11-05T12:56:42.187+00:00
Debbie Edwards 521 Reputation points
commented 2020-11-16T22:16:54.58+00:00
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
1 answer

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…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,474 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,932 questions
asked 2020-11-04T07:49:56.757+00:00
Rohit Boddu 466 Reputation points
commented 2020-11-16T22:08:03.217+00:00
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

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…

Azure Sphere
Azure Sphere
An Azure internet of things security solution including hardware, operating system, and cloud components.
167 questions
asked 2020-10-08T22:59:05.507+00:00
Doug Hardy 31 Reputation points
commented 2020-11-16T22:07:28.763+00:00
QuantumCache 20,271 Reputation points