SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,949 questions
2 answers
Dynamics hanging when deleting workflows
Our Dynamics implementation is very slow. Trying to delete workflows almost freezes the system. We cannot bulk delete process sessions. workflowlogbase and processsessionbase tables are over a million records and the known clean-up script doesn't…
asked 2020-11-20T21:39:42.96+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 71%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rickert, Sandi
1
Reputation point
answered 2020-11-24T01:46:02.563+00:00
m
4,271
Reputation points
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…
asked 2020-11-20T13:11:05.103+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 54%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
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,…
asked 2020-11-22T18:03:23.697+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 55.00000000000001%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Elaci0
1
Reputation point
commented 2020-11-24T01:33:31.533+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 50%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJY%3C/text%3E%3C/svg%3E)
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,…
asked 2020-11-21T18:26:01.393+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 52%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBF%3C/text%3E%3C/svg%3E)
Bill Fewell
1
Reputation point
commented 2020-11-24T01:33:08.353+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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…
asked 2020-11-23T14:05:02.977+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 43%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Milan
1
Reputation point
commented 2020-11-24T01:24:21.76+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 7.000000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDZ%3C/text%3E%3C/svg%3E)
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…
asked 2020-11-17T21:22:47.787+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 9%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELE%3C/text%3E%3C/svg%3E)
Louie E
1
Reputation point
commented 2020-11-24T01:20:43.347+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 76%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
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…
asked 2020-11-19T12:33:12.783+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 82%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
nwsentinel4
201
Reputation points
commented 2020-11-24T00:48:57.763+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 81%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
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…
asked 2020-11-23T11:25:30.78+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 71%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
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.…
asked 2020-11-17T10:33:23.52+00:00
Frank Voortman
1
Reputation point
commented 2020-11-24T00:43:04.507+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 87%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMU%3C/text%3E%3C/svg%3E)
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 75%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
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 ?
asked 2020-11-19T02:22:14.053+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 48%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Subramanya Jayaram
1
Reputation point
commented 2020-11-24T00:19:37.343+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
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…
asked 2020-11-16T18:49:02.037+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 48%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
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,…
asked 2020-11-23T13:54:22.89+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 5%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
ron barlow
411
Reputation points
answered 2020-11-24T00:07:52.107+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 89%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
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…
asked 2020-11-23T12:18:53.837+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 49%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Александр Р
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…
asked 2020-11-23T17:41:35.763+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 6%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
ben
21
Reputation points
commented 2020-11-23T23:36:37.053+00:00
Andreas Baumgarten
110.9K
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…
asked 2020-11-19T18:30:38.573+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 56.00000000000001%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 89%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
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…
asked 2020-11-22T10:28:07.793+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 24%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
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…
asked 2020-11-23T22:10:23.01+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 54%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAO%3C/text%3E%3C/svg%3E)
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. …
asked 2020-11-23T14:26:15.59+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 45%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Joshua Thompson
166
Reputation points
commented 2020-11-23T22:06:24.95+00:00
Joshua Thompson
166
Reputation points