Azure Data Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.

Overview

Azure Data Studio

Join the chat at https://gitter.im/Microsoft/sqlopsstudio Build Status Twitter Follow

Azure Data Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.

Download the latest Azure Data Studio release

Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB

Go to our download page for more specific instructions.

Try out the latest insiders build from main:

See the change log for additional details of what's in this release. Go to our download page for more specific instructions.

Feature Highlights

  • Cross-Platform DB management for Windows, macOS and Linux with simple XCopy deployment
  • SQL Server Connection Management with Connection Dialog, Server Groups, Azure Integration and Registered Servers
  • Object Explorer supporting schema browsing and contextual command execution
  • T-SQL Query Editor with advanced coding features such as autosuggestions, error diagnostics, tooltips, formatting and peek definition
  • Query Results Viewer with advanced data grid supporting large result sets, export to JSON\CSV\Excel, query plan and charting
  • Management Dashboard supporting customizable widgets with drill-through actionable insights
  • Visual Data Editor that enables direct row insertion, update and deletion into tables
  • Backup and Restore dialogs that enables advanced customization and remote filesystem browsing, configured tasks can be executed or scripted
  • Task History window to view current task execution status, completion results with error messages and task T-SQL scripting
  • Scripting support to generate CREATE, SELECT, ALTER and DROP statements for database objects
  • Workspaces with full Git integration and Find In Files support to managing T-SQL script libraries
  • Modern light-weight shell with theming, user settings, full-screen support, integrated terminal and numerous other features

Here are some of these features in action.

Contributing

If you are interested in fixing issues and contributing directly to the code base, please see the document How to Contribute, which covers the following:

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

Localization

Azure Data Studio is localized into 10 languages: French, Italian, German, Spanish, Simplified Chinese, Traditional Chinese, Japanese, Korean, Russian, and Portuguese (Brazil). The language packs are available in the Extension Manager marketplace. Simply, search for the specific language using the extension marketplace and install. Once you install the selected language, Azure Data Studio will prompt you to restart with the new language.

Privacy Statement

The Microsoft Enterprise and Developer Privacy Statement describes the privacy statement of this software.

Contributions and "Thank You"

