Advance

How to Install Azure Data Studio on AlmaLinux 8

Richard 10 Min Read
How to install Azure Data Studio on AlmaLinux 8 1
1
(1)

SQL Operations Studio was introduced by Microsoft to connect to databases and write queries among other features. The new version of this tool is Azure Data Studio, a lightweight environment for writing and editing database queries. This article will teach you How to Install Azure Data Studio on AlmaLinux 8. You can check out Linux VPS services on the Eldernode website if you want to purchase them.

Tutorial Install Azure Data Studio on AlmaLinux 8

Recommended Article: Install Python 3.9 On Eldernode Linux

What is Azure Data Studio?

Azure Data Studio is a free, lightweight, and cross-platform database tool for working with SQL Server instances. It was initially called SQL Operations Studio and includes an integrated T-SQL editor, server connection manager, internal terminal, version control support, and more. This software is designing to make routine database development, query, and task management easier than Microsoft SQL Server Management Studio software and has an in-built chart of query result sets and customizable dashboards. A modern editor with IntelliSense, code snippet, source control integration, and an integrated terminal is provided by Azure Data Studio.

Azure Data Studio Features

– Integrated Terminal

– Customizable Server and Database Dashboards

– SQL code editor with IntelliSense

– Smart SQL code snippets

– Extensibility and extension authoring

– Connection management

Installing Azure Data Studio on AlmaLinux 8

How to Use Azure Data Studio on AlmaLinux 8

There are two ways to launch Azure Data Studio. You can use the following command or from the App menu:

azuredatastudio

It will start as follows. Now you need to connect to an SQL Server. If you don’t have it, use our tutorial to Install SQL Server on AlmaLinux. You can connect to a database by clicking on Create a connection:

 

Launch-Azure-Data-Studio

 

Then provide your SQL server details and click on Connect:

 

Provide-SQL-server-connection

 

Then you should see the following page on successful authentication:

 

Successful-authentication

 

If you want to create a database, just right-click on the server and select New Query:

 

Create-database-new-query

 

And enter the following command and click Run:

USE master  GO  IF NOT EXISTS (   SELECT name   FROM sys.databases   WHERE name = N'TestDB'  )   CREATE DATABASE [TestDB];  GO  IF SERVERPROPERTY('ProductVersion') > '12'   ALTER DATABASE [TestDB] SET QUERY_STORE=ON;  GO

Then refresh the databases to see the database:

 

Create-database-enter-code on azure

 

You should create a table in TestDB to the connected database or master. To do this, go to the created TestDB context and run the following command:

-- Create a new table called 'Customers' in schema 'dbo'  -- Drop the table if it already exists  IF OBJECT_ID('dbo.Customers', 'U') IS NOT NULL   DROP TABLE dbo.Customers;  GO  -- Create the table in the specified schema  CREATE TABLE dbo.Customers  (   CustomerId int NOT NULL PRIMARY KEY, -- primary key column   Name nvarchar(50) NOT NULL,   Location nvarchar(50) NOT NULL,   Email nvarchar(50) NOT NULL  );  GO

After running the command, right-click on tables and refresh them:

 

Create-table-to-master-on-azure

 

You can insert rows in the table that was created above by running the following query:

-- Insert rows into table 'Customers'  INSERT INTO dbo.Customers   ([CustomerId], [Name], [Location], [Email])  VALUES   ( 1, N'your_customer_name', N'your_customer_location', N''),   ( 2, N'your_customer_name', N'your_customer_location', N'your_customer_Email_Address'),   ( 3, N'your_customer_name', N'your_customer_location', N'your_customer_Email_Address'),   ( 4, N'your_customer_name', N'your_customer_location', N'your_customer_Email_Address')  GO

Now you should run the following query:

-- Select rows from table 'Customers'  SELECT * FROM dbo.Customers;

The output should look like this:

 

install Azure Data Studio on AlmaLinux

 

That’s it!

Conclusion

Azure Data Studio is built for the modern-day software engineer or data analyst and allows you to manage your cloud-based and local database servers. You can use it for both cloud-based and on-prem databases. This article taught you How to Install Azure Data Studio on AlmaLinux 8 As a video. I hope this tutorial was useful for you.

How useful was this post?

Click on a star to rate it!

Average rating 1 / 5. Vote count: 1

No votes so far! Be the first to rate this post.

View More Posts
Richard
Eldernode Writer
We Are Waiting for your valuable comments and you can be sure that it will be answered in the shortest possible time.

Leave a Reply

Your email address will not be published. Required fields are marked *

We are by your side every step of the way

Think about developing your online business; We will protect it compassionately

We are by your side every step of the way

+8595670151

7 days a week, 24 hours a day