Azure SQL Database
An Azure relational database service.
5,147 questions
1 answer
Identify server admin and Active Directory Admin using TSQL
Just that , is there a way whilst connected to the master DB of an Azure PaaS sql server to list the server admin and AAD admin accounts using TSQL? Thanks.
asked 2021-09-07T09:44:55.49+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(118.4, 62%, 21%)' 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)
backtothefuture
91
Reputation points
commented 2021-09-08T11:20:16.683+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, 10%, 12%)' 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)
KalyanChanumolu-MSFT
8,316
Reputation points
2 answers
Custom grammars supported by Microsoft Azure's Speech to Text recognition service?
Hi, I have below 2 queries: Does the speech recognition service support the custom GRXML based grammar for recognition? Does the speech recognition service support the compiled(binary-format) grammar for recognition? We have…
asked 2021-09-07T10:23:18.38+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(48, 38%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Aman Bhardwaj
1
Reputation point
answered 2021-09-08T11:13:14.59+00:00
Aman Bhardwaj
1
Reputation point
4 answers
One of the answers was accepted by the question author.
Handling missing PK-FK relations and get exact duplicate rows in output
Hi all, I have a scenario wherein i have following 2 tables with the below provided data: Create table #Test ( TRTime datetime, ID Int, Charge int ) insert into #Test values('2021-06-30',1,5) insert into #Test…
![](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, 27%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
1 answer
CImageHelper::Init () Failed load of symbol file with path
Hi Team, Can you please help me in troubleshooting the following error. CImageHelper::Init () Failed load of symbol file with path = C:\Program Files\Microsoft SQL Server\MSSQL14\BINN..... Error Code 0xc0000004 There was no dump generated and other…
asked 2021-09-06T00:21:21.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(236.8, 57.99999999999999%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
sandeep alasayam
1
Reputation point
commented 2021-09-08T11:08:09.77+00:00
sandeep alasayam
1
Reputation point
1 answer
One of the answers was accepted by the question author.
email relay for application
Hi All I am using exchange 2016 hybrid environment. Our application users are using anonymous relay i.e our application users in their application to trigger emails use the relay m.mydomain.com on port 25. Now i want to come up with authenticated…
asked 2021-09-03T20:41:10.69+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, 72%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERF%3C/text%3E%3C/svg%3E)
Rising Flight
3,751
Reputation points
accepted 2021-09-08T11:05:25.547+00:00
Rising Flight
3,751
Reputation points
1 answer
Visual Studio 2019 and C# code editor and scrolling by pressing and holding down arrow on the scroll bar
Visual Studio 2019 and C# code editor and scrolling by pressing and holding down arrow on the scroll bar. Let me list the thigs that do work fine: -clicking on and dragging the scroll bar thing, and moving it up and down. -pressing down arrow key…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,621 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,276 questions
asked 2021-09-07T15:31:12.633+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, 61%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
Davorin Mestric
1
Reputation point
answered 2021-09-08T10:56:09.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(249.60000000000002, 10%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAX%3C/text%3E%3C/svg%3E)
Anna Xiu-MSFT
25,801
Reputation points Microsoft Vendor
1 answer
Remote Desktop to normal pc is taking long time, before credentials screens appear.
After last week we noticed that it take a long time (5 to 6 minutes) before the credential screen appears. We have this problem on all W10 versions of our desktop clients. We have clients who login with RDP to take over their desktop at the office, so…
asked 2021-09-08T09:03:20.447+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(51.2, 15%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETR%3C/text%3E%3C/svg%3E)
Tessemaker, Ronald
1
Reputation point
answered 2021-09-08T10:55:50.013+00:00
Tessemaker, Ronald
1
Reputation point
0 answers
Windows 10 camera driver not installing after updating the master WIM
I am preparing a new image for the imaging new Surface devices using WinPE and applying the custom .wim images via USB. I am using WinPE (version 10.1.19041.1) and trying to apply Windows 10 21H1. We have various Surface devices ranging from Surface…
Windows Hardware Performance
Windows Hardware Performance
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Hardware Performance: Delivering / providing hardware or hardware systems or adjusting / adapting hardware or hardware systems.
1,546 questions
![](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, 21%, 10%)' 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)
1 answer
One of the answers was accepted by the question author.
Logic Apps - processing files on an on-premises server
Hello, We have a requirement to use Logic Apps to process files located on an on-premises file share. My question is what options do we have? 1) One option is to install on-premises data gateway, but I’m reading that there’s is a 2mb file size limit with…
asked 2021-09-07T10:31:29.03+00:00
Ershad Nozari
421
Reputation points
accepted 2021-09-08T10:30:26.507+00:00
Ershad Nozari
421
Reputation points
1 answer
One of the answers was accepted by the question author.
Two Weird Phenomena in C# Word Interop Table AddRows and DeleteRows Performance Benchmark Test
Dear Sir/Madam, To address the C# Word Interop Word.Table.AddRows() method performance issue, we are trying to apply the Word.Table.DeleteRows() method instead, upon a Word table template. This is because per our perception, Word.Table.DeleteRows()…
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,276 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,508 questions
![](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(41.6, 3%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDX%3C/text%3E%3C/svg%3E)
1 answer
Unable to access Azure Synapse Resource when I am the owner
I am the owner, and unable to access Azure Synapse? Please advise at your earliest convenience. Thank you.
asked 2021-09-02T20:18:18.79+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(41.6, 94%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Ron Ahmad
21
Reputation points
commented 2021-09-08T10:25:13.12+00:00
PRADEEPCHEEKATLA-MSFT
77,676
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to connect Purview to Data lake with out IR ?
is there any other way to connect Purview to Data lake with out self hosted integrated runtime ?
asked 2021-09-01T11:00:35.307+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(316.8, 49%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Syamala Vishnuvajhala
41
Reputation points
accepted 2021-09-08T10:24:59.953+00:00
Syamala Vishnuvajhala
41
Reputation points
1 answer
Retention period for inactive protection protected data in DPM
Hi, Hope someone can answer this for me, in Microsoft Azure Backup server Data Protection Manager is there a retention period for inactive protection protected data? i.e. data in inactive protection protected data get pruned after a set time or…
asked 2021-09-08T06:50:02.657+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(147.20000000000002, 28.000000000000004%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
R.A.Gayan Sanjeewa Perera
6
Reputation points
commented 2021-09-08T10:17:04.2+00:00
Leon Laude
85,666
Reputation points
3 answers
Receiving Power Shell Scripts failed to ran alerts in SCOM 2019 on agent managed machines
Hi All, We are in the process of setting up SCOM 2019 environment, We are getting Power Shell Script failed to run. Alert Detail:Power Shell Script failed to run Alert Rule: Alert on Failed Power Shell Scripts Alert Description: Forced to…
asked 2021-03-24T09:24:37.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(300.8, 39%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
shankar431
471
Reputation points
commented 2021-09-08T10:14:27.387+00:00
shankar431
471
Reputation points
2 answers
One of the answers was accepted by the question author.
How do I add a guid to the where condition?
How do I add a guid to the where condition, I have tried the following two methods but cannot find the correct data DECLARE @myid uniqueidentifier ; SET @myid = '0000397b-c67f-4a3d-850f-865641bd2cd9'; SELECT TOP 10 * FROM OPENROWSET( BULK…
asked 2021-09-01T08:00:45.41+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(243.2, 82%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Andrew Huang (Beyondsoft Corporation)
271
Reputation points
commented 2021-09-08T10:08:18.24+00:00
PRADEEPCHEEKATLA-MSFT
77,676
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Data ingestion is not working in Azure Data Explorer after I created a new data connection
I have created a new data connection in my Azure Data Explorer Cluster. I have chosen the connection type Blob storage and the event type Blob created. In addition, I have chosen Resources creation Automatic. I didn't get an error message when I…
asked 2021-09-01T07:54:42.427+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(121.6, 32%, 21%)' 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)
Kim Strasser
661
Reputation points
commented 2021-09-08T10:06:42.897+00:00
PRADEEPCHEEKATLA-MSFT
77,676
Reputation points Microsoft Employee
1 answer
User unable to see the Office Store in Excel (we have it enabled).
User has O365, latest update (and a fresh Online Repair). E3 license. I have a user that when in Excel has no access to the Office Store. They go to Insert->Get Add-ins only has a tab for Admin Managed. I get all 3 with the same licensing. Below…
asked 2021-08-27T23:56:55.16+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(304, 19%, 39%)' 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)
Erik Metzler
1
Reputation point
commented 2021-09-08T10:05:39.887+00:00
Viki Ji_MSFT
4,421
Reputation points
1 answer
One of the answers was accepted by the question author.
Web.Contents() : Power Query to Kobo Toolbox REST API to filter by date
Hi all, Quite a specific problem here. I need to connect to a Kobo Toolbox dataset via Power Query in Excel. Due to the size of the dataset, I need the Power Query to filter by a date column before downloading all the records to Excel. Looking…
asked 2021-09-07T17:59:47.887+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(188.79999999999998, 77%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Steven Dixon
96
Reputation points
commented 2021-09-08T09:56:58.41+00:00
Emi Zhang-MSFT
22,011
Reputation points Microsoft Vendor
1 answer
How to Managing SQL Server Permissions in Azure
A deny will override a grant. This means that if a user is denied permission they cannot inherit a grant from another source https://isqlplus.com/sql-server/sql-server/managing-permissions/ -Scott
asked 2021-09-01T04:48:18.34+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(118.4, 19%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETA%3C/text%3E%3C/svg%3E)
Tanveer Ahmed
1
Reputation point
commented 2021-09-08T09:56:26.007+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(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma
17,571
Reputation points
0 answers
Does MySQL connector class slowdown windows forms app?
I'm using MySQL.Data NuGet package to connect a windows forms app to a remote Azure Database for MySQL server. I've used the following class to connect to the database. private void Initialize() { //string connectionString =…
asked 2021-08-31T04:58:51.22+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(92.8, 86%, 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)
MadhawaBamini
1
Reputation point
commented 2021-09-08T09:55:45.437+00:00
Anurag Sharma
17,571
Reputation points