Azure SQL Database
An Azure relational database service.
5,175 questions
2 answers
How to became Microsoft Certified Data Scientist?
What are the steps to become a certified data scientist? What are the requirements for becoming a certified data scientist? What are the benefits of becoming a certified data scientist? What are the different data science certifications available? …
asked 2023-05-17T05:51:12.27+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, 90%, 24%)' 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)
somanath khadanga
20
Reputation points
edited the question 2023-06-12T10:19:22.01+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, 38%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWM%3C/text%3E%3C/svg%3E)
Wajeed-MSFT
231
Reputation points Microsoft Employee
4 answers
Latest AzureDataStudio doesn't work anymore with AzureAD - Accounts with no eMails :(
Hello I'm completely stuck :( In my company, to connect AzureSQL, we use specific AD accounts with no eMail with MFA but since last AzDataStudio upgrade i cannot connect anymore :( we tried to add "Other emails" but same issue :( :( If you…
asked 2023-05-25T21:05:31.5566667+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, 55.00000000000001%, 24%)' 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)
Leopold
5
Reputation points
commented 2023-06-06T04:26:40.5333333+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(220.8, 4%, 31%)' 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)
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
1 answer
Azure Data Studio not showing system views
I have recently started using Azure Data Studio as well as SSMS. If I connect to a database in SSMS and go to the object explorer under views there is a system views folder that I can browse. If I connect to the same database in Azure Data Studio using…
asked 2023-06-03T05:05:13.9033333+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(307.2, 55.00000000000001%, 39%)' 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)
Joe
0
Reputation points
commented 2023-06-05T23:04:55.26+00:00
GeethaThatipatri-MSFT
27,722
Reputation points Microsoft Employee
1 answer
How to connect my server in microsoft Azure to data studio in mac
Hello, im trying to learn SQL in mac, using azure, data studio and docker. i've made the server in Azure but cant connect it to my data studio, what am i missing ? what is the proper step to do it ? thanks
asked 2023-05-30T10:37:55.0533333+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(89.60000000000001, 98%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIM%3C/text%3E%3C/svg%3E)
IRWAN MARZUAN
0
Reputation points
commented 2023-06-01T11:18:56.53+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
0 answers
asked 2023-05-31T04:17:04.15+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(272, 71%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFS%3C/text%3E%3C/svg%3E)
Fernanda Sánchez Gutiérrez
0
Reputation points
commented 2023-06-01T00:20:52.7933333+00:00
GeethaThatipatri-MSFT
27,722
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
[Data Studio] Table Designer Error
I am currently using Azure Data Studio to design my database. Every hour, i receive a message that reads: Table Designer Error: An error occurred while generating preview report: Validation failed with the following errors. . Error 1: The target database…
asked 2023-05-16T13:17:58.1533333+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(89.60000000000001, 94%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jess Boozell
20
Reputation points
commented 2023-05-31T01:15:32.5766667+00:00
Jess Boozell
20
Reputation points
3 answers
Azure Data Studio Error Deploy dacpac
Dear Expert, I plan migration from on-premise SQL Server Express 2014 to Azure SQL Server. I extract DACPAC using SQL Server Object Explorer from Visual Studio 2022. and I want deploy into Azure SQL Server, I using Azure Data Studio. during extract…
asked 2023-05-15T01:20:14.4+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, 95%, 39%)' 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)
Kelvin Shee
1
Reputation point
commented 2023-05-17T09:26:29.6666667+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
1 answer
Microsoft Account members are not allowed (as admin in Azure DB)
Hello! I want to set up AAD connection to my Azure DB in Azure Data Studio, but i have an error: "Login failed for user '<token-identified principal>'." Aftersome ivestigations i found the article:…
asked 2023-05-01T20:52:50.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(198.4, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIZ%3C/text%3E%3C/svg%3E)
ivan zhukov
10
Reputation points
commented 2023-05-09T04:06:38.32+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
2 answers
Azure Data Migration Error 22300 when attempting to connect to Azure Sql Db
Trying to use Azure Sql Migration to migrate a localdb to an Azure Sql Db. Credentials for both are solid. The user logged into the localdb ("sync_migration") has both db_owner database ownership and has been granted Alter permissions. The…
asked 2023-04-28T19:39:14.94+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, 36%, 18%)' 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)
Jason
0
Reputation points
commented 2023-05-04T15:44:18.06+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
1 answer
Azure Data Studio on Mac Just Spins but Works on Windows
All latest versions on Mac fail to connect with a new or edited connection, but the latest Windows version works fine. The most recent installed on local laptop that fails is: 1.42.0 (Universal) ADS in Windows connects immediately with the same…
asked 2023-03-28T20:59:28.5333333+00:00
Jared Heelis
0
Reputation points
commented 2023-04-28T06:12:36.7166667+00:00
PRADEEPCHEEKATLA-MSFT
78,576
Reputation points Microsoft Employee
2 answers
Azure Data Studio - Azure SQL Migration extension thinks the Managed Instance is still in 'Creating' state.
In step 3 of the Azure SQL Migration where the user chooses the managed instance: Error: The managed instance 'managedinstance' is unavailable for migration because it is currently in the 'Creating' state. To continue, select an available managed…
asked 2023-02-28T11:28:45.1133333+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, 31%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVV%3C/text%3E%3C/svg%3E)
Vlasopoulos V
5
Reputation points
commented 2023-04-25T06:09:09.31+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(124.80000000000001, 28.999999999999996%, 22%)' 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)
JoelP
241
Reputation points
0 answers
BIG DATA-PIG ERROR IN DUMP
I am getting pig error in dump
asked 2023-04-19T19:33:52.3933333+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(150.4, 53%, 24%)' 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)
Sridevi Murugan
0
Reputation points
commented 2023-04-20T06:04:46.6666667+00:00
PRADEEPCHEEKATLA-MSFT
78,576
Reputation points Microsoft Employee
1 answer
Error creating new user in SQL Database
I am trying to run the command: CREATE USER [new_user@mydomain.com] FROM EXTERNAL PROVIDER I get the error message: Msg 33159, Level 16, State 1, Line 1 Principal 'new_user@mydomain.com' could not be created. Only connections established with…
asked 2023-04-11T15:12:20.2366667+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, 54%, 29%)' 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)
Tim Wannier
0
Reputation points
commented 2023-04-19T16:14:50.0733333+00:00
Nandan Hegde
29,896
Reputation points MVP
0 answers
connecting azure data studio with docker issue on MacBook Air
I am getting this error message A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught)
asked 2023-04-10T22:46:43.91+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, 48%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOW%3C/text%3E%3C/svg%3E)
Opoku Wendy
0
Reputation points
commented 2023-04-13T05:33:46.2733333+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Migrate SQL tables with always encrypted column using Azure SQL Migration extension for Azure Data Studio
I am migrating an on-prem SQL database to Azure SQL Database, using tutorial in https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-database-offline-ads as guideline. At the end of migration, those tables containing Always Encrypted…
asked 2023-04-05T04:20:05.15+00:00
Chan Hui Kent
25
Reputation points
accepted 2023-04-10T09:18:36.66+00:00
Chan Hui Kent
25
Reputation points
3 answers
I want to use Azure SQL Migration with Data Studio, error i see is "[renderer1] [error] An unknown error occurred. Please consult the log for more details."
Hi, we are in a process to migrate a OnPremise SQL Server 2019 with Azure SQLData Studio. I have a default database "AdventureWorks2019" with a Full and Log Backup into a Azure Storage Blob. Backup of the database is fine, backup is…
asked 2023-03-27T14:46:54.4866667+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, 40%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Jürgen Barth
0
Reputation points
edited the question 2023-04-08T02:04:11.34+00:00
Sumarigo-MSFT
43,806
Reputation points Microsoft Employee
asked 2023-03-25T13:38:24.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(249.60000000000002, 75%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECO%3C/text%3E%3C/svg%3E)
Collins Okafor
0
Reputation points
commented 2023-03-30T19:25:37.6233333+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
looking to upload Adventureworksdw2019 to Azure SQL
Hello, What is the best way to upload the full AdventureWorksDW2019 to Azure SQL Database? I was looking at the Azure Data Studio Migration tool which I believe requires me to first create the schema on Azure SQL and then migrate? Is there a more direct…
asked 2023-03-07T16:25:52.84+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(128, 8%, 22%)' 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)
Anonymous
edited the question 2023-03-08T04:46:58.5733333+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(288, 47%, 37%)' 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)
AjayBathini-MSFT
40
Reputation points Microsoft Vendor
2 answers
how to import an Excel xlsx file into Azure Data Studio without converting it to a csv
hello I am trying to import an Excel Workbook(xlsx file) into Azure Data Studio. I have installed the SQL server importer which could only import txt or csv file but not the xlsx file. I would appreciate it if anyone could help with this. Thank you.
asked 2023-02-25T03:10:30.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(224.00000000000003, 96%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOA%3C/text%3E%3C/svg%3E)
Oluwafemi Ajibola
0
Reputation points
commented 2023-03-02T14:06:39.8933333+00:00
GeethaThatipatri-MSFT
27,722
Reputation points Microsoft Employee