Azure IoT Edge
An Azure service that is used to deploy cloud workloads to run on internet of things (IoT) edge devices via standard containers.
541 questions
1 answer
Azure SQL Edge Streaming Job Hangs
I have a Azure SQL Edge database deployed as a container on IoT Edge. After a certain amount of time the job stops processing but when looking at the status it says that it is still processing. When this issue happens, I have to stop the job and…
asked 2022-08-08T20:09:56.56+00:00
Phil Andreoli
1
Reputation point Microsoft Employee
answered 2022-08-09T13:55:19.647+00:00
Phil Andreoli
1
Reputation point Microsoft Employee
2 answers
Getting below errors from the client side while coonecting to SQL On prem Server
OLE DB provider "SQLNCLI11" for linked server "SQLAPP1" returned message "Communication link failure". OLE DB provider "MSOLEDBSQL" for linked server "SQLAPP1" returned message "Protocol error in…
asked 2022-06-16T16:39:37.483+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, 25%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJE%3C/text%3E%3C/svg%3E)
Jeremy Edmond
1
Reputation point
answered 2022-06-17T02:37:11.023+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, 84%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
YufeiShao-msft
7,056
Reputation points
0 answers
Pre-login handshake Error while connecting to Azure SQl Edge from ADS
Hi Team, I'm setting up Azure SQL Database on the local machine (Windows 11) using Azure Data Studio. I followed the below article to create an Azure SQL Edge instance: …
asked 2022-06-02T09:33:29.19+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(172.8, 13%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
saurabh khandelwal
1
Reputation point
commented 2022-06-09T19:20:54.367+00:00
Oury Ba-MSFT
16,391
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Duplicate records is populating
Hi All, I am joining 2 table Date and Holiday Table using Date columns in the tables.my requirement is to populating Indicator in single row where there is common date of specific region. I am using Case statement to fetech data into…
![](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, 3%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
2 answers
Does "Azure SQL Managed Instance" support publication distribution of transactional replication?
Hi, I want to implement transactional replication on a database which should be on "Azure SQL Managed Instance", where entry will be done. And the subscriber which will be read only and will be "on premises" (that is with our site…
asked 2022-04-27T07:15:39.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(291.2, 75%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERY%3C/text%3E%3C/svg%3E)
rajesh yadav
171
Reputation points
answered 2022-04-27T07:57:34.877+00:00
Olaf Helper
40,901
Reputation points
2 answers
Extracting Information from an XML field
Hello, Recently we have received a lot of data in XML format and we would like to store the XML data the way they are in an ODBC database. We are thinking perhaps it will be easier if we create a table that has all the XML data as a data field in there…
asked 2022-04-25T15:55:56.11+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, 61%, 21%)' 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)
ethanBRAC
1
Reputation point
commented 2022-04-25T21:43:29.697+00:00
Erland Sommarskog
101.4K
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
Azure SQL Managed Instance PREDICT with an ONNX model
I repeat the example from https://learn.microsoft.com/en-us/azure/azure-sql-edge/deploy-onnx "Deploy and make predictions with an ONNX model and SQL machine learning" In this quickstart, you'll learn how to train a model, convert it to ONNX,…
asked 2022-04-20T13:14:26.51+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(198.4, 63%, 29%)' 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)
Агарков Константин
26
Reputation points
commented 2022-04-21T13:04:15.543+00:00
Alberto Morillo
32,891
Reputation points MVP
2 answers
Starting SQL Server in Azure with Single user mode
Hi All, Is there a way to start SQL Server in Azure with single user mode with instance not being a VM ?. The sysadmin access is lost and need to get back in. Would the same instructions on a regular instance apply to Azure SQL Server ? Thanks.
asked 2022-02-09T21:25:46.223+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, 57.99999999999999%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Calvin Delaney
1
Reputation point
answered 2022-03-16T13:29:11.693+00:00
Bjoern Peters
8,781
Reputation points
1 answer
Azure Data Studio on Mac
Hi, I have only just started using AZURE DATA STUDIO on a Mac - I absolutely love it as it connects to SQL inside DOCKER But unlike SSMS - it does not seem to have Query and View Designer. I thought I had Query Designer working on AZURE but…
asked 2022-02-16T22:06:05.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(208, 57.99999999999999%, 30%)' 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)
JohnM
1
Reputation point
answered 2022-02-17T05:39:48.86+00:00
Vaibhav Chaudhari
38,601
Reputation points
1 answer
Azure Iot Edge - System.Data.SqlClient is not supported on this platform
Hi everyone, I am currently trying to deploy a SQL Server module to store data on a device running Azure IoT Edge with Linux container following the official tutorial…
asked 2021-12-08T10:25:41.233+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, 89%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DataSciencentist2021
141
Reputation points
commented 2021-12-29T12:16:00.973+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, 74%, 30%)' 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)
AshokPeddakotla-MSFT
27,491
Reputation points
1 answer
One of the answers was accepted by the question author.
How to create datastream from SQL server on IoT Edge device to IoT Hub?
Hi everyone, I just created a SQL Server on my UP squared running Debian 11 (Bullseye) to store data following the official tutorial (https://learn.microsoft.com/en-us/azure/iot-edge/tutorial-store-data-sql-server?view=iotedge-2020-11). The data is…
asked 2021-12-21T18:30:55.193+00:00
DataSciencentist2021
141
Reputation points
commented 2021-12-25T15:27:42.963+00:00
DataSciencentist2021
141
Reputation points
2 answers
Azure Sql external table column length issue
I have csv file in data lake with text Column length 6000, I have to create an external table in azure sql to read the csv file data. While creating external table, nvarchar(max) / varchar( max) are not allowed in external table and I can define column…
asked 2021-12-21T11:43:07.363+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, 96%, 21%)' 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)
Sriram M
1
Reputation point
answered 2021-12-21T16:08:24.56+00:00
Alberto Morillo
32,891
Reputation points MVP
0 answers
How to Decrypt data from Azure SQL Database with feature of Always Encrypted Enabled in JMeter
Hi Team, Good day How to Decrypt data from the Azure SQL Database with feature of Always Encrypted Enabled in JMeter by using Chrome browser
asked 2021-11-19T07:08:09.737+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, 9%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RKG
1
Reputation point
commented 2021-11-29T20:40:13.377+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(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma
23,751
Reputation points Microsoft Employee
0 answers
Join different table columns into one using Azure SQL
Dear All, Good Day! I need your help in below scenario in Azure SQL. I would like to join 3 tables data into 1 table with getting columns value as shown below, Hope you could help me. Looking forward for it. Thank you in advance.…
asked 2021-11-16T06:55:10.5+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, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Abhishek Jaiswal
41
Reputation points
commented 2021-11-16T18:37:05.01+00:00
Jeff McCashland
476
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure SQL sync failed due to snapshot isolation in other azure database in other region
Having issues with the above. Error Message reads ; Sync failed with the exception "SqlException ID: 7ed05768-c403-4de2-82a6-9786fc4d2db1, Error Code: -2146232060 - SqlError Number:3952, Message: Snapshot isolation transaction failed…
asked 2021-10-21T02:12:29.913+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(12.8, 44%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
peter
26
Reputation points
commented 2021-10-22T23:24:34.043+00:00
Alberto Morillo
32,891
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
why we can't use azure sql database for product catalog data ?
Question is about choosing a database for product catalog data.
asked 2021-10-20T16:46:27.937+00:00
Sonali Hanumant Satpute
101
Reputation points
accepted 2021-10-20T16:53:14.197+00:00
Sonali Hanumant Satpute
101
Reputation points
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
1 answer
One of the answers was accepted by the question author.
JDBC Connection issue to Azure SQL Database
I am trying to connect my Azure SQL database to my Android App on Android Studio, but there seems to be a problem from the client side not being able to form a connection. Initially I was using jtds-1.3.1.jar for the driver, but then I read somewhere…
asked 2021-08-09T14:08:59.033+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(224.00000000000003, 27%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGJ%3C/text%3E%3C/svg%3E)
ghazzal jastaniah
51
Reputation points
accepted 2021-08-15T11:55:41.16+00:00
ghazzal jastaniah
51
Reputation points
0 answers
Sql express or compact to save data.!?
Hey everyone .. I need help please in visual studio 2019. I'm doing POS application for small business that i really don't need no database services Or dealing with connection strings.. I just need to have portable database that is going to be…
asked 2021-06-23T16:23:26.233+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, 87%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHA%3C/text%3E%3C/svg%3E)
hamed algazaly
106
Reputation points
commented 2021-06-29T17:42:35.023+00:00
Oury Ba-MSFT
16,391
Reputation points Microsoft Employee
2 answers
Is Azure internal traffic encrypted where HTTPS is not specified?
For example, a web app or function to PLS to private endpoint, to another subnet with a private endpoint to PLS to a storage account, ADLS, or a SQL DB? What if the storage account requires HTTPS? Where is that encryption handled?
asked 2021-05-19T16:05:10.727+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(240, 99%, 33%)' 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)
Rosic, Andrej
1
Reputation point
answered 2021-06-01T15:18:52.523+00:00
msrini-MSFT
9,256
Reputation points Microsoft Employee