How to Manage Azure with PowerShell Command from Azure Data Studio

All of us know Azure Data Studio is new Microsoft tool like SQL Server Management Studio but with highly advanced features like Azure Data Studio Notebook, one of the features that you can PowerShell extension on Azure data Studio to connect to your Azure Portal and do your homework easily, Azure data studio PowerShell extension supported PowerShell and Cloud Shell (CLI) AZ Command, did you imagine this powerful tool from one place you can write your T-SQL, PowerShell, and CLI and you can manage your SQL Server on Premises and your Azure SQL and the other Azure services, all of these services and these languages from one place Using Microsoft Azure data Studio 🚀💪😱

IF you need to check all of my azure posts ➡ Latest Microsoft Azure Articles and Posts

Managing Azure With PowerShell From Azure Data Studio

Connect to Azure with PowerShell from Azure Data Studio

Download Azure Data Studio Download Link
After installation open Azure data Studio and from the left side select Extensions
In the Search write “PowerShell” and install it
After Extension installation open View >> Terminal and Start your Code
If you need to login to azure you can write “Az Login” or “Connect-AzAccount”
After this you can do what you need as below, I connected to azure and I created a new Resource Group using PowerShell and Using Cloud Shell CLI Az command also.

How to use PowerShell in Azure Data Studio

References and Resources

Keep Following Me

Published by Mustafa EL-Masry

I am Microsoft database consultant working as a Database administrator for more than +10 Years I have very good knowledge about Database Migration, Consolidation, Performance Tuning, Automation Using T-SQL, and PowerShell and so many other tasks I do it in multiple customers here in KSA and as of now, I am working in Bank Albilad managing the core banking system that is hosted in SQL Server Database 8 TB. Also, I am Microsoft certified 2008 and 2016 in SQL Server (2x MCTS, 2x MCTIP, MCSA, MCSE) and I am Microsoft Certified Trainer (MCT) also I am azure Certified (AZ-900, AZ-103) also I was awarded by Microsoft Azure Heroes 3 times as (Azure Content hero, Azure Community hero and Azure Mentor) For more information check my page https://mostafaelmasry.com/about-me/ View all posts by Mustafa EL-Masry

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

it Tutorial

ORA-27106: system pages not available to allocate memory September 22, 2022

I got “ORA-27106: system pages not available to allocate memory” error in Oracle database during startup of instance on Exadata. ORA-27106: system pages not available to allocate memory Details of error are as follows. [MSDB4]/home/oracle $ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 22 13:23:26 2022 Version 19.14.0.0.0 Copyrig […]

Mehmet Salih Deveci

4 Common Indicators That Signal Database Performance Issues June 30, 2022

Dealing with database performance issues has to be a priority, regardless of the scope or scale of your server infrastructure. Of course, if you don’t know what to look for, you might not appreciate that performance is suboptimal in the first place. To avoid this scenario persists, here are some thoughts on how your database … The post 4 Common Indicators Th […]

Kevin Kline

ORA-02449: unique/primary keys in table referenced by foreign keys During Drop Tablespace June 13, 2022

I got “ORA-02449: unique/primary keys in table referenced by foreign keys During Drop Tablespace ” error in Oracle database. ORA-02449: unique/primary keys in table referenced by foreign keys During Drop Tablespace Details of error are as follows. SQL> DROP TABLESPACE TBS_USERS INCLUDING CONTENTS AND DATAFILES DROP TABLESPACE TBS_USERS INCLUDING CONTENT […]

Mehmet Salih Deveci

ORA-01136: specified size of file is less than original size of blocks | ORA-01110: data file June 13, 2022

I got “ORA-01136: specified size of file is less than original size of blocks | ORA-01110: data file ” error in Oracle database. ORA-01136: specified size of file is less than original size of blocks | ORA-01110: data Details of error are as follows. SQL> alter system set standby_file_management='MANUAL' scope=both; System altered. SQL> al […]

Mehmet Salih Deveci

OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value June 3, 2022

I got ” OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value ” error in Oracle database. OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value Details of error are as follows. OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value 1000 When starting the Extracts for the … The post OGG-02039 Fai […]

Mehmet Salih Deveci