45 questions with Azure SQL Edge tags

Sort by: Updated
1 answer One of the answers was accepted by the question author.

Can't use Azure Sql Edge backup due to it being version 964.

Is there any way to restore an Azure SQL Edge database anywhere other than on Azure SQL Edge? I have the latest CUs on SQL Server Express and LocalDB, but it still wouldn't take an Azure SQL Edge backup. Here is the…

Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,675 questions
asked 2024-01-22T13:02:28.3466667+00:00
Victor Irzak 20 Reputation points
accepted 2024-01-22T21:28:19.1366667+00:00
Victor Irzak 20 Reputation points
8 answers

SQL Server install error Wait on the Database Engine Recovery Handle Failed

SQL Server 2019 install error Wait on the Database Engine Recovery Handle Failed this error is coming and i have tried everything on the internet to solve this but it still isnt installing can anyone tell me how to remove this error

Azure SQL Database
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,675 questions
asked 2021-07-28T10:27:04.27+00:00
Priyanshu Singh 31 Reputation points
commented 2024-01-05T17:53:47.0266667+00:00
Gabriela Wanat 0 Reputation points
2 answers

How to fix power function issue while changing db compatibility level change

We are using sql server 2019 server with db 110 compatability. Currently we are changing the DB compatability level from 110 to 150.After changing the compatability level to 150 , we have noticed the breakage there in the power of function and its…

Azure SQL Database
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,675 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
493 questions
asked 2023-09-11T07:43:28.2133333+00:00
narmatha pitchaimani 0 Reputation points
edited the question 2023-10-16T15:57:34.4133333+00:00
GeethaThatipatri-MSFT 27,017 Reputation points Microsoft Employee
1 answer

Connecting to Azure SQL Edge (local docker instance) from another network machine

Hi I have a local instance of Azure SQL edge running (using docker on MacBook). I am trying to connect to the server, with using pyodbc (in google colab), but i keep getting this error: I already followed this document:…

Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
asked 2023-09-27T00:00:40.93+00:00
Sunraj sharma 65 Reputation points
answered 2023-09-27T08:51:39.3366667+00:00
ShaktiSingh-MSFT 13,271 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Trying to install and run Azure SQL Edge on Docker on Mac (intel). Runs for a few seconds and then stops.

Overview I am trying to install and run SQL server from Docker. It runs for a few seconds and then exits with a code of 255. I am trying to install Azure SQL edge on Macbook running on intel. Commands I ran to install the image sudo docker pull…

Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
asked 2023-09-23T18:02:21.3366667+00:00
Sunraj sharma 65 Reputation points
commented 2023-09-25T23:18:16.2133333+00:00
Sunraj sharma 65 Reputation points
1 answer

How can I install sql sync agent in a Ubuntu environment?

I am trying to set up azure sql edge device . I also have an Azure SQL database set up in the cloud. I want to synchronize data from sql edge to sql database in the cloud. For that, I was trying to create a sync group and install sql sync agent in Azure…

Azure SQL Database
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
asked 2023-09-20T11:19:49.71+00:00
Anura Adhikari 0 Reputation points
edited an answer 2023-09-21T12:49:33.4666667+00:00
Alberto Morillo 32,886 Reputation points MVP
3 answers

alternative to store procedure

Hi Expert, do we have any alternative to store procedure while running merge statement where we can use exec or run like exec sp_name can we use view instead of any table to something else Regards

Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,675 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
493 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,243 questions
asked 2023-09-14T13:26:11.2666667+00:00
Shambhu Rai 1,406 Reputation points
edited a comment 2023-09-15T10:25:28.9566667+00:00
Shambhu Rai 1,406 Reputation points
1 answer One of the answers was accepted by the question author.

temp table parameters

Hi Expert, unable to understand the below query can someone explain me what is happening in below query CREATE PROCEDURE [dbo].[THINKNEW] @CurrentVersion BIGINT, @LastVersion BIGINT AS BEGIN IF…

Azure SQL Database
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,675 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
asked 2023-09-08T18:02:32.0833333+00:00
Shambhu Rai 1,406 Reputation points
accepted 2023-09-08T23:08:09.0166667+00:00
Shambhu Rai 1,406 Reputation points
4 answers One of the answers was accepted by the question author.

; in MSSQL

"When I give only a semicolon (;) in a query, I am getting the message 'Commands completed successfully.' Are there any other symbols that can give the same result?"

Azure SQL Database
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,675 questions
asked 2023-06-12T05:27:30.4933333+00:00
Raguram Manokaran 80 Reputation points
accepted 2023-07-27T05:36:50.6933333+00:00
Raguram Manokaran 80 Reputation points
1 answer

Docker / Azure Data Studio - What am I doing wrong?

Mac OS Monterey, 12.5.1 I installed Docker on 10/19 from your website. downloaded the Azure SQL Edge image using the terminal command docker pull mcr.microsoft.com/azure-sql-edge. I then downloaded Azure Data Studio. Then ran the terminal…

Azure SQL Database
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
asked 2022-10-24T02:29:13.127+00:00
S John 11 Reputation points
commented 2023-07-17T17:23:20.7633333+00:00
Oury Ba-MSFT 16,076 Reputation points Microsoft Employee
1 answer

Unable to backup new sql server instance databases on azure portal

