385,734 questions

Sort by: Updated
Updated Created Answers
4 answers One of the answers was accepted by the question author.

Powerpivot Equivalent for Excel SUMIFS Where Lookup Field Contains Partial Text from Another Field

I am relatively new to DAX and have scoured the forums but not found anything that quite works in Powerpivot/Dax yet. I am trying to sum each record where the Member No is contained within the Hierarchy string e.g. the first Member No occurs in rows…

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,725 questions
asked 2020-11-20T13:11:05.103+00:00
Paul Cumming 96 Reputation points
commented 2020-11-24T01:39:02.513+00:00
Erin Ding-MSFT 4,461 Reputation points
1 answer

sharing webcam within multiple applications

Hi, I am on Windows 10 20H2, just tested that my laptop's camera cannot be shared at the same time with multiple applications (Zoom and Chrome e.g.) but only one at a time. On my mac, instead, I can. While searching on the web I jumped to an old,…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,702 questions
asked 2020-11-22T18:03:23.697+00:00
Elaci0 1 Reputation point
commented 2020-11-24T01:33:31.533+00:00
Jenny Yan-MSFT 9,336 Reputation points
9 answers

Removing Exchange 2010 before decommissioning SBS 2011 lost access to Active Directory on both servers.

I'm trying to decommission an SBS 2011 server and promote my Server 2019 to take over all roles. The 2019 server is a domain controller but does not yet hold any FSMO roles. The email has long been moved and I'm just trying to remove Exchange 2010,…

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,790 questions
Windows Small Business Server
Windows Small Business Server
A family of Microsoft server products with messaging and collaboration, security-enhanced internet access, protected data storage, reliable printing, faxing, and the ability to run line-of-business applications. Replaced by Windows Server Essentials.
40 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,210 questions
Active Directory
Active Directory
A set of directory-based technologies included in Windows Server.
6,630 questions
asked 2020-11-21T18:26:01.393+00:00
Bill Fewell 1 Reputation point
commented 2020-11-24T01:33:08.353+00:00
Anonymous
1 answer

Can not integrate Forms in Powerpoint

Hi, Our organization can not use Forms as an add-in in Powerpoint. Our administrators do not allow third-party add-ins (although Mentimeter is somehow added) and apparantly that is why we don't have permission. Forms is however pre-installed as…

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,651 questions
asked 2020-11-23T14:05:02.977+00:00
Milan 1 Reputation point
commented 2020-11-24T01:24:21.76+00:00
Daniel Zhang-MSFT 9,626 Reputation points
9 answers

How to replace a special character or punctuation in a string in SQL Server

I am prepping our data to make it a URL. But I've been into a lot of obstacle. If it's just a punctuation or some special characters, I can do nested REPLACE Functions and that is not a problem. What I'm dealing with right now is how to fully make it…

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,968 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,652 questions
asked 2020-11-17T21:22:47.787+00:00
MichaelLouieEusebio-3546 1 Reputation point
commented 2020-11-24T01:20:43.347+00:00
EchoLiu-MSFT 14,581 Reputation points
0 answers

Azure Sentinel (Log) Analytics (Workspace)

Dear Sir/Madam, Use Case: Deploying a fast solution for the Mitre Att&ck Framework analysis: https://github.com/BlueTeamLabs/sentinel-attack/wiki Solution we seek: Mass Enable Categories of the Analytics Templates (ask for select, or…

Microsoft Sentinel
Microsoft Sentinel
A scalable, cloud-native solution for security information event management and security orchestration automated response. Previously known as Azure Sentinel.
1,152 questions
asked 2020-11-19T12:33:12.783+00:00
nwsentinel4 201 Reputation points
commented 2020-11-24T00:48:57.763+00:00
Marilee Turscak-MSFT 36,861 Reputation points Microsoft Employee
1 answer

SQL Hybrid benefit not able to change for SQL on Azure VM with 1 year or 3 year reservation