We would like to thank all our users who raised issues, and in particular the following users who helped contribute fixes:

  • eulercamposbarros for Prevent connections from moving on click (#7528)
  • AlexFsmn for Fixed issue where task icons got hidden if text was too long
  • jamesrod817 for Tempdb (#7022)
  • dzsquared for fix(snippets): ads parenthesis to sqlcreateindex snippet #7020
  • devmattrick for Update row count as updates are received #6642
  • mottykohn for In Message panel onclick scroll to line #6417
  • Stevoni for Corrected Keyboard Shortcut Execution Issue #5480
  • yamatoya for fix the format #4899
  • GeoffYoung for Fix sqlDropColumn description #4422
  • AlexFsmn for Added context menu for DBs in explorer view to backup & restore db. #2277
  • sadedil for Missing feature request: Save as XML #3729
  • gbritton1 for Removed reference to object explorer #3463
  • Tarig0 for Add Routine_Type to CreateStoredProc fixes #3257 (#3286)
  • oltruong for typo fix #3025'
  • Thomas-S-B for Removed unnecessary IErrorDetectionStrategy #749
  • Thomas-S-B for Simplified code #750
  • rdaniels6813 for Add query plan theme support #3031
  • Ruturaj123 for Fixed some typos and grammatical errors #3027
  • PromoFaux for Use emoji shortcodes in CONTRIBUTING.md instead of � #3009
  • ckaczor for Fix: DATETIMEOFFSET data types should be ISO formatted #714
  • hi-im-T0dd for Fixed sync issue with my forked master so this commit is correct #2948
  • hi-im-T0dd for Fixed when right clicking and selecting Manage-correct name displays #2794
  • philoushka for center the icon #2760
  • anthonypants for Typo #2775
  • kstolte for Fix Invalid Configuration in Launch.json #2789
  • kstolte for Fixing a reference to SQL Ops Studio #2788
  • AlexFsmn Feature: Ability to add connection name #2332
  • AlexFsmn Disabled connection name input when connecting to a server. #2566
  • SebastianPfliegel Added more saveAsCsv options #2099
  • ianychoi Fixes a typo: Mimunum -> Minimum #1994
  • AlexFsmn Fixed bug where proper file extension wasn't appended to the filename. #2151
  • AlexFsmn Added functionality for adding any file to import wizard #2329
  • AlexFsmn Fixed background issue when copying a chart to clipboard #2215
  • AlexFsmn Fixed problem where vertical charts didn't display labels correctly. #2263
  • AlexFsmn Fixed Initial values for charts to match visuals #2266
  • AlexFsmn Renamed chart option labels #2264
  • AlexFsmn Added feature for the opening file after exporting to CSV/XLS/JSON & query files #2216
  • AlexFsmm Get Connection String should copy to clipboard #2175
  • lanceklinger Fix for double-clicking column handle in results table #1504
  • westerncj for Removed duplicate contribution from README.md (#753)
  • ntovas for Fix for duplicate extensions shown in "Save File" dialog. (#779)
  • SebastianPfliegel for Add cursor snippet (#475)
  • mikaoelitiana for the fix: revert README and CONTRIBUTING after last VSCode merge (#574)
  • alextercete for Reinstate menu item to install from VSIX (#682)
  • alextercete for Fix "No extension gallery service configured" error (#427)
  • mwiedemeyer for Fix #58: Default sort order for DB size widget (#111)
  • AlexTroshkin for Show disconnect in context menu only when connectionProfile connected (#150)
  • AlexTroshkin for Fix #138: Invalid syntax color highlighting (identity not highlighting) (#140))
  • stebet for Fix #153: Fixing sql snippets that failed on a DB with a case-sensitive collation. (#152)
  • SebastianPfliegel Remove sqlExtensionHelp (#312)
  • olljanat for Implemented npm version check (#314)
  • Adam Machanic for helping with the whoisactive extension

And of course, we'd like to thank the authors of all upstream dependencies. Please see a full list in the ThirdPartyNotices.txt

License

Copyright (c) Microsoft Corporation. All rights reserved.

Licensed under the Source EULA.

Comments
  • [Database Support] MySQL

    [Database Support] MySQL

    If you want to see MySQL support in Azure Data Studio, click the thumbs up sign.

    Note: Please keep comments to this issue focused on discussions of what you would like to see instead of +1 comments.

    Area - Extensibility Enhancement 
    opened by sbehara1 115
  • WIP conversion of angular slickgrid to table.

    WIP conversion of angular slickgrid to table.

    Currently the code renames a few classes to remove their connection to angular. It allows for the creation of a table with data loaded along with showing the context menu when a cell is right click, currently the editor (onClick) function has not been implemented here yet. There may be additional angular functions that need to be reimplemented in the current code from Angular, but at the moment a table can be created without any major issues.

    opened by smartguest 86
  • Support other types of databases

    Support other types of databases

    Primarily postgres (with GIS extensions), redis, azure cosmos and mariadb.


    STOP!

    Don't scroll down!

    Want your favourite database supported??

    • Click the 👍 icon
    • Wait
    • Please do not add a comment with "+1" in the message!

    I repeat, please just upvote this initial problem-description. Do not add a comment as it's harder for the maintainers to track and +1 comments create clutter for any detailed discussion.

    CLICK THIS!! 👇

    Enhancement 
    opened by atrauzzi 67
  • Azure Active Directory - Universal with MFA support results in connection error (Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.) (AAD)

    Azure Active Directory - Universal with MFA support results in connection error (Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.) (AAD)

    Issue Type: Bug

    1. Create a new connection.
    2. Enter the connection information: a. Type = Microsoft SQL Server b. Server = FQDN to Azure SQL DB or Azure SQL DB failover group c. Authentication type = Azure Active Directory - University with MFA support d. Account = an AAD account e. Database = (actually, trying to list fails silently)
    3. Click Connect.

    Error message shows:

    System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken)
       at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionFactory.<>c__DisplayClass40_0.<TryGetConnection>b__1(Task`1 _)
       at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
       at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
    --- End of stack trace from previous location where exception was thrown ---
       at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
    --- End of stack trace from previous location where exception was thrown ---
       at Microsoft.SqlTools.ServiceLayer.Connection.ReliableConnection.ReliableSqlConnection.<>c__DisplayClass28_0.<<OpenAsync>b__0>d.MoveNext() in D:\a\1\s\src\Microsoft.SqlTools.ServiceLayer\Connection\ReliableConnection\ReliableSqlConnection.cs:line 303
    --- End of stack trace from previous location where exception was thrown ---
       at Microsoft.SqlTools.ServiceLayer.Connection.ConnectionService.TryOpenConnection(ConnectionInfo connectionInfo, ConnectParams connectionParams) in D:\a\1\s\src\Microsoft.SqlTools.ServiceLayer\Connection\ConnectionService.cs:line 521
    ClientConnectionId:d30ba148-2926-4c6e-973e-f5adb537d525
    Error Number:18456,State:1,Class:14
    

    Note: this happens with an account that's already listed or even after just adding a new account.

    Azure Data Studio version: azuredatastudio 1.4.5 (887f4e8985023602e599cf86bdb44df48bb28569, 2019-02-12T06:20:08.633Z) OS version: Windows_NT x64 10.0.17763

    System Info

    |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7-8650U CPU @ 1.90GHz (8 x 2112)| |GPU Status|2d_canvas: unavailable_software
    checker_imaging: disabled_off
    flash_3d: unavailable_software
    flash_stage3d: unavailable_software
    flash_stage3d_baseline: unavailable_software
    gpu_compositing: unavailable_software
    multiple_raster_threads: enabled_on
    native_gpu_memory_buffers: disabled_software
    rasterization: unavailable_software
    video_decode: unavailable_software
    video_encode: unavailable_software
    webgl: enabled_readback
    webgl2: unavailable_off| |Memory (System)|15.88GB (6.29GB free)| |Process Argv|C:\Users<snip>\AppData\Local\Programs\Azure Data Studio\azuredatastudio.exe| |Screen Reader|no| |VM|67%|

    Extensions (2)

    Extension|Author (truncated)|Version ---|---|--- import|Mic|0.5.0 sql-vnext|Mic|0.10.2

    Bug Area - Azure Triage: Done 
    opened by SvenAelterman 52
  • HDFS folder expansion gives internal server error

    HDFS folder expansion gives internal server error

    Issue Type: Bug

    1. connect to BDC master instance in tree view
    2. attempt to expand HDFS folder
    3. "Error: Internal Server Error" This worked fine this morning, failed after update this afternoon. I can connect to the instance and look at DB stuff fine, it's just HDFS that fails. HDFS is up and running, i can access it in other ways no problem.

    My BDC instance is on-prem k8 and i'm not using AD authentication.
    version: Microsoft SQL Server 2019 (RTM-CU4) (KB4548597) - 15.0.4033.1 (X64) Mar 14 2020 16:10:35 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Linux (Ubuntu 16.04.6 LTS)

    Azure Data Studio version: azuredatastudio 1.22.1 (1b5c54dd8c6eb03bf7ed1e04889d9f41de0523b3, 2020-09-29T16:41:11.578Z) OS version: Windows_NT x64 10.0.14393

    System Info

    |Item|Value| |---|---| |CPUs|Intel(R) Xeon(R) CPU E5-2650 v4 @ 2.20GHz (48 x 2200)| |GPU Status|2d_canvas: unavailable_software
    flash_3d: disabled_software
    flash_stage3d: disabled_software
    flash_stage3d_baseline: disabled_software
    gpu_compositing: disabled_software
    multiple_raster_threads: enabled_on
    oop_rasterization: disabled_off
    opengl: disabled_off
    protected_video_decode: disabled_off
    rasterization: disabled_software
    skia_renderer: disabled_off_ok
    video_decode: disabled_software
    vulkan: disabled_off
    webgl: unavailable_software
    webgl2: unavailable_software| |Load (avg)|undefined| |Memory (System)|127.89GB (87.02GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|

    Extensions (7)

    Extension|Author (truncated)|Version ---|---|--- admin-pack|Mic|0.0.2 agent|Mic|0.47.0 dacpac|Mic|1.6.0 datavirtualization|Mic|1.10.0 import|Mic|1.1.0 profiler|Mic|0.11.0 whoisactive|Mic|0.1.4

    Please paste. Bug Triage: Done Needs Logs 
    opened by capnsue 48
  • Cannot connect

    Cannot connect

    We have written the needed data into your clipboard because it was too large to send. Please paste. Issue Type: Bug

    Since the upgrade to 1.26.0 I can no longer connect to any server. Downloaded again the 1.25.3 and it works just fine. Any particular change or is this a bug?

    Please the error message I get here below: Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover, SqlAuthenticationMethod authType) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, DbConnectionPool pool) at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionFactory.<>c__DisplayClass47_0.<CreateReplaceConnectionContinuation>b__0(Task1 _) at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.Tasks.Task.<>c.<.cctor>b__274_0(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location where exception was thrown --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location where exception was thrown --- at Microsoft.SqlTools.ServiceLayer.Connection.ReliableConnection.ReliableSqlConnection.<>c__DisplayClass30_0.<b__0>d.MoveNext() in D:\a\1\s\src\Microsoft.SqlTools.ManagedBatchParser\ReliableConnection\ReliableSqlConnection.cs:line 314 --- End of stack trace from previous location where exception was thrown --- at Microsoft.SqlTools.ServiceLayer.Connection.ConnectionService.TryOpenConnection(ConnectionInfo connectionInfo, ConnectParams connectionParams) in D:\a\1\s\src\Microsoft.SqlTools.ServiceLayer\Connection\ConnectionService.cs:line 550 ClientConnectionId:00000000-0000-0000-0000-000000000000

    Here is the about screen: Version: 1.26.0 Commit: 995095f696fd9800e7e621d34daa895d57989ccd Date: 2021-02-19T03:24:52.069Z VS Code: 1.48.0 Electron: 9.4.3 Chrome: 83.0.4103.122 Node.js: 12.14.1 V8: 8.3.110.13-electron.0 OS: Darwin x64 19.6.0

    Azure Data Studio version: azuredatastudio 1.26.0 (995095f696fd9800e7e621d34daa895d57989ccd, 2021-02-19T03:24:52.069Z) OS version: Darwin x64 19.6.0

    System Info

    |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i5-8257U CPU @ 1.40GHz (8 x 1400)| |GPU Status|2d_canvas: enabled
    flash_3d: enabled
    flash_stage3d: enabled
    flash_stage3d_baseline: enabled
    gpu_compositing: enabled
    metal: disabled_off
    multiple_raster_threads: enabled_on
    oop_rasterization: enabled
    opengl: enabled_on
    protected_video_decode: unavailable_off
    rasterization: enabled
    skia_renderer: disabled_off_ok
    video_decode: enabled
    webgl: enabled
    webgl2: enabled| |Load (avg)|2, 6, 6| |Memory (System)|8.00GB (0.13GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|

    Extensions (8)

    Extension|Author (truncated)|Version ---|---|--- admin-pack|Mic|0.0.2 admin-tool-ext-win|Mic|0.0.2 agent|Mic|0.48.0 dacpac|Mic|1.6.0 import|Mic|1.2.0 profiler|Mic|0.11.0 server-report|Mic|0.2.3 whoisactive|Mic|0.1.4

    Bug Area - Connection Triage: Done 
    opened by Simone-86828 43
  • unsaved tabs crashing

    unsaved tabs crashing

    • Azure Data Studio Version:

    Version: 1.9.0 (system setup) Commit: 78a42e1d112ae3231777722b51eaf44f83ddbe55 Date: 2019-07-10T04:31:36.998Z VS Code 1.34.0 Electron: 3.1.8 Chrome: 66.0.3359.181 Node.js: 10.2.0 V8: 6.6.346.32 OS: Windows_NT x64 10.0.17134

    Steps to Reproduce:

    1. open a new sql tab
    2. write some tsql code and connected to an instance
    3. after some idle time, the pop with the error message shows up and the tab closes automatically

    Error: Unable to open 'SQLQuery_1 - *****...grated)': Cannot read property 'slice' of undefined.

    Note: the problem occurs rarely.

    Bug Area - Query Editor Triage: Done 
    opened by anand348 43
  •  Azure AD Guest User Access (B2B) failes to Authenticate

    Azure AD Guest User Access (B2B) failes to Authenticate

    • Azure Data Studio Version: 1.17.1 (MAC OS)

    Steps to Reproduce:

    Setup:

    1. Created a guest user in alternate AD Tenant AD.
    2. Invited the guest user into the primary AD.
    3. Ensure the Guest user accepted the invitation and configured MFA.
    4. Created a AD Group in the primary AD tenant called Guest_Group_Test and added the Guest User.
    5. Ensure AD Integration is on with the Azure SQL Server Azure AD by associating your AD User as owner or a group your a member of.
    6. Log into SQL Server using your user (not the guest)
    7. The following TSQL was ran in the SQL Database successfully.
    CREATE USER [Guest_Group_Test] FROM EXTERNAL PROVIDER;
    EXEC sp_addrolemember 'db_datareader', 'Guest_Group_Test';  
    
    1. Open Azure Data Studio, make a new connection to the target Azure SQL Server.
    2. Choose Azure Active Directory - Universal with MFA Support
    3. Ensure the Account is the Guest user email who was added into the primary tenant via b2b.
    4. Click Connect

    Error's:

    Retrieving the Azure token failed. Please Sign in again. Login failed for user '<token-identified principal>'.

    Note: Tested on SSMS version 18 and the above scenario works with authenticating B2B users provided they are in a AD Group.

    Bug Area - Azure Triage: Done Triage: Postponed 
    opened by rohrerb 42
  • Getting error while connecting to azure sql server.  Error: Token retrival failed with an error. Open developer tools to view the error

    Getting error while connecting to azure sql server. Error: Token retrival failed with an error. Open developer tools to view the error

    • Azure Data Studio Version: 1.21.0 (macos)

    Steps to Reproduce:

    • followed below approach when i got this error Token retrival failed with an error. Open developer tools to view the error
    1. Add connection type as Microsoft SQL Server
    2. Choose Authentication type as Azure Active Directory - Universal with MFA support
    3. Put Database name 4 Try to connect

    I remember i started getting this issue once i changed my AAD password.

    Screenshot 2020-09-05 at 6 03 02 PM Screenshot 2020-09-05 at 6 03 45 PM Bug Area - Connection Impact: Live site Approved 
    opened by amanraj09 40
  • Unable to view tables in the dropdown

    Unable to view tables in the dropdown

    Issue Type: Bug

    After the new update, I cannot find the tables in the Table Dropdown. I can see them when I use SSMS. I can only see system tables, even though I made a connection to a particular database.

    DataStudio

    Azure Data Studio version: azuredatastudio 1.40.0 (3fbaa3de931ef433090fe3deb8c89cba99d7952b, 2022-11-11T22:47:05.361Z) OS version: Windows_NT x64 10.0.19044 Restricted Mode: No Preview Features: Enabled

    Bug Area - Object Explorer Triage: Done 
    opened by Naval01 39
  • Can't connect to Database using Windows Authentication on Mac

    Can't connect to Database using Windows Authentication on Mac

    • SQL Operations Studio Version: 0.25.0 (0.25.0)

    Steps to Reproduce: I am trying to connect to a Database Server from my Mac, and it throws an error. Details are below. Is there something which I am missing from a connectivity perspective from Mac? I have been using SQLOpsStudio for the last 1 month in my Windows machine and it has been working like a charm. connection error

    System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 44 - Could not compose Service Principal Name (SPN) for Windows Integrated Authentication. Possible causes are server(s) incorrectly specified to connection API calls, Domain Name System (DNS) lookup failure or memory shortage) ---> System.Net.Internals.SocketExceptionFactory+ExtendedSocketException (0x00000005): Device not configured at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6) at System.Net.Dns.GetHostEntry(String hostNameOrAddress) at System.Data.SqlClient.SNI.SNIProxy.GetSqlServerSPN(String hostNameOrAddress, String portOrInstanceName) at System.Data.SqlClient.SNI.SNIProxy.GetSqlServerSPN(DataSource dataSource) at System.Data.SqlClient.SNI.SNIProxy.CreateConnectionHandle(Object callbackObject, String fullServerName, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Byte[]& instanceName, Byte[]& spnBuffer, Boolean flushCache, Boolean async, Boolean parallel, Boolean isIntegratedSecurity) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.<>c__DisplayClass22_0.b__0(Task1 _) at System.Threading.Tasks.ContinuationResultTaskFromResultTask2.InnerInvoke() at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.SqlTools.ServiceLayer.Connection.ReliableConnection.ReliableSqlConnection.<>c__DisplayClass28_0.<b__0>d.MoveNext() in D:\a\1\s\src\Microsoft.SqlTools.ServiceLayer\Connection\ReliableConnection\ReliableSqlConnection.cs:line 298 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.SqlTools.ServiceLayer.Connection.ConnectionService.d__46.MoveNext() in D:\a\1\s\src\Microsoft.SqlTools.ServiceLayer\Connection\ConnectionService.cs:line 542 ClientConnectionId:00000000-0000-0000-0000-000000000000

    Upstream Area - Connection Needs More Info Enhancement 
    opened by samirbehara-zz 39
  • Add ellipsis buttons in properties window of execution plan viewer

    Add ellipsis buttons in properties window of execution plan viewer

    In SQL Server Management Studio, when looking at execution plans, entries in the properties window that can have a long text as their content are displayed with an ellipsis button on the right. Clicking that button opens the full text in a separate window. That makes it easy to review this full text.

    There is no similar functionality in the execution plan viewer in Azure Data Studio. It would be a really nice quality-of-life improvement if this can be added.

    opened by HugoKornelis 0
  • Problème de connexion à cause de la langue FR

    Problème de connexion à cause de la langue FR

    Issue Type: Bug

    Lorsque l'interface est en Français: il est impossible de se connecter à cause du paramètre Chiffrer qui prend la valeur Faux au lieu de "False"

    image

    image

    System.ArgumentException: Valeur non valide 'Faux' pour Chiffrer. Les valeurs valides sont 'Optional', 'Mandatory', 'Strict', 'True', 'False', 'Yes' et 'No'. at Microsoft.SqlTools.ServiceLayer.Connection.ConnectionService.CreateConnectionStringBuilder(ConnectionDetails connectionDetails) in D:\a_work\1\s\src\Microsoft.SqlTools.ServiceLayer\Connection\ConnectionService.cs:line 1311 at Microsoft.SqlTools.ServiceLayer.Connection.ConnectionService.BuildConnectionString(ConnectionDetails connectionDetails) in D:\a_work\1\s\src\Microsoft.SqlTools.ServiceLayer\Connection\ConnectionService.cs:line 1204 at Microsoft.SqlTools.ServiceLayer.Connection.ConnectionService.TryOpenConnection(ConnectionInfo connectionInfo, ConnectParams connectionParams) in D:\a_work\1\s\src\Microsoft.SqlTools.ServiceLayer\Connection\ConnectionService.cs:line 645

    Azure Data Studio version: azuredatastudio 1.40.2 (661384637db384fe5d4e6224069adbe708580b16, 2022-12-22T22:17:02.658Z) OS version: Windows_NT x64 10.0.22621 Restricted Mode: No Preview Features: Enabled

    System Info

    |Item|Value| |---|---| |CPUs|AMD Ryzen 7 5800H with Radeon Graphics (16 x 3194)| |GPU Status|2d_canvas: enabled
    canvas_oop_rasterization: disabled_off
    direct_rendering_display_compositor: disabled_off_ok
    gpu_compositing: enabled
    multiple_raster_threads: enabled_on
    oop_rasterization: enabled
    opengl: enabled_on
    rasterization: enabled
    raw_draw: disabled_off_ok
    skia_renderer: enabled_on
    video_decode: enabled
    video_encode: enabled
    vulkan: disabled_off
    webgl: enabled
    webgl2: enabled| |Load (avg)|undefined| |Memory (System)|39.37GB (29.85GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|

    Extensions (7)

    Extension|Author (truncated)|Version ---|---|--- admin-pack|Mic|0.0.2 ads-language-pack-fr|Mic|1.40.1 agent|Mic|0.49.0 dacpac|Mic|1.11.0 import|Mic|1.5.4 profiler|Mic|0.11.0 extra-sql-script-as|pac|0.5.0

    opened by Flagache 1
  • Azure Data Studio dropping db / server connections

    Azure Data Studio dropping db / server connections

    • Azure Data Studio Version: 1.40.1
    • OS Version: Windows 11

    Steps to Reproduce:

    1. Connect to a server 2.Open up a query window for one of the db's on that server
    2. leave the query window open for a length of time 15 > 30 mins
    3. Attempt to re-run the query - The query will not execute as the connection to to the db/server has dropped
    4. Attempt to open a new query window - The window opens up no db's are listed at the top
    5. waiting 30 seconds or so eventually reconnects

    Is there a setting somewhere thats forcing it to drop / sleep the connections when there's no activity for a period of time?

    Does this issue occur when all extensions are disabled?: Yes

    Bug Area - Connection Triage: Needed 
    opened by agentwalker 2
  • There is a vulnerability in @angular/core:4.1.3,upgrade recommended

    There is a vulnerability in @angular/core:4.1.3,upgrade recommended

    https://github.com/microsoft/azuredatastudio/blob/0ba0205ee8aee26bcc69e0214528f34e5d1ec14c/yarn.lock#L33-L34

    CVE-2021-4231

    Recommended upgrade version:11.0.5

    Bug Triage: Needed Area - Live site 
    opened by QiAnXinCodeSafe 0
  • There is a vulnerability in postcss:6.0.23,upgrade recommended

    There is a vulnerability in postcss:6.0.23,upgrade recommended

    https://github.com/microsoft/azuredatastudio/blob/0ba0205ee8aee26bcc69e0214528f34e5d1ec14c/yarn.lock#L8579-L8580

    CVE-2021-23382 CVE-2021-23368

    Recommended upgrade version:7.0.36

    Bug Triage: Needed Area - Live site 
    opened by QiAnXinCodeSafe 0
Releases(1.40.2)
  • 1.40.2(Dec 27, 2022)

    Version 1.40.2

    • Release date: December 27, 2022
    • Release status: General Availability

    Bug fixes in 1.40.2

    • Fix potential elevation of privilege issue using Bash shell on Windows. VS Code issue #160827

    |Platform |Type |Download | | --------|-----------------|----------------------- | |Windows |User Installer |64 bit | | |System Installer |64 bit | | |.zip |64 bit | |Linux |.tar.gz |64 bit | | |.deb |64 bit | | |.rpm |64 bit | |Mac |.zip |UniversalIntel ChipApple Silicon |

    Source code(tar.gz)
    Source code(zip)
  • 1.40.1(Nov 23, 2022)

    Version 1.40.1

    • Release date: November 22, 2022
    • Release status: General Availability

    What's new in 1.40.1

    • Bug fixes in 1.40.1
      • Fixed bug that caused folders in the servers tree to display incorrect contents (https://github.com/microsoft/azuredatastudio/issues/21245)

    |Platform |Type |Download | | --------|-----------------|----------------------- | |Windows |User Installer |64 bit | | |System Installer |64 bit | | |.zip |64 bit | |Linux |.tar.gz |64 bit | | |.deb |64 bit | | |.rpm |64 bit | |Mac |.zip |UniversalIntel ChipApple Silicon |

    Source code(tar.gz)
    Source code(zip)
  • 1.40.0(Nov 16, 2022)

    Version 1.40.0

    • Release date: November 16, 2022
    • Release status: General Availability

    What's new in 1.40.0

    | New Item | Details | |----------|---------| | Connections | Connections for SQL now default to Encrypt = 'True'. | | ARM64 Support for macOS | ARM64 build for macOS is now available. | | Table Designer | Announcing the General Availability of the Table Designer. | | Table Designer | Period columns now added by default when System-Versioning table option is selected. | | Table Designer | Added support for hash indexes for In-Memory tables, and added support for columnstore indexes. | | Table Designer | New checkbox added, "Preview Database Updates", when making database changes to ensure that users are aware of potential risks prior to updating the database.| | Table Designer | "Move Up" and "Move Down" buttons added to support column reordering for Primary Keys. | | Query Plan Viewer | Announcing the General Availability of the Query Plan Viewer in Azure Data Studio. | | Query Plan Viewer | Added support for identification of most expensive operator(s) in a plan. | | Query Plan Viewer | Updates were made to the properties window to allow for full display of text upon hovering over a cell. Full text can also be copied. | | Query Plan Viewer | Implemented filter functionality in the Properties pane for an execution plan. | | Query Plan Viewer | Added support for collapsing and expanding all subcategories within the Plan Comparison Properties window. | | Query History Extension | Announcing the General Availability of the SQL History Extension. | | Query History Extension | Now includes ability to persist history across multiple user sessions. | | Query History Extension | Added the ability to limit the number of entries stored in the history. | | Schema Compare | Users can now open .scmp files directly from the context menu for existing files in the file explorer. | | Query Editor | Now allows full display for text strings larger than 65,535 characters. | | Query Editor | Added support for the SHIFT key when making multiple cell selections. | | MySQL Extension | Support for MySQL extension is now available in preview. | | Azure SQL Migration Extension | Azure SQL Database Offline Migrations is now available in preview. Customers can use this new capability to save and share reports as needed. | | Azure SQL Migration Extension | Addition of elastic Azure recommendations model. | | Database Migration Assessment for Oracle | Assessment tooling for Oracle database migrations to Azure Database for PostgreSQL and Azure SQL available in preview. | | VS Code merge | VS Code merges to version 1.67. Read their release notes to learn more. | | SQL Database Projects | Adds SQL projects support for syntax introduced in SQL Server 2022.|

    Bug fixes in 1.40.0

    | New Item | Details | |----------|---------| | Connections | Fixed bug that occurred when trying to connect to the Dedicated Admin Connection (DAC) on SQL Server. | | Connections | Fixed issue with wrong tenant showing up while trying to connect to a database with Azure Active Directory login. | | Connections | Fixed zoom reset behavior when adding a new connection. | | Connections | Fixed loading bug what occurred when attempting to sign in to Azure via proxy. | | Connections | Fixed issue encountered while attempting to connect to a "sleeping" Azure SQL Database. | | Object Explorer | Fixed the SELECT script generation issue for Synapse Databases. | | Schema Compare | Fixed error that caused duplication of comment headers when applying schema changes on stored procedure objects. | | Schema Compare | Fixed issue that prevented schema compare issues when creating a new empty schema with a "DOMAIN\User" pattern. | | Query Editor | Fixed bug that caused results to be lost upon saving query files. | | Table Designer | Fixed a bug that caused creation of a new table when renaming an existing table. | | Query Plan Viewer | Fixed missing index recommendation T-SQL syntax. | | SQL Projects | Fixed bug in SQL Projects that led to extension not using output path when publishing a project. | | SQL Projects | Fixed bug that caused .NET install to not be found when using the SQL Projects extension on Linux platforms. |

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS Universal | | macOS ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.39.1(Aug 30, 2022)

  • 1.39.0(Aug 24, 2022)

    Version 1.39.0

    • Release date: August 24, 2022
    • Release status: General Availability

    What's new in 1.39.0

    | New Item | Details | |----------|---------| | Deployment Wizard | Azure Data Studio now supports SQL Server 2022 (Preview) in the Deployment Wizard for both local and container installation. | | Object Explorer | Added Ledger icons and scripting support to Object Explorer for Ledger objects. | | Dashboard | Added hexadecimal values to support color detection. | | Query Plan Viewer | Added the ability to copy text from cells in the Properties Pane of a query plan. | | Query Plan Viewer | Introduced a "find node" option in plan comparison to search for nodes in either the original or added plan. | | Table Designer | Now supports the ability to add included columns to a nonclustered index, and the ability to create filtered indexes. | | SQL Projects | Publish options were added to the Publish Dialog. | | Query History Extension | Added double-click support for query history to either open the query or immediately execute it, based on user configuration. |

    Bug fixes in 1.39.0

    | New Item | Details | |----------|---------| | Dashboard | Fixed an accessibility issue that prevented users from being able to access tooltip information using the keyboard. | | Voiceover | Fixed a bug that caused voiceover errors across the Dashboard, SQL Projects, SQL Import Wizard, and SQL Migration extensions. | | Schema Compare | Fixed a bug that caused the UI to jump back to the top of the options list after selecting/deselecting any option. | | Schema Compare | Fixed a bug involving Schema Compare (.SCMP) file incompatibility with Database Project information causing errors when reading and using information stored in this file type. | | Object Explorer | Fixed a bug that caused menu items in Object Explorer not to show up for non-English languages. | | Table Designer | Fixed a bug that caused the History Table name not to be consistent with the current table name when working with System-Versioned Tables. | | Table Designer | Fixed a bug in the Primary Key settings that caused the "Allow Nulls" option to be checked, but disabled, preventing users from changing this option. | | Query Editor | Fixed a bug that prevented the SQLCMD in T-SQL from working correctly, giving false errors when running scripts in Azure Data Studio. | | Query Editor | Fixed a bug that caused user-specified zoom settings to reset to default when selecting JSON values after query that returned JSON dataset was ran. | | SQL Projects | Fixed a bug that caused the "Generate Script" command to not work correctly when targeting a new Azure SQL Database. | | Notebooks | Fixed a bug that caused pasted images to disappear from editor after going out of edit mode. | | Notebooks | Fixed a bug that caused a console error message to appear after opening a markdown file. | | Notebooks | Fixed a bug that prevented markdown cell toolbar shortcuts from working after creating a new split view cell. | | Notebooks | Fixed a bug that caused text cells to be erroneously created in split view mode when the notebook default text edit mode was set to "Markdown". |

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.38.0(Jul 27, 2022)

    Version 1.38.0

    • Release date: July 27, 2022
    • Release status: General Availability

    What's new in 1.38.0

    | New Item | Details | |----------|---------| | VS Code merges to 1.62 | This release includes updates to VS Code from the three previous VS Code releases. Read their release notes to learn more. | | Table Designer | New column added to Table Designer for easier access to additional actions specific to individual rows. | | Query Plan Viewer | The Top Operations pane view now includes clickable links to operations in each of its rows to show the runtime statistics which can be used to evaluate estimated and actual rows when analyzing a plan. | | Query Plan Viewer | Improved UI on selected operation node in the Execution Plan. | | Query Plan Viewer | The keyboard command CTRL + M no longer executes queries. It now just enables or disables the actual execution plan creation when a query is executed. | | Query Plan Viewer | Plan labels are now updated in the Properties window when plans are compared and the orientation is toggled from horizontal to vertical, and back. | | Query Plan Viewer | Updates were made to the Command Palette. All execution plan commands are prefixed with "Execution Plan", so that they are easier to find and use. | | Query Plan Viewer | A collapse/expand functionality is now available at the operator level to allow users to hide or display sections of the plan during analysis. | | Query History | The Query History extension was refactored to be fully implemented in an extension. This makes the history view behave like all other extension views and also allows for searching and filtering in the view by selecting the view and typing in your search text. |

    Bug fixes in 1.38.0

    | New Item | Details | |----------|---------| | Table Designer | Error found in edit data tab when switching back to previously selected column when adding a new row. To fix this, editing the table is now disabled while new rows are being added and only reenabled afterwards. | | Query Editor | Fixed coloring issues for new T-SQL functions in the Query Editor. | | Query Plan Viewer | Fixed bug that caused custom zoom level spinner to allow values outside valid range. | | Dashboard | Fixed issue that caused incorrect displaying of insight widgets on the dashboard. | | Notebooks | Fixed issue where keyboard shortcuts and toolbar buttons were not working when first creating a Split View markdown cell. | | Notebooks | Fixed issue where cell languages were not being set correctly when opening an ADS .NET Interactive notebook in VS Code. | | Notebooks | Fixed issue where notebook was being opened as empty when exporting a SQL query as a notebook. | | Notebooks | Disables install and uninstall buttons in Manage Packages dialog while a package is being installed or uninstalled. | | Notebooks | Fixed issue where cell toolbar buttons were not refreshing when converting cell type. | | Notebooks | Fixed issue where notebook was not opening if a cell contains an unsupported output type. | | Schema Compare | Fixed issue where views and stored procedures were not correctly recognized by schema compare after applying changes. |

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.37.0(Jun 15, 2022)

    Version 1.37.0

    • Release date: June 15, 2022
    • Release status: General Availability

    What's new in this version

    • New Features:

      • Backup & Restore - Backup & Restore to URL is now available in preview for Azure SQL Managed Instances.
      • Table Designer - Added API to support computed column capabilities on Table Designer.
      • Table Designer - Can now specify where to add new columns and columns can now be re-arranged by mouse dragging.
      • Table Designer - Table Designer is now supported by SQL Projects to add or modify database schema without need to be connected to a server instance.
      • Query Plan Viewer - Smart plan comparison is now available. Can now compare execution plans and view detailed differences between plans in the Properties Table.
      • Query Plan Viewer - Added toggle button to switch between estimated and actual execution plans.
      • Query Plan Viewer - Query Plan now comes with improved precision to operator costs for larger plans.
      • MongoDB Extension for Azure Cosmos DB (Preview) - This extension introduces support for access to Mongo resources for Cosmos DB.
    • Bug Fixes:

      • Table Designer - Fixed issue that caused app to not prompt user to save before closing.
      • Table Designer - Fixed issue that returned empty data set upon attempting to edit the first cell of a new row.
      • Table Designer - Improved resize to fit experience when zooming in on user interface as well as tab behavior issues.
      • Query Plan Viewer - Fixed bug that caused custom zoom level spinner to allow values outside valid range.
      • Schema Compare - Fixed issue with indexes not being added correctly when updating project from database.
      • Notebooks - Fixed inconsistencies with notebook cell behavior and toolbars.
      • Notebooks - Fixed issues with keyboard navigation.

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.36.2(May 20, 2022)

  • 1.36.1(Apr 22, 2022)

    Version 1.36.1

    • Release date: April 22, 2022
    • Release status: General Availability

    What's new in this version

    • April Hotfix addressing these issues https://github.com/microsoft/azuredatastudio/milestone/88?closed=1.
    • Hotfix RCA - https://github.com/microsoft/azuredatastudio/wiki/ADS-April-2022-Hotfix-RCA

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.36.0(Apr 20, 2022)

    Version 1.36.0

    • Release date: April 20, 2022
    • Release status: General Availability

    What's new in this version

    • General Availability of the Azure SQL Migration Extension for ADS
    • Support for .NET Interactive Notebooks Extension
    • New Table Designer Features including support for System Versioned, Graph and Memory Optomized Tables
    • Query Plan Viewer Updates includign warning and parallelism icons, the option to disable tooltips and support for opening .sqlplan files
    • Improvements in SQL Projects and Schema Compare

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.35.1(Mar 17, 2022)

  • 1.35.0(Feb 24, 2022)

    Version 1.35.0

    • Release date: February 24, 2022
    • Release status: General Availability

    What's new in this version

    • New Features:

      • Table Designer - Added functionality for creation and management of tables for SQL Servers. Built using DacFx framework
      • Query Plan Viewer - Added functionality for users to view a graphic view of estimated and actual query plans without need for an extension
      • Azure Arc Extension - Updated the Data Controller deployment wizard and the SQL Managed Instance - Azure Arc deployment wizard to reflect the deployment experience in Azure Portal
    • Bug Fixes:

      • Azure Arc Extension - SQL Managed Instance-Azure Arc is now fixed for both indirect connectivity mode and direct connectivity mode
      • Notebooks - Support for keyboard navigation between cells to minimize mouse clicking

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.34.0(Dec 16, 2021)

    Version 1.34.0

    • Release date: December 15, 2021
    • Release status: General Availability

    What's new in this version

    • New Features:

      • Added “Currently restoring backup file” in the migration progress details page of Azure SQL Migration extension when backup files location is Azure Storage blob container
      • Enhancements to diagnostics in Azure SQL Migration extension
      • Support for project build with .NET 6 in SQL Database Projects extension
      • Publish to container in SQL Database Projects extension
      • Undo and redo support for notebook cell-level operations
    • Extension Updates:

      • Azure SQL Migration
      • Langpacks
      • SQL Database Projects
    • Bug Fixes:

      • Fix for multiple database migrations when using network share as backup files location in Azure SQL Migration extension
      • Fix for multiple database migrations when using blob storage containers as backup files location in Azure SQL Migration extension
      • Fix to pre-populate target database names in the migration wizard in Azure SQL Migration extension
      • Fix to column sorting in grids where the presence of null values could lead to unexpected results
      • Fix for Python upgrades when two or more notebooks were open

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.33.1(Nov 5, 2021)

  • 1.33.0(Oct 27, 2021)

    Version 1.33.0

    • Release date: October 27, 2021
    • Release status: General Availability

    What's new in this version

    • New Notebook Features:

      • Notebook Views
      • Split cell support
      • Keyboard shortcuts for Markdown Toolbar Cells
        • Ctrl/Cmd + B = Bold Text
        • Ctrl/Cmd + I = Italicize Text
        • Ctrl/Cmd + U = Underline Text
        • Ctrl/Cmd + Shift + K = Add Code Block
        • Ctrl/Cmd + Shift + H = Highlight Text
      • Book improvements
        • Add a new section
        • Drag and Drop
    • Extension Updates:

      • Import
      • Langpacks
      • Schema Compare
      • Sql Database Projects
      • Azure SQL Migration
    • Bug Fixes

      • Notebook linking improvements
      • Horizontal Scrollbar improvement (when word wrap is off in MD Splitview / MD mode) in Notebooks
      • Vertical Scrollbar improvement for MD Splitview in Notebooks

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.32.0(Aug 18, 2021)

    Version 1.32.0

    • Release date: August 18 , 2021
    • Release status: General Availability

    What's new in this version

    • Extension Updates:
      • Arc/Az CLI extensions - Azure Arc extension now uses Azure CLI instead of Azure Data CLI for deploying and interacting with Azure Arc instances
      • Azure Monitor
      • Langpacks
      • SQL Database Projects
      • Machine Learning

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.31.1(Jul 29, 2021)

    Version 1.31.1

    • Release date: July 29, 2021
    • Release status: General Availability

    Hotfix release

    What's new in this version

    • New Notebook Features:
      • WYSIWYG link improvements
    • Extension Updates:
      • Import
      • SandDance
      • SQL Database Projects
    • Bug Fixes
      • Accessibility bug fixes
      • Fix SQL/Notebook editors opening as plaintext

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.31.0(Jul 21, 2021)

  • 1.30.0(Jun 17, 2021)

    Version 1.30.0

    • Release date: June 17 2021
    • Release status: General Availability

    What's new in this version

    • New Notebook Features:
      • Show book's notebook TOC title in pinned notebooks view
      • Add new book icon
      • Update Python to 3.8.10
    • Query Editor Features:
      • Added filtering/sorting feature for query result grid in query editor and notebook, the feature can be invoked from the column headers. Note that this feature is only available when you enable the preview features
      • Added a status bar item to show summary of the selected cells if there are multiple numeric values
    • Extension Updates:
      • SQL Database Projects
      • Machine Learning
    • Bug Fixes
      • Fix WYSIWYG Table cell adding new line in table cell

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.29.0(May 19, 2021)

  • 1.28.0(Apr 16, 2021)

  • 1.27.0(Mar 17, 2021)

  • 1.26.1(Feb 25, 2021)

    Version 1.26.1

    • Release date: February 25, 2021
    • Release status: General Availability

    Hotfix release

    • Fixes https://github.com/microsoft/azuredatastudio/issues/14382

    What's new in this version

    • Release date: February 22, 2021
    • Release status: General Availability
    • New notebook features
      • Improved Jupyter server start-up time by 50% on Windows
      • Added support to edit Jupyter Books through right-click
      • Added URI notebook parameterization support
    • Extension Updates:
      • Azure Arc
        • Multiple data controllers now supported
        • New connection dialog options like kube config file
        • Postgres dashboard enhancements
      • Azure Data CLI
      • Kusto
      • Machine Learning
      • Profiler
      • Server Reports
      • Schema Compare
      • SQL Server Dacpac
      • SQL Database Projects
    • Bug Fixes

    What's new in this version

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.26.0(Feb 22, 2021)

    Version 1.26.0

    • Release date: February 22, 2021
    • Release status: General Availability
    • New notebook features
      • Improved Jupyter server start-up time by 50% on Windows
      • Added support to edit Jupyter Books through right-click
      • Added URI notebook parameterization support
    • Extension Updates:
      • Azure Arc
        • Multiple data controllers now supported
        • New connection dialog options like kube config file
        • Postgres dashboard enhancements
      • Azure Data CLI
      • Kusto
      • Machine Learning
      • Profiler
      • Server Reports
      • Schema Compare
      • SQL Server Dacpac
      • SQL Database Projects
    • Bug Fixes

    What's new in this version

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.25.3(Feb 10, 2021)

    Version 1.25.3

    • Release date: February 10, 2021
    • Release status: General Availability

    Hotfix release

    • Update Electron to 9.4.3 to incorporate critical upstream fixes

    What's new in this version

    Release date: January 22, 2021 Release status: General Availability Kusto extension improvements SQL Project extension improvements Notebook improvements Azure Browse Connections Preview performance improvements

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.25.2(Jan 22, 2021)

    Version 1.25.2

    • Release date: December 10, 2020
    • Release status: General Availability

    Hotfix release

    • Fixes https://github.com/microsoft/azuredatastudio/issues/13899

    What's new in this version

    Release date: January 22, 2021 Release status: General Availability Kusto extension improvements SQL Project extension improvements Notebook improvements Azure Browse Connections Preview performance improvements

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.25.1(Dec 9, 2020)

    Version 1.25.1

    • Release date: December 10, 2020
    • Release status: General Availability

    Hotfix release

    • Fixes https://github.com/microsoft/azuredatastudio/issues/13751

    What's new in this version

    Release date: December 8, 2020 Release status: General Availability Kusto extension improvements SQL Project extension improvements Notebook improvements Azure Browse Connections Preview performance improvements Bug Fixes

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.24.0(Nov 12, 2020)

    Version 1.24.0

    • Release date: November 12, 2020
    • Release status: General Availability

    What's new in this version

    • SQL Project improvements
    • Notebook improvements, including in WYSIWYG editor enhancements
    • Azure Arc improvements
    • Azure SQL Deployment UX improvements
    • Azure Browse Connections Preview
    • Bug Fixes

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.23.0(Oct 14, 2020)

    Version 1.23.0

    • Release date: October 14, 2020
    • Release status: General Availability
    • Added deployments of Azure SQL DB and VM
    • Added PowerShell kernel results streaming support
    • Added improvements to SQL Database Projects extension
    • Bug Fixes
    • Extension Updates:
      • SQL Server Import
      • Machine Learning
      • Schema Compare
      • Kusto
      • SQL Assessment
      • SQL Database Projects
      • Azure Arc
      • azdata

    What's new in this version

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
  • 1.22.1(Sep 30, 2020)

    Version 1.22.1

    • Release date: September 30, 2020
    • Release status: General Availability

    What's new in this version

    | Change | Details | | :----- | :------ | | Fix bug #12615 Active connection filter doesn't untoggle | #12615 | | Fix bug #12572 Edit Data grid doesn't escape special characters | #12572 | | Fix bug #12570 Dashboard Explorer table doesn't escape special characters | #12570 | | Fix bug #12582 Delete row on Edit Data fails | #12582 | | Fix bug #12646 SQL Notebooks: Cells being treated isolated | #12646 |

    | Platform | | --------------------------------------- | | Windows User Installer | | Windows System Installer | | Windows ZIP | | macOS ZIP | | Linux TAR.GZ | | Linux RPM | | Linux DEB |

    Source code(tar.gz)
    Source code(zip)
Owner
Microsoft
Open source projects and samples from Microsoft
Microsoft
A tiny javascript + Flash library that enables the creation and download of text files without server interaction.

Downloadify: Client Side File Creation Important! The swf has been compiled for online use only. Testing from the file path (i.e. file:// ) will not w

Doug Neiner 853 Nov 21, 2022
Connect to private Google Cloud SQL instance through Cloud SQL Auth Proxy running in Kubernetes.

⛅ google-cloud-sql A CLI app which establishes a connection to a private Google Cloud SQL instance and port-forwards it to a local machine. Connection

Dinko Osrecki 10 Oct 16, 2022
Python ELT Studio, an application for building ELT (and ETL) data flows.

PELT Studio The Python Extract, Load, Transform Studio is an application for performing ELT (and ETL) tasks. Under the hood the application consists o

Schlerp 55 Nov 18, 2022
ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.

TypeORM is an ORM that can run in NodeJS, Browser, Cordova, PhoneGap, Ionic, React Native, NativeScript, Expo, and Electron platforms and can be used

null 30.1k Jan 3, 2023
An adapter-based ORM for Node.js with support for mysql, mongo, postgres, mssql (SQL Server), and more

Waterline is a next-generation storage and retrieval engine, and the default ORM used in the Sails framework. It provides a uniform API for accessing

Balderdash 5.4k Jan 4, 2023
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server & SQLite

Prisma Quickstart • Website • Docs • Examples • Blog • Slack • Twitter • Prisma 1 What is Prisma? Prisma is a next-generation ORM that consists of the

Prisma 28k Jan 2, 2023
Microsoft SQL Server client for Node.js

node-mssql Microsoft SQL Server client for Node.js Supported TDS drivers: Tedious (pure JavaScript - Windows/macOS/Linux, default) Microsoft / Contrib

null 2.1k Jan 4, 2023
AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

Please use version 1.x as prior versions has a security flaw if you use user generated data to concat your SQL strings instead of providing them as a

Andrey Gershun 6.1k Jan 9, 2023
An easy-to-use multi SQL dialect ORM tool for Node.js

Sequelize Sequelize is a promise-based Node.js ORM tool for Postgres, MySQL, MariaDB, SQLite and Microsoft SQL Server. It features solid transaction s

Sequelize 27.3k Jan 4, 2023
TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases.

TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite datab

MikroORM 5.4k Dec 31, 2022
Fast and advanced, document based and key-value based NoSQL database that able to work as it is installed.

About Fast and advanced, document based and key-value based NoSQL database that able to work as it is installed. Features NoSQL database Can be run as

null 6 Dec 7, 2022
MongoDB object modeling designed to work in an asynchronous environment.

Mongoose Mongoose is a MongoDB object modeling tool designed to work in an asynchronous environment. Mongoose supports both promises and callbacks. Do

Automattic 25.2k Dec 30, 2022
O Projeto RENOVA é um e-commerce que visa ajudar no contato de pessoas interessadas em reciclagem com os itens de potencial reciclavel. Work in progress.

Descrição Nest framework TypeScript starter repository. Instalação $ npm install Rodando o app # development $ npm run start # watch mode $ npm run s

RENOVA 12 Dec 15, 2022
【毕业设计】基于Spring Boot的宿舍管理系统(Dormitory Management System)。以MySQL为数据库,在Spring Boot + SpringMVC + MyBatis + Layui框架下基于B/S架构设计开发而成。

SpringBootDMS 【毕业设计】基于Spring Boot的宿舍管理系统(Dormitory Management System)。以MySQL为数据库,在Spring Boot + SpringMVC + MyBatis + Layui框架下基于B/S架构设计开发而成。 文件夹介绍: da

Linda Silk 9 Dec 14, 2021
Lovefield is a relational database for web apps. Written in JavaScript, works cross-browser. Provides SQL-like APIs that are fast, safe, and easy to use.

Lovefield Lovefield is a relational database written in pure JavaScript. It provides SQL-like syntax and works cross-browser (currently supporting Chr

Google 6.8k Jan 3, 2023
A simple url shorter API built with nodejs running on Kubernetes in Google Cloud, using PostgreSQL for storage and cloud sql proxy.

Simple URL Shorter - Google Cloud - Kubernetes A simple url shorter API built with nodejs running on Kubernetes in Google Cloud, using PostgreSQL for

null 3 Nov 25, 2021
Validate and auto-generate TypeScript types from raw SQL queries in PostgreSQL.

SafeQL Write SQL Queries With Confidence • Get started Install I would first recommend follow the instructions in the documentation. npm install --sav

null 747 Dec 28, 2022
Avocano is a sample dropship/fake product website with Cloud Run, Cloud SQL and Cloud Build

Avocano - A Fake Product Website Avocano is a sample dropship/fake product website, combining: Firebase Hosting front end, written with Lit, Cloud Run

Google Cloud Platform 9 Dec 9, 2022