Azure SQL Database
An Azure relational database service.
6,338 questions
3 answers
One of the answers was accepted by the question author.
SQL Database Pricing Model
I'm new to Azure and I wanna ask about their database pricing model specifically for SQL database service, my question is what is the difference between a DTU based database and a vCore database and will the customer still be charged for a DTU based…
Azure SQL Database
asked 2021-08-05T00:26:47.923+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(108.80000000000001, 47%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Audy Naufal Ghiffari
21
Reputation points
accepted 2021-08-06T02:01:12.777+00:00
Audy Naufal Ghiffari
21
Reputation points
2 answers
Azure sql database Machine learning
Hi Team, I would like to know, do we have an option to use Machine learning with Azure SQL database or is it only available with Azure SQL managed instance Thanks
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
3,340 questions
asked 2021-07-02T14:25:17.747+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(294.40000000000003, 35%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Anashwar N
46
Reputation points
commented 2021-08-05T23:58:03.227+00:00
Oury Ba-MSFT
20,931
Reputation points Microsoft Employee
Moderator
1 answer
How to move dataset from Azure Managed Instance to Azure SQL using SSIS with change data capture
How to move data from Azure Managed Instance to Azure SQL Database by using SSIS package with Change data capture feature in it? Please help me with links or documents
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
927 questions
asked 2021-07-01T08:08:14.403+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, 25%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Shubhi Jain
21
Reputation points
commented 2021-08-05T23:56:43.9+00:00
Oury Ba-MSFT
20,931
Reputation points Microsoft Employee
Moderator
2 answers
How to migrate from Azure db for Postgres to Azure SQL db?
I am currently migrating from postgres on prem to Azure postgres and in future might want to migrate to Azure SQL db from Azure postgresql db. What are the options available for this with minimal effort and downtime?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,435 questions
asked 2021-07-26T15:17:52+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, 8%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Manthan Patel
1
Reputation point
answered 2021-08-05T01:18:55.233+00:00
Alberto Morillo
34,676
Reputation points MVP
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
Azure SQL DB Georeplication - how do you create?
Hi, I was wondering if there is a simple step by step guide of how to create a georeplication backup (in another region) of our Azure SQL DB. Any help would be much appreciated. Thanks, Tony
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 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(25.6, 95%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
update a table with different values for two max records
Hi, I have the following table: CREATE TABLE bidba.anomaly_mon_store ( ds_time timestamp, alert_cont smallint ) and I want to update, preferably with one statement, the value of the aler_cont column with values of 1 and 2 according to…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-06-06T08:46:39.817+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, 93%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
dani shamir
81
Reputation points
accepted 2021-08-04T08:37:25.067+00:00
dani shamir
81
Reputation points
1 answer
Problem with publishing asp.net framework app to azure BadRequest 400
Hello, I created a database in azure sql database and connected it to my asp.net api with defaultconnection. I am using identity and my register function works fine on local machine, but after publishing to azure, i get 400 bad request without any…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,965 questions
asked 2021-08-03T14:13:00.477+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, 28.000000000000004%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Mikolaj Palacz
6
Reputation points
answered 2021-08-04T07:44:19.193+00:00
Mikolaj Palacz
6
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure SQL query does not work
Hi guys. I am a newcomer on Azure and tried to connect SQL DB. In database I can open the Query section but con not write a query. Can someone urgently help me?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-08-03T11:37:36.18+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, 75%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZM%3C/text%3E%3C/svg%3E)
Özkan, Murat
96
Reputation points
commented 2021-08-04T05:37:11.937+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,631
Reputation points
0 answers
Azure SQL Db Connection issue from .NET Core with Active Directory Password Authentication
Seeing below error while connecting to Azure SQL DB from .NET Core 3.1 with Active Dorectory Password Authentication. Microsoft.Data.SqlClient" Version is 2.1.3. Same is working fine in .NET Framework 4.7.2. Can you please suggest what is the…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-07-24T17:25:39.9+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(60.8, 59%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Ponugoti, Pradeep-XT
1
Reputation point
commented 2021-08-04T04:32:24.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(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,351
Reputation points
2 answers
Azure SQL DB Connection Timeout
My Azure SQL DB connection from local management studio used to work fine. But all of a sudden stopped with connection time out error. It is same network and machine, same settings. What could be the issue? Getting below error while trying to…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-08-01T17:39:31.26+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(76.8, 28.999999999999996%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Nanda Kishore Kapa
6
Reputation points
answered 2021-08-04T04:21:46.017+00:00
KalyanChanumolu-MSFT
8,351
Reputation points
1 answer
One of the answers was accepted by the question author.
Calculated field results in ssms are displayed incorrectly.
Hello First of all, I'm sorry I don't English very well.... my question I used a calculated field in SSMS. But the result is... How do I print the full calculation result?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
Developer technologies | Transact-SQL
4,707 questions
asked 2021-08-03T23:19:22.97+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(233.6, 25%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER2%3C/text%3E%3C/svg%3E)
Revelation 20 : 4
21
Reputation points
commented 2021-08-04T01:03:57.8+00:00
Revelation 20 : 4
21
Reputation points
1 answer
Query Error Message after Creating EXTERNAL DATA SOURCE In/from Azure SQL Database to Azure Synapse(formerly Azure SQL DWH)
I'm trying to query between databases. Using the following documentation : https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-get-started When I want to query the external table I created as below: CREATE DATABASE…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-07-23T05:55:59.553+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(102.4, 40%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Battula, Suchit
1
Reputation point
commented 2021-08-03T20:43:43.563+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,851
Reputation points Microsoft Employee
Moderator
3 answers
One of the answers was accepted by the question author.
Enable AD DS authentication for Azure SQL with OnPremise AD ?
People, How can I integrate and configure the Azure SQL so that I can grant access for the OnPremise Synched AD security group access and then enforce Azure AD MFA when login from SSMS ? There is no AD DS (OnPremise join command like described in…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
Microsoft Security | Microsoft Entra | Microsoft Entra ID
25,147 questions
Microsoft Security | Microsoft Entra | Other
2,597 questions
asked 2021-07-21T07:41:40.09+00:00
EnterpriseArchitect
6,041
Reputation points
commented 2021-08-03T18:26:58.247+00:00
Oury Ba-MSFT
20,931
Reputation points Microsoft Employee
Moderator
6 answers
How we can archive one year data in Azure SQL or SQL server
Hi All, i have 4 years of data in a single table in Azure SQL server. now i want to archive one year data so i show have only three years of data in my table i.e. if I have data for 2015,2016,2017,2018 then i need to archive data for 2015 so, I…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
Developer technologies | Transact-SQL
4,707 questions
SQL Server | Other
14,502 questions
asked 2021-07-23T12:12:38.07+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(262.40000000000003, 20%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
manish verma
516
Reputation points
answered 2021-08-03T17:27:39.363+00:00
Oury Ba-MSFT
20,931
Reputation points Microsoft Employee
Moderator
1 answer
Import Data Error
Hello, I'm trying to import these data: https://docs.google.com/spreadsheets/d/1ub_0Y5CEj2HtKO6bgb8OIvMIG81Wca0r_q8G70OKUTc/pub?gid=1709232748&single=true&output=csv from Course/Introduction to the Course/Homework #1 but somethink goes…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-07-30T07:07:32.82+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, 61%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZM%3C/text%3E%3C/svg%3E)
Zanella Marcello
1
Reputation point
commented 2021-08-03T07:13:13.883+00:00
Anurag Sharma
17,631
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Data Sync Agent key issues
Hi, I am in the process of testing options for a fleet of SQL services that would use Azure and on-premise databases. Having read some more into Azure Data Sync it would appear to be a useful solution to a couple of issues we are experiencing. …
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 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(57.599999999999994, 59%, 15%)' 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)
1 answer
One of the answers was accepted by the question author.
Using GitHub Actions How to get the details of commit ID,Respository name,Branch,Commit date and Commit Author to Azure SQL Database(looking for A process flow how can i do it)
Hi, I have created one table in Azure SQL Database with columns ( Commit ID, Repository name, Branch, Commit date and Commit Author) I am trying to use GitHub Actions to pull the data from GitHub to Azure SQL .Can someone please help on how to get the…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-07-21T07:39:25.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, 63%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Pulipati Vedanth
111
Reputation points
commented 2021-08-02T14:58:02.227+00:00
Pulipati Vedanth
111
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL VMs have databases that are not listed in SQL Databases blade
I'm a Global Admin on our Azure environment and I'm working with SQL VMs. I have two Azure SQL servers which are displayed in my SQL Virtual Machines blade but not my "SQL Databases" Blade. What's missing?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-07-21T14:56:34.197+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(70.4, 3%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFV%3C/text%3E%3C/svg%3E)
Frank VanDyke
121
Reputation points
commented 2021-08-02T12:59:40.767+00:00
Frank VanDyke
121
Reputation points
6 answers
One of the answers was accepted by the question author.
Getting A categorised Subquery in SQL
Please I need your assistance on using Categorized subquery in SQL. I have two tables (Underwriting_Policy_Schedule_Header) which stored the category headers while the second Table (Underwriting_Policy_Schedule) stored the header body. both are related…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 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.
3,064 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,344 questions
Developer technologies | Transact-SQL
4,707 questions
SQL Server | Other
14,502 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(12.8, 84%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
0 answers
Can Dynamics Data Export Service populate Azure SQL temporal tables?
We currently use a not-very-well-implemented combination of D365 Data Export Service (DES), Azure Data Factory pipelines and rather complex Azure SQL stored procedures to maintain a history schema in a DWH, of data sourced from Dynamics 365. Temporal…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,338 questions
asked 2021-07-30T14:52:23.107+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(64, 12%, 16%)' 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)
Simon Sellick
21
Reputation points
commented 2021-07-31T14:53:43.03+00:00
Saurabh Sharma
23,851
Reputation points Microsoft Employee
Moderator