My question is regarding the azure pricing site (https://azure.microsoft.com/en-us/pricing/calculator/) , for the option of SQL Pricing on Azure VM. i am not able to change the SQL Hybrid benefit option ( to sql hybrid) for SQL on Azure VM with 1…

SQL Server on Azure Virtual Machines
asked 2020-11-23T11:25:30.78+00:00
MS Techie 2,701 Reputation points
answered 2020-11-24T00:46:59.653+00:00
whoward-msft 2,766 Reputation points
0 answers

CDS web hook associate event doesn't trigger

Hi, I followed these instructions to create a webhook for the associate/disassociate even in CDS: https://crmtipoftheday.com/1362/trigger-power-automate-on-associate-disassociate/ I checked with the pipedream tool to see if it triggers at all.…

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,200 questions
asked 2020-11-17T10:33:23.52+00:00
Frank Voortman 1 Reputation point
commented 2020-11-24T00:43:04.507+00:00
Mike Urnun 9,816 Reputation points Microsoft Employee
5 answers One of the answers was accepted by the question author.

Export from SQL Server to Excel, all text fields have a leading single quote

Using SQL Server 2019 I'm exporting data from a table to Excel, however, ALL cells with data have a leading single quote. The corrupts all the data. How can this be avoided? Thank you.

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,968 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,652 questions
asked 2020-11-19T22:26:18.863+00:00
moondaddy 911 Reputation points
commented 2020-11-24T00:20:54.813+00:00
moondaddy 911 Reputation points
0 answers

Unable to connect the DR region Azure SQL DB from Primary region jump host using SSMS

Under SQL PAAS - firewall and virtual network option in DR region we can see only DR region vnets but not primary region vnets due to that we are unable to connect primary region SSMS to DR Region Azure SQL PAAS DB. Any idea ?

Azure SQL Database
asked 2020-11-19T02:22:14.053+00:00
Subramanya Jayaram 1 Reputation point
commented 2020-11-24T00:19:37.343+00:00
Navtej Singh Saini 4,226 Reputation points Microsoft Employee
0 answers

Azure AD can't seem to find my app

I'm developing a MATLAB application that uses the MSAL4J for authentication. When I call the function a browser tab is opened however when it attempts to sign it just gives me an error code. The client id and the authority seem to match the ones in Azure…

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,067 questions
asked 2020-11-16T18:49:02.037+00:00
Murats 6 Reputation points
commented 2020-11-24T00:13:58.947+00:00
JamesTran-MSFT 36,631 Reputation points Microsoft Employee
3 answers One of the answers was accepted by the question author.

Dynamic SQL in UDF - Work around

Hello everyone I have a 16 period fields in a schema, for example PreviousMonth where each date in the previous month has a value of 1 I trying to write a function that returns the Max date key dependant on the Field I pass in PreviousMonth,…

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,652 questions
asked 2020-11-23T13:54:22.89+00:00
ron barlow 411 Reputation points
answered 2020-11-24T00:07:52.107+00:00
Joe Celko 16 Reputation points
1 answer One of the answers was accepted by the question author.

error APT1000: Attribute "imageAspectRatioAdjust" already defined with incompatible format.

the following error comes out after changing the target platform from Android 8 to Android 9, 10 or 11. + updating dependencies + migration to AndroidX: \ obj \ Debug \ 110 \ lp \ 64 \ jl \ res \ values ​​\ values.xml (4): error APT1000: Found tag id…

Xamarin
Xamarin
A Microsoft open-source app platform for building Android and iOS apps with .NET and C#.
5,362 questions
asked 2020-11-23T12:18:53.837+00:00
Александр Р 116 Reputation points
accepted 2020-11-23T23:58:16.113+00:00
Александр Р 116 Reputation points
5 answers One of the answers was accepted by the question author.

Powershell and Published Data Orchestrator 2016

I am using Orchestrator 2016 with the reg change to make it use powershell 5. In Powershell ISE, I run this simple query for a remote box to check the status of Windows updates via WMI: $CCMUpdate = get-wmiobject -query "SELECT * FROM…

System Center Orchestrator
System Center Orchestrator
A family of System Center products that provide an automation platform for orchestrating and integrating both Microsoft and non-Microsoft IT tools.
230 questions
asked 2020-11-23T17:41:35.763+00:00
ben 21 Reputation points
commented 2020-11-23T23:36:37.053+00:00
Andreas Baumgarten 111.1K Reputation points MVP
1 answer One of the answers was accepted by the question author.

IIS compression intermittent

We have a conflict with our JavaScript minifier and IIS compression. The minifier recreates the file when the app pool resets and on other occasions. The zipped version of the file that was stored by IIS is occasionally not a complete file. We are…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,606 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,210 questions
asked 2020-11-19T18:30:38.573+00:00
Robert Crockett 21 Reputation points
accepted 2020-11-23T23:23:54.973+00:00
Robert Crockett 21 Reputation points
1 answer

Azure Notification not working window app based

Hi I tried to use windows app based notification using azure Created Developer Portal Created the App On product management WPN/MSPN click and clicked on Live Services site. Copied the Application Secrets and Package SID In Azure Portal…

Azure Notification Hubs
Azure Notification Hubs
An Azure service that is used to send push notifications to all major platforms from the cloud or on-premises environments.
325 questions
asked 2020-11-05T13:24:48.227+00:00
Murali J 1 Reputation point
commented 2020-11-23T22:26:31.72+00:00
Ryan Hill 28,546 Reputation points Microsoft Employee
1 answer

How to enable MFA in azure for SaaS applications?

Hello, We have our AD/ADFS hosted in azure on a vm ( not Azure AD) and are using it as identity provider for external applications ,now we have a requirement to enable MFA for a particular SaaS application , is it possible to enable MFA without Azure…

Active Directory Federation Services
Active Directory Federation Services
An Active Directory technology that provides single-sign-on functionality by securely sharing digital identity and entitlement rights across security and enterprise boundaries.
1,261 questions
asked 2020-11-22T10:28:07.793+00:00
roy lucky 1 Reputation point
commented 2020-11-23T22:13:39.86+00:00
Andy David - MVP 149.1K Reputation points MVP
1 answer

Microsoft docs learning points have dissapeared

Hi My learning history resetted for some reason? I was at level 7-8 because of all the point/courses I have achieved, but now I re-visited the website and i'm back at 0 (level 1). A bit dissapointing you can imagine, any idea what could be the…

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,651 questions
asked 2020-11-23T22:10:23.01+00:00
Andreas Otten 1 Reputation point
answered 2020-11-23T22:12:11.833+00:00
Leon Laude 85,816 Reputation points
1 answer One of the answers was accepted by the question author.

Exchange Certificate Renewal

My existing Exchange certificate is about to expire so I renewed it using the EAC console. I sent the CA request to my CA provider, got the cert, completed the cert request on my server and now I have TWO Exchange SMTP certificates for the same domain. …

Microsoft Exchange Online Management
Microsoft Exchange Online Management
Microsoft Exchange Online: A Microsoft email and calendaring hosted service.Management: The act or process of organizing, handling, directing or controlling something.
4,572 questions
Exchange Server Management
Exchange Server Management
Exchange Server: A family of Microsoft client/server messaging and collaboration software.Management: The act or process of organizing, handling, directing or controlling something.
7,663 questions
asked 2020-11-23T14:26:15.59+00:00
Joshua Thompson 166 Reputation points
commented 2020-11-23T22:06:24.95+00:00
Joshua Thompson 166 Reputation points
5 answers One of the answers was accepted by the question author.

SSRS History snapshots

How to find SSRS History snapshots retention on all reports ? Can we force the default History snapshots retention settings for all reports

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,936 questions
asked 2020-10-22T15:34:10.697+00:00
Suresh 41 Reputation points
answered 2020-11-23T21:59:33.777+00:00
Suresh 41 Reputation points