5,400 questions with Azure SQL Database tags

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

unique column in table

HI, merging table1 in table2 merge into table2 using table1 on table.col1=table2.col1 when not match then insert how to add unique column with auto increament number and not null in table like uniquenumner; Name;' 001 Test1 003 …

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,307 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,597 questions
asked 2024-07-06T02:21:59.06+00:00
Vineet S 425 Reputation points
edited the question 2024-07-08T03:38:42.9333333+00:00
ShaktiSingh-MSFT 14,376 Reputation points Microsoft Employee
0 answers

OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')

Hi, I am encountering an issue while trying to connect to an SQL database using a Python script in my Jupyter notebook. The connection attempt results in the following error message: OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL…

SQL Server on Azure Virtual Machines
Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,307 questions
asked 2024-07-05T06:27:34.9366667+00:00
Tú Nguyễn 65 Reputation points
commented 2024-07-08T02:03:55.24+00:00
Tú Nguyễn 65 Reputation points
1 answer

Cannot create and start Extended Events session in Azure SQL Managed Instance

Hello, I am trying to create an Extended Events session in Azure SQL Managed Instance. First I am trying to use SSMS GUI: Extended Events -> Sessions -> New Session... Add "error_reported" event, configure fields, select Data Storage as…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,307 questions
asked 2024-06-24T15:08:42.51+00:00
Aleksey Vitsko 20 Reputation points
commented 2024-07-05T15:27:27.5966667+00:00
Aleksey Vitsko 20 Reputation points
1 answer

Get the full list of Defender sub assessments given an assessment?

We have multiple subscriptions with hundreds of different Azure resource types. I would like to work to remediate the assessments and sub assessments found on the sql server, Azure SQL and Azure SQL MI. The portal shows about 2K sub assessments on the…

Azure SQL Database
Microsoft Defender for Cloud
Microsoft Defender for Cloud
An Azure service that provides threat protection for workloads running in Azure, on-premises, and in other clouds. Previously known as Azure Security Center and Azure Defender.
1,263 questions
asked 2024-07-01T00:07:01.5966667+00:00
Nguyen, Hoa 341 Reputation points
commented 2024-07-05T13:48:08.7066667+00:00
Nguyen, Hoa 341 Reputation points
2 answers

Azure SQL Ongoing operations cancel

I tried to export Azure SQL database and that got stuck for several hours in 1%. After that I cancelled export process with Powershell and now it's stuck for cancel in progress... I have tried to scale database but that didn’t do anything. What…

Azure SQL Database
asked 2022-03-29T18:35:42.133+00:00
ronis 16 Reputation points
commented 2024-07-05T09:14:07.6233333+00:00
Doshi, Shlok 0 Reputation points
1 answer

Table performance in azure SQL database

We have a azure DWH table of around 60TB, with daily load of around 1GB of data, what would be the best approach to apply data retention policy on the table and improve performance of table at the same time.

Azure SQL Database
asked 2024-07-02T17:20:01.2366667+00:00
NIKHIL KUMAR 101 Reputation points
commented 2024-07-03T22:26:24.0566667+00:00
Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
0 answers

Azure Application Gateway Preview feature (TCP/TLS Proxy) and Azure SQL

