Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,625 questions
1 answer
One of the answers was accepted by the question author.
Hash Collision percentage on HASHBYTES SHA2_512
Hello, we are trying to move a large table and want to confirm the varbinary values do not change (or at least capture it if it changes). We plan to use below query: select ID, HASHBYTES('SHA2_512', cast(blob AS VARBINARY(8000))) from BlobTable; I…
asked 2020-08-27T07:20:17.623+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(176, 90%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
Larimore Suanque
41
Reputation points
commented 2020-08-27T08:04:34.787+00:00
Larimore Suanque
41
Reputation points
1 answer
Setup wizard inside Android Emulator (Visual Studio 2019)
Hello community, I'm writing to ask for this question: is there the possibility to run first boot welcome wizard while running Android Emulator for the first time in Visual Studio 2019 ? Thank you, Luca
asked 2020-08-26T12:49:42.187+00:00
Luca Fabbri
156
Reputation points
answered 2020-08-27T08:04:15.607+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, 11%, 10%)' 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)
Dylan Zhu-MSFT
6,416
Reputation points
2 answers
create email id under my custom domain
how to create email id under my custom domain for sending emails ?and what is the email limit for sending ?
asked 2020-08-19T15:36:32.77+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(86.4, 60%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
kar megan
1
Reputation point
commented 2020-08-27T08:03:52.133+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(28.799999999999997, 82%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEY%3C/text%3E%3C/svg%3E)
Eric Yin-MSFT
4,386
Reputation points
2 answers
S-1-5-18 is using SendAs permissions in Office 365 (Exchange)
Hi- "S-1-5-18" is a well know operating system service account. On the exchange audit logs, i notice that this account is using SendAs permissions to send email on behalf of other mailboxes. Also, "Operation":"Create" kind…
asked 2020-08-19T11:23:03.867+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(259.20000000000005, 33%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Venkatesh
36
Reputation points
commented 2020-08-27T07:59:31+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(25.6, 67%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Joyce Shen - MSFT
16,661
Reputation points
2 answers
One of the answers was accepted by the question author.
File System Error - Errors in the metadata manager. Processing for the database will be disabled because an error occurred while loading the cube-user database cryptography key.
SSAS DB Synchronization job is scheduled to synch using a XMLA script via SSIS. This synch the SSAS DB 'ESSJMT' from process server ( Source ) to Query Server(Destination). When it failed , server logged below error. And when I tried to run profiler…
asked 2020-08-16T10:36:17.99+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, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Komal Sahu
311
Reputation points
accepted 2020-08-27T07:55:21.713+00:00
Komal Sahu
311
Reputation points
2 answers
One of the answers was accepted by the question author.
[WPF] What control should I use to embed Excel in my app
Hello, thanks for reading, I am upgrading an app from VB6 to VB.NET using WPF, in this old VB6 app there was "OLE" objects allowing the app to show Excel graph, sheets, and more. In WPF i couldn't find any similar objects, so i found this…
asked 2020-08-18T09:58:14.647+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(256, 7.000000000000001%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETO%3C/text%3E%3C/svg%3E)
théo Bainée
21
Reputation points
commented 2020-08-27T07:51:52.497+00:00
théo Bainée
21
Reputation points
1 answer
LogicApps SignIn fails with Sharepoint connector
When I try to connect to a SharePoint connector in LogicApps, it fails with this error - Failed with error: 'OAuth2CertificateSharePointOnlineV2 authorization flow failed for service 'SharePoint Online Certificate V2'. MSGraph discovery endpoint…
asked 2020-08-25T02:57:11.077+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(192, 43%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jane
1
Reputation point
commented 2020-08-27T07:31:14.157+00:00
MayankBargali-MSFT
70,221
Reputation points
1 answer
Migrate from Azure SQL to Azure SQL hyper scale
hi all, i have azure SQL server with two db 4 TB each. now we have limitation of 4TB for a single database. to overcome this issue are planning to move Azure SQL hyper scale with 100 TB. our question do we have 100 % compatibility for Azure SQL to…
asked 2020-08-27T07:15:07.767+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(153.6, 57.00000000000001%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Verma, Manish Kumar
131
Reputation points
answered 2020-08-27T07:31:02.42+00:00
Ronen Ariely
15,191
Reputation points
3 answers
Extended Events to trace Foreign Keys becoming untrusted
I am trying to find out what is continually setting the Foreign Keys and Constraints to untrusted. I've setup an Extended Events session to trap Alter Table events but it's not catching it. How can I trap this using Extended Events? WHERE…
asked 2020-08-21T15:28:25.193+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(313.6, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIB%3C/text%3E%3C/svg%3E)
Iain Barnetson
106
Reputation points
answered 2020-08-27T07:28:46.713+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(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,626
Reputation points
1 answer
One of the answers was accepted by the question author.
Other ways to convert CSV to JSON (more performance)
Hello everybody, I am using an Azure Logic app to convert a CSV file to JSON to transform the data into a SharePoint Online list. I am using this exact same approach as described here:…
asked 2020-08-20T19:59:50.3+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, 65%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
Joost van der Linden
96
Reputation points
commented 2020-08-27T07:28:16.357+00:00
MayankBargali-MSFT
70,221
Reputation points
4 answers
One of the answers was accepted by the question author.
AlwaysOn reads on readonly replica and latency
Hi all, On an sqlserver2016 alwayson replica in asynchronous mode with readonly activated, If I have a long query (several minutes) selecting datas, are the logs still applied or is it waiting the end of the query to apply the new logs and keep data…
![](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(217.60000000000002, 51%, 31%)' 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)
1 answer
When a item is modified logic apps trigger does not works
i have created a logic app with trigger when an item is modified in SQL server on premise (installed gateways are connected when an item is created it is working fine) but using trigger when an item is modified not triggering the logic apps
asked 2020-08-25T17:17:51.56+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(54.400000000000006, 94%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Kumaresan P
6
Reputation points
commented 2020-08-27T07:08:19.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(134.4, 59%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
ChaitanyaNaykodi-MSFT
25,856
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
asked 2020-08-26T13:19:02.147+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(16, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELF%3C/text%3E%3C/svg%3E)
liban fahad
21
Reputation points
answered 2020-08-27T07:03:38.593+00:00
liban fahad
21
Reputation points
2 answers
Server not receiving config file
hi We seen that config file is not receving on one of agent. Ports are open and we disabled the ping on few server including this. But all those working fine. Right now we have heartbeat alert in console which is not closing even after flush.
asked 2020-08-21T12:04:13.583+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(182.40000000000003, 20%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Chetan rms
21
Reputation points
commented 2020-08-27T07:00:58.287+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(166.4, 66%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AlexZhu-MSFT
5,871
Reputation points Microsoft Vendor
1 answer
UWP equivalent of Android's SpannableString with image inside
Is there a way to implement an image within a TextBlock rather than outside of it? Android has a feature called SpaanableStringBuilder which allows the user to create text with different appearances. Does UWP have something similar? MyTextBlock.Text =…
asked 2020-08-18T17:13:30.857+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(307.2, 62%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Apptacular Apps
386
Reputation points
commented 2020-08-27T07:00:34.257+00:00
Richard Zhang-MSFT
6,936
Reputation points
2 answers
Create bootable media issue
I have a number of folders under Task Sequences used by different admins. When I make changes to TS within my folder and create bootable media right clicking that folder and selecting a particular DP I can't see the changes reflected when the OSD is…
asked 2020-08-20T11:17:01.433+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, 4%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
YaroC
311
Reputation points
commented 2020-08-27T06:59:56.533+00:00
AlexZhu-MSFT
5,871
Reputation points Microsoft Vendor
1 answer
How render a Softwarebitmap without using SoftwareBitmapSource?
Now I have the following code: async Task<SoftwareBitmap> ReadSoftwareBitmap(string filename) { var picFile = await dailyFolder.GetFileAsync(filename); var decoder = await…
asked 2020-08-14T13:28:24.867+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(6.4, 69%, 10%)' 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)
Neo
421
Reputation points
commented 2020-08-27T06:59:46.333+00:00
Richard Zhang-MSFT
6,936
Reputation points
1 answer
Launching with missing optional dependency dll
Our app uses third party library that is referencing mfplat.dll (and mfreadwrite.dll) of Media Foundation. MF dlls are usually present in the OS, except apparently on Windows N where media component is not installed by default. When launched on Windows…
asked 2020-08-06T09:55:10.823+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(220.8, 54%, 31%)' 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)
Андрей Вахрушев
96
Reputation points
commented 2020-08-27T06:58:50.047+00:00
Richard Zhang-MSFT
6,936
Reputation points
2 answers
SCOM Event Id 623 | HealthService (9348)
Hi , We have this event id 623 on one of the agent resulting the agent to be in greyed out. Below is the eventid details. Could you please help me understand the issue and resolution. "HealthService (9348) Health Service Store: The version…
asked 2020-08-26T10:26:02.087+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(32, 76%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Swapna Malipatil
1
Reputation point
answered 2020-08-27T06:53:45.453+00:00
AlexZhu-MSFT
5,871
Reputation points Microsoft Vendor
1 answer
Moving Folders With FSRM
My team has been asked to set up an automated system to "archive" project directories on our Server 2019 share. In reality they want certain directories to be moved to another location automatically based on a flag file saved within the…
![](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, 94%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIX%3C/text%3E%3C/svg%3E)