Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
103 questions
1 answer
Filter Results in ADS does not work
Something weird with my ADS. I can't Filter or Sort Results after I complete query. Actually, I could filter only 100000 records. If my Results is more that 100000 it simply does not work. My simple query selects 150 K records of integer type. If I click…
asked 2024-01-27T13:33:47.25+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, 94%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Susja
716
Reputation points
answered 2024-01-30T06:00:36.23+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
14,081
Reputation points Microsoft Employee
1 answer
AZURE DATA STUDIO NOT SHOWING ALL ROWS AFFECTED IN A QUERY
I am using Azure Data Studio notebook to query an Azure database. On some of the queries, it will say that it runs 96 rows for example, but only shows 8. I run the same query in SSMS and it shows all 96 rows. What's going on here? The query size is not…
asked 2024-01-26T21:39:18.1833333+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(310.4, 75%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Younkin, Kyle
0
Reputation points
edited the question 2024-01-29T05:01:01.8466667+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(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
11,045
Reputation points Microsoft Vendor
0 answers
Unable to filter Results
Hello, I hit the issue when I can't filter out Results. In my case I have around 2,5 Millions records, When I click on arrow to filter the record it failed and throws the error I already increased Settings - Query Editor - Results ... Threshold till…
1 answer
How to improve performance with Azure Data Studios? SSMS on same computer/network is fine, but connection to Azure Data Studio is not usable.
We have been working to implement improvements to our workflow by migrating developers to use Azure Data Studios so we can utilize source control more seamlessly within our process. However, when we work to connect/complete actions within Azure Data…
asked 2024-01-15T23:07:21.76+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(256, 77%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Kyle Kew
0
Reputation points
edited an answer 2024-01-19T04:19:46.0733333+00:00
ShaktiSingh-MSFT
14,081
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Creating a database project versus Synapse SQL pool from scratch
Hi, I'd like to find a good and complete reference tutorial in order to create from scratch a database project versus a Synapse dedicated SQL pool and to check a my project in progress. I've Visual Studio 2022 and SSDT extension (I can use this tool or…
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,504 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,725 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
103 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(115.19999999999999, 41%, 21%)' 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)
2 answers
I have few confusion for SQL migration from OnPrem to Azure in between DMA/DMS/ Data studio & Azure Migrate
I have the below queries If Azure Migrate Readiness Report Recommend Onprem DB into Azure SQL Managed Instance & at onprem location, DMA was set up. In that case, is it required to set up Data Studio also at the on-prem location, as DMA does not…
asked 2024-01-14T08:24:18.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(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
answered 2024-01-16T09:41:44.89+00:00
ShaktiSingh-MSFT
14,081
Reputation points Microsoft Employee
1 answer
Azure Data Studio Notebook: Maximum Call Stack size Exceeded
I am using latest version of Azure Data Studio (1.47.0) to write notebooks and run queries against a sql database instance. When I try running two different cells I get the error: Maximum Call Stack size Exceeded. Is there a way to allow parallel…
asked 2024-01-02T09:40:29.8266667+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, 93%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPF%3C/text%3E%3C/svg%3E)
Pegoraro, Francesco
40
Reputation points
answered 2024-01-03T17:50:05.3666667+00:00
GeethaThatipatri-MSFT
28,142
Reputation points Microsoft Employee
5 answers
Connect to SQL Server Database Engine using SQL Server Authentication - error
Hi Microsoft Team, I am attempting to connect to our SQL Server 2019 database engine using SQL Server Management Studio (SSMS) 19.0.2, however I'm receiving the error message - Cannot connect to the server. When I use SQL Server Management Studio v18.10,…
asked 2023-04-28T22:05:45.2266667+00:00
Tahmid Bari
0
Reputation points
answered 2023-12-12T12:03:25.28+00:00
امنه محمد السيد على
0
Reputation points
1 answer
Login failed for user token-identified principal when trying to connect to my sql server from client
Seems like a straight forward installation from my azure portal. Created a sql service in AZURE. Downloaded Azure Data Studio on my client. Logged into my azure account. Tried to connect to the dB. "Login failed for user '
asked 2023-12-07T00:10:01.2633333+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(195.2, 93%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Tom Tully
20
Reputation points
answered 2023-12-07T05:05:38.12+00:00
ShaktiSingh-MSFT
14,081
Reputation points Microsoft Employee
1 answer
Best ptractices for remote employees to access Azure SQL from SSMS/Data Studio
So currently I have a test Azure SQL database setup. I setup up with public network access disabled. Today I changed it to "selected networks", and added my client's IP address so I could make sure that I could access the database from SSMS…
asked 2023-12-03T07:05:04.8233333+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, 90%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Max Baroi
0
Reputation points
commented 2023-12-03T23:42:13.12+00:00
Andreas Baumgarten
98,791
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Add Folder to Workspace issue
Hello, I am using ADS on macOS. I have a few drives that I mount after I login and connect to VPN. Then I add those drives to Workspace. E.g. my drives are A, B and C. In ADS Explorer I added it and I see A, D and C. Recently I started to see instead of…
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
474 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
103 questions
0 answers
Azure data studio will not bulk insert in UTF-8 encoding
Dear members, I am using the newest version of Azure Data Studio on Mac. I have tried bulk inserting UTF-8 encoded CSV file into a table. I have specified all columns as Varchar datatype, which is UTF-8 compatible. I also changed the collation of the…
asked 2023-11-26T19:00:32.81+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(252.8, 75%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Jan Alexandr Kopřiva
0
Reputation points
edited the question 2023-11-27T02:54:29.98+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
1 answer
One of the answers was accepted by the question author.
Shell script document language in ADS
Hello, I am using ADS on Windows and Mac. I wanted to write something in bash. I was looking for for tool that could help me with syntax and etc. I found VS Code extension ShellChecker. I installed it but it does not work as expected. The issue is that…
1 answer
One of the answers was accepted by the question author.
How to get rid of 'shell' notification ?
Hello, I'm using ADS on MacBook. My default terminal is bash. Every time I start a Terminal ... I have this warning message: -- The default interactive shell is now zsh. To update your account to use zsh, please run chsh -s /bin/zsh. For more details,…
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
474 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
103 questions
3 answers
One of the answers was accepted by the question author.
Configure ADS to open .pdf files automatically
Hello, I am using ADS on macOS. Sometimes I need to open .pdf files. My MacBook has Acrobat Reader and could handle these file types but my question is: could I configure ADS to open .pdf file automatically i.e. directly from Explorer ... like it opens…
asked 2023-10-14T19:55:23.7733333+00:00
Susja
716
Reputation points
edited an answer 2023-11-09T11:00:58.1833333+00:00
ShaktiSingh-MSFT
14,081
Reputation points Microsoft Employee
1 answer
Locate file in ADS
Hello, I have not a problem to locate a content of the file in particular directory, but I need to locate the file itself. Sure, I could do it from terminal, but I'd like to locate it from Workspace. E.g. I am looking for foo.c and know the folder where…
asked 2023-11-02T16:57:18.9166667+00:00
Susja
716
Reputation points
commented 2023-11-07T13:51:09.0233333+00:00
Erin Stellato
496
Reputation points Microsoft Employee
1 answer
SQL object decoration theme
I have problem to understand object decoration in ADS related to SQL queries. E.g. I am starting to write a query and see the list of options that I could select. Each of it has some decoration. I assume it depends on type of object. Don't you have in…
1 answer
One of the answers was accepted by the question author.
Unable to add account in Azure Data Studio
Getting the below error while trying to add account in azure data studio error.jpg
asked 2023-08-25T16:32:30.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(19.2, 61%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Bittu Bhowmick
30
Reputation points
commented 2023-11-06T16:48:19.88+00:00
Erin Stellato
496
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Files decoration in Explorer in ADS
Hello, I am using Azure Data Studio. I noticed that in Explorer Tab it lists files and files have different colors and different icons in front of it. I would like to know what those icons and colors mean. e.g. .pdf files have obvious icon in front of…
1 answer
Locate file in ADS
Hi, Sounds like very primitive ... but I can't figure it out. I could find 'content' in the file using Explorer, but I need to locate the file itself. Sure, I could do it from terminal ... but I'd like to locate it from Workspace. It should be simple way…
asked 2023-11-02T16:54:49.7733333+00:00
Susja
716
Reputation points
answered 2023-11-02T18:24:20.7266667+00:00
Vahid Ghafarpour
19,395
Reputation points