Hi Team, We have sql server installed on a windows machine, we have already three instances there and we have scheduled the backup on azure portal and was running fine. After adding a new instance on sql server we are unable to schedule its backup on…

Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,101 questions
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
Azure Policy
Azure Policy
An Azure service that is used to implement corporate governance and standards at scale for Azure resources.
790 questions
asked 2023-06-27T06:17:22.6033333+00:00
Nitin Goyal 5 Reputation points
answered 2023-06-27T07:53:28.8466667+00:00
Chathura Munasinghe 165 Reputation points
1 answer One of the answers was accepted by the question author.

Securing access to the Azure SQL Server Database via SSMS using Privatelink ?

My company already using the Azure Express route circuit to allow secure and quicker data access across the WAN. I am trying to secure access to my SQL database in Azure from my user laptop across the globe. Turn off the Public Endpoint for all SQL…

SQL Server on Azure Virtual Machines
Azure SQL Database
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,136 questions
Azure Network Watcher
Azure Network Watcher
An Azure service that is used to monitor, diagnose, and gain insights into network performance and health.
157 questions
asked 2023-06-14T05:32:57.09+00:00
EnterpriseArchitect 4,721 Reputation points
accepted 2023-06-14T12:45:58.6366667+00:00
EnterpriseArchitect 4,721 Reputation points
1 answer

Issue in running AzureSQLEdge module on IoT Edge Device

Hi Team, As part of my research, I have deployed AzureSQLEdge module from Marketplace.It was running earlier.But now seems to be faile due to the below exception 2023-05-11 09:56:45.81 spid9s      Starting up database 'msdb'. 2023-05-11 09:56:45.82…

Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
asked 2023-05-11T10:50:05.8333333+00:00
Athira Gopinath(UST,IN) 96 Reputation points
answered 2023-05-16T01:54:31.62+00:00
LeelaRajeshSayana-MSFT 13,456 Reputation points
1 answer

Azure SQL Edge - Docker - Macbook M1 - Error occurred during the pre-login handshake

After update Macbook M1 to Monterey 12.5.1 the following error started happening: Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login…

Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
asked 2022-08-24T02:37:45.13+00:00
MATTHEUS PIROVANI 6 Reputation points
edited the question 2023-01-25T19:19:39.0633333+00:00
Oury Ba-MSFT 16,076 Reputation points Microsoft Employee
1 answer

Query related to sync between Azure SQL Edge database and Azure SQL database

Hi Team, Objective of this work is to implement a hybrid Cloud-Edge application model where we need to sync the Azure SQL Edge database and Azure SQL database. For that purpose, we followed this "https://learn.microsoft…

Azure SQL Database
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
asked 2022-12-06T07:54:28.9+00:00
Athira Gopinath(UST,IN) 96 Reputation points
commented 2022-12-19T05:04:05.787+00:00
Athira Gopinath(UST,IN) 96 Reputation points
2 answers One of the answers was accepted by the question author.

I tried to restore a database by Azure SQL Edge docker on Mac M1, I got "Database size would exceed license limitation" error.

Is there full version of Azure SQL edge docker for ARM? How can I restore the database on ARM (mac) system? I got the following error when I tried to restore a sql server database by Azure SQL edge container on MAC os M1 max. If it could be restored,…

Azure SQL Database
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
asked 2022-12-09T18:04:22.293+00:00
woodymoo 256 Reputation points
commented 2022-12-14T23:42:09.03+00:00
GeethaThatipatri-MSFT 27,017 Reputation points Microsoft Employee
0 answers

Mac M1 running MS SQL on Docker, unable to connect from Azure Data Studio

Hi, I'm facing some problems on my M1 Macbook when I try to connect to a MS SQL instance on Docker from Azure Data Studio. This is the verbose log I got from Azure Data Studio: Microsoft.Data.SqlClient.SqlException (0x80131904): A connection…

Azure SQL Database
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
asked 2022-12-05T02:21:30.967+00:00
Douglas Antoniazi 6 Reputation points
commented 2022-12-06T05:11:09.283+00:00
ShaktiSingh-MSFT 13,271 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Refresh DEV Azure SQL DB from PROD Azure DB backup

Hi Team, What is the procedure to Refresh DEV Azure SQL DB from PROD (Backup). We don't want to take a new DB backup. Only planning to use an available backup.

Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
asked 2022-02-14T20:14:40.06+00:00
Vijay Kumar 2,016 Reputation points
accepted 2022-11-26T00:11:05.92+00:00
Vijay Kumar 2,016 Reputation points
2 answers One of the answers was accepted by the question author.

how can i set alias dynamically to all the columns.

table 1 name age id address ksah 22 43 goa nora 20 01 vegas brad 31 32 gakww as (after query : [select *(using asterisk for all columns) AS "col" from table 1;]) col col col col …

Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,675 questions
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,796 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
asked 2022-10-28T11:56:25.213+00:00
kkmyghty 41 Reputation points
commented 2022-10-31T21:15:23.167+00:00
Erland Sommarskog 100.9K Reputation points MVP
14 answers One of the answers was accepted by the question author.

Azure SQL Edge on Mac M1 using Docker

Hello I know there are multiple threads with a similar issue, however, nothing helped me so far. Issue: unable to access the SQL Server : azure-sql-edge on Docker in Mac M1 ARM64. SQL Server is working as expected I believe. YAML: password added as a…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,356 questions
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
asked 2022-03-02T09:58:09.993+00:00
Rajith Alwis 21 Reputation points
commented 2022-10-19T14:21:05.903+00:00
GeethaThatipatri-MSFT 27,017 Reputation points Microsoft Employee