Hello I was just wondering if anyone has attempted to use the preview feature for Azure Application Gateway to support layer 4 proxying. (https://learn.microsoft.com/en-us/azure/application-gateway/tcp-tls-proxy-overview) with an Azure SQL instance as…

Azure SQL Database
Azure Application Gateway
Azure Application Gateway
An Azure service that provides a platform-managed, scalable, and highly available application delivery controller as a service.
1,008 questions
asked 2024-06-07T18:42:08.03+00:00
Jorge Rodriguez 0 Reputation points
commented 2024-07-03T10:37:50.08+00:00
GitaraniSharma-MSFT 49,386 Reputation points Microsoft Employee
2 answers

Unable to delete Azure SQL DB, logs display Internal Server Error

I recently created a MSSQL server, which I was trying to move to an elastic pool. In between I initiated the deletion of the database, I received the notification for successful deletion, however, the database is still present. I checked the Activity…

Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,072 questions
asked 2024-07-01T19:44:58.8566667+00:00
Mahesh Jaganiya 0 Reputation points
commented 2024-07-03T10:02:18.7933333+00:00
Erland Sommarskog 106.3K Reputation points
7 answers One of the answers was accepted by the question author.

Microsoft SQL Server Studio - Dark Mode

Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?

Azure SQL Database
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,866 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.
13,307 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,597 questions
asked 2023-12-19T13:11:52.4966667+00:00
Kıvanç ÖZDEMİR 130 Reputation points
commented 2024-07-03T04:42:42.13+00:00
Harsh Sugandhi 0 Reputation points
1 answer One of the answers was accepted by the question author.

How do I give a user access to a single App Server, SQL Database, & Azure Storage

Hi; I want to have my QA team do some load testing of the dev slot of our web app. I want to give them full administrative access to the dev slot app service and its associated SQL Database and BLOB Storage. I do not want them to have any administrative…

Azure SQL Database
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,612 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,348 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
239 questions
asked 2024-05-31T22:32:34.61+00:00
David Thielen 2,776 Reputation points
edited the question 2024-07-03T04:21:15.9266667+00:00
Ryan Hill 26,951 Reputation points Microsoft Employee
1 answer

Azure Management Instance Business Critical

Hi people, I have two questions about SQL Management Instance Business Critical. 1 - When I activate Zone Redundancy, I can't select which redundancy zone I want one of the nodes to be in? 2 - When I have zone redundancy in a failover with Business…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,307 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
239 questions
asked 2024-05-08T19:12:41.2266667+00:00
Emerson Sousa 0 Reputation points
edited the question 2024-07-03T04:18:26.9666667+00:00
Ryan Hill 26,951 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Can Azure SQL Database be set to auto scale up?

Hi all; Once I take my system live, I have the SQL Database set to Standard, 10 DTUs, 2GB. Is there a way I can have it scale up/down as needed depending on demand? My application at first should be hitting the database with 0 - 100 queries/minute. With…

Azure SQL Database
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
239 questions
asked 2024-04-01T11:33:50.74+00:00
David Thielen 2,776 Reputation points
edited the question 2024-07-03T04:14:56.14+00:00
Ryan Hill 26,951 Reputation points Microsoft Employee
1 answer

how to fix an issue where records are not syncing from Dataverse to Azure Database intermittently?

Successfully generated a summary I am experiencing an issue where records are not syncing from Dataverse to Azure Database intermittently, specifically for the Payment (evx_payment) entity. The affected records only sync when the customer manually…

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,667 questions
Microsoft Dataverse Training
Microsoft Dataverse Training
Microsoft Dataverse: A Microsoft service that enables secure storage and management of data used by business apps. Previously known as Common Data Service.Training: Instruction to develop new skills.
17 questions
asked 2024-07-02T21:16:35.34+00:00
Gustavo Mercado (LTIMINDTREE LIMITED) 20 Reputation points Microsoft Vendor
answered 2024-07-02T23:33:25.1+00:00
Gustavo Mercado (LTIMINDTREE LIMITED) 20 Reputation points Microsoft Vendor
2 answers

How do I back up a SQL database to Azure from Microsoft SQL Server Management Studio

I don't have access to the Azure portal to do it from that instance. I need to migrate the database to another server

Azure Database Migration service
Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,307 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.
515 questions
asked 2024-06-19T21:08:18.42+00:00
Sergio Sanchez 0 Reputation points
commented 2024-07-02T19:50:43.9666667+00:00
Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
1 answer

Azure SQL Database Delete issue

Hi Azure Support Team, I am encountering an issue where a SQL database that I deleted reappeared and caused unexpected high costs on our Azure account. Background: On June 11, my boss asked me to review our Azure bill and remove any unnecessary…

Azure SQL Database
Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,329 questions
asked 2024-07-02T06:04:57.22+00:00
Mert Yacan 0 Reputation points
commented 2024-07-02T19:44:29.9566667+00:00
Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
1 answer

Can we create elastic jobs from data base other than the host DB?

I have an elastic job agent setup on database X. I want to create jobs but from a different database. Right now I am getting SQL Error [2812] [S0062]: Could not find stored procedure 'jobs.sp_add_target_group'. Error position: Can someone help/ advice…

Azure SQL Database
asked 2024-07-01T10:20:18.16+00:00
Ayush Shrivastava 0 Reputation points
commented 2024-07-02T18:42:46.66+00:00
Amira Bedhiafi 19,616 Reputation points
1 answer One of the answers was accepted by the question author.

any posiblility to restore sql backup from more than 7 days?

I didn't set up backup and now I want to restore the database that is more than 2 weeks old. Do I have any chance to recover that database or did I lose the changes permanently?

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,186 questions
Azure SQL Database
asked 2024-07-02T08:11:50.0533333+00:00
ACConsultor 20 Reputation points
accepted 2024-07-02T09:07:53.93+00:00
ACConsultor 20 Reputation points
1 answer

Issue Creating Azure MySQL Database

Hello, I am encountering an issue while trying to create an Azure MySQL database for my university assignment. I have created a new resource group named "students-rg" and attempted to set up an Azure Database for MySQL server. However, I…

Azure SQL Database
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2024-06-30T04:39:24.6433333+00:00
Sanjula De Alwis 0 Reputation points
commented 2024-07-02T07:48:20.9233333+00:00
ShaktiSingh-MSFT 14,376 Reputation points Microsoft Employee
2 answers

Azure for Students Subscription - Unable to create Azure Database for MySQL Flexible Server

I have been attempting to create a Azure Database for MySQL Flexible Server for my assignment but I am unable to do so due to the below error. I have tried multiple regions but I am unable to get a successful deployment. "code":…

Azure SQL Database
asked 2024-07-01T17:50:31.62+00:00
Miguel Zepeda 0 Reputation points
answered 2024-07-01T21:40:13.8266667+00:00
Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
1 answer

Custom logs for SQL databases running on Azure VM

Hi , I would like to capture the databases health and some other basic SQL databases configuration related to health and send them to Log analytics agent . This is specific to SQL Databases running on Azure SQL VM . What would be right approach to push…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,307 questions
asked 2024-06-26T06:51:51.8433333+00:00
Nikhil Verma 40 Reputation points
commented 2024-07-01T20:28:19.09+00:00
Oury Ba-MSFT 17,791 Reputation points Microsoft Employee