Azure Data Studio (ADS) is a lightweight Integrated Development Environment (IDE) built on Visual Studio Code. While ADS is primarily known for its SQL Server capabilities, it also supports other programming languages. In this article, we will explore how ADS can be used for non-SQL work, specifically focusing on PowerShell and Python.

PowerShell in ADS

PowerShell is a popular scripting language used for automation and task management. ADS provides built-in support for PowerShell, allowing developers to write and execute PowerShell scripts directly within the IDE.

To switch to PowerShell in ADS, simply open a new Query Window and click on the “SQL” word in the bottom toolbar. This will display a menu with various language options, including PowerShell. By selecting PowerShell, the language at the bottom will change, and you will have access to PowerShell-specific features such as IntelliSense.

While ADS offers basic PowerShell functionality out of the box, you can enhance the experience by adding the PowerShell extension. This extension provides additional features and resolves any mapping issues with function keys.

Python in ADS

Python is a versatile programming language used for a wide range of applications, including data analysis, web development, and machine learning. While ADS does support Python, its capabilities are more limited compared to SQL and PowerShell.

To work with Python in ADS, you can create a new file and set the language to Python. However, unlike SQL and PowerShell, ADS does not provide IntelliSense for Python code. Additionally, executing Python scripts directly within ADS is not supported. Instead, you can edit Python files in ADS and use a separate terminal or IDE, such as Visual Studio Code, to run and test the code.

Notebooks in ADS offer a better experience for running Python code. You can create Python notebooks and execute code cells within ADS. However, if you need to work with Python files directly, it is recommended to use a dedicated Python IDE for a more comprehensive development experience.

Conclusion

Azure Data Studio is a powerful tool for SQL Server development and administration. While it does provide support for non-SQL languages like PowerShell and Python, its capabilities in these areas are more limited compared to dedicated IDEs like Visual Studio Code.

If you primarily work with SQL and PowerShell, ADS can be a convenient choice as it offers seamless integration between the two. However, for extensive Python development or working with other non-SQL languages, it is recommended to use a dedicated IDE that provides more comprehensive features and functionality.

Regardless of your choice, exploring the non-SQL capabilities of Azure Data Studio can help you streamline your development workflow and enhance your productivity.