VRB News
Virtual Reality Brisbane
  • Home
  • About us
  • IT news
  • Tech
  • World
  • Contact
No Result
View All Result
  • Home
  • About us
  • IT news
  • Tech
  • World
  • Contact
No Result
View All Result
No Result
View All Result
Home IT news

Manage SQL Server with Azure Data Studio

admin by admin
June 30, 2021
in IT news
0
Manage SQL Server with Azure Data Studio
0
SHARES
32
VIEWS
Share on FacebookShare on Twitter

Alternative to Microsoft SQL Server Management Studio Manage SQL Server with Azure Data Studio

Azure Data Studio allows you to manage SQL databases based on Microsoft Azure or Microsoft SQL Server. The tool is available for free for Windows, Linux and macOS.

Companies on the topic

SQL databases can be managed through Azure Data Studio.SQL databases can be managed through Azure Data Studio.

Microsoft Azure Date Studio (formerly SQL Operations Studio) can be used on Windows, Linux, and macOS machines to manage SQL databases in Azure and on Microsoft SQL servers. SQL Server Big Data Clusters can also be connected to the system.

Getting Started with Azure Data Studio

Azure Data Studio also supports IntelliSense in a much more modern form than Management Studio for queries. Basically, Microsoft SQL Server Management Studio and Azure Data Studio can be used in parallel. Azure Data Studio has its advantages especially in queries and notebooks.

Azure Data Studio offers functions for managing SQL servers, but also enables the integration of Jupyter notebooks. Azure Data Studio can not only be used to manage resources in Microsoft Azure, but also supports the management of local SQL servers. With the tool, the connection to Azure is possible, but not necessary.

Image gallery

Picture gallery with 13 pictures

When installing the tool on Windows, there is also the option to download the installation file for the user context. This allows database administrators on Windows 10 PCs to perform the installation and use the tool even without admin rights on the PC. In addition, Microsoft also provides a portable version that does not need to be installed.

Manage SQL Server with Azure Data Studio

After installing Azure Data Studio, a new connection to a database server can be established from the New connection tab. The connection is the same as connecting a new server to the SQL Server Management Studio. Already at the login, you can select which files the tool should be connected to.

In general, however, all databases for which the corresponding user account has access rights are available on the server in a connection. The last connections can be found at the top of “Recent Connections” and “Saved Connections”.

However, Azure Data Studio does not focus on the connections to the database server and the subsequent administration. Already when connecting to a database server, new queries can be created. New notebooks can also be created with Azure Data Studio. This makes the tool particularly interesting in the field of data analysis. The various connections and notebooks are displayed in the Azure Data Studio at the top as separate tabs.

Manage Azure resources in Azure Data Studio

In Azure Data Studio, administrators or developers can use a central window to manage SQL resources on local servers and in Microsoft Azure. After logging in to Microsoft Azure, the Connections resources are available below Servers on Azure. After logging in to Azure, the various resources are available in Azure.

Manage, backup and restore databases

From the context menu of databases, new queries, notebooks or a data backup can be performed in Azure Data Studio. Database recovery is also possible with Azure Data Studio. The backup can be done through the graphical interface in Azure Data Studio, but the tool also displays the SQL commands that can also be used to create backups as a query.

Compression and encryption can also be carried out as part of the backup. Azure Data Studio displays the options for this when selecting the backup options. Backups can be encrypted with AES 128/192/256 and with Triple DES. The result of the backup shows Azure Data Studio at the bottom of the window.

In the lower area of the administration window, a PowerShell session can also be created within Azure Data Studio using the “Terminal” menu item. With some rework, other shells can also be connected at this point.

Install Extensions-Extend features of Azure Data Studio

After starting the Azure Data Studio, extensions for Azure Data Studio can be installed via the extension icon on the left side at the bottom. The extensions enable more features in Azure Data Studio.

For example, PostgreSQL databases can also be managed with extensions. For the extensions, Microsoft goes the same way in Azure Data Studio as in Visual Studio.

Important functions such as SQL Server Agent are also available with the extensions. These can be used to plan tasks with the Azure Data Studio, for example, the execution of notebooks.

Notebooks with Azure Data Studio

Azure Data Studio can also be used to create notebooks based on different kernels. In addition to SQL, this also includes PySpark, Scala, R, Python and the PowerShell. On the basis of the languages, the documents are created, which can contain various statements, for example, queries. The advantage of the notebooks is that the results of the queries can be constantly updated.

The Azure Data Studio is particularly interesting with regard to notebooks due to the Python support. This makes it possible to create Jupyter notebooks. The notebooks can be backed up as JSON files. In general, Azure Data Studio also saves the last query result with the notebook.

Deployments with Azure Data Studio

With Azure Data Studio, resources can also be deployed through deployments. Here are options for deploying Azure SQL Database, SQL Servers, SQL Server Container Image, SQL Server on Azure Virtual Machine, and SQL Server Big Data Cluster. Azure Arc and Azure SQL Edge can also be deployed through the deployments in Azure Studio.

Image gallery

Picture gallery with 13 pictures

(ID: 47486705)

Previous Post

Vcluster v0. 3 passes Kubernetes compliance tests

Next Post

What you should know about the new standard contractual clauses of the EU, with Stephan Heimel from SEPPmail

admin

admin

Related Posts

We already have prices and models of the Kia EV6 in Mexico, the brand’s first electric SUV
IT news

We already have prices and models of the Kia EV6 in Mexico, the brand’s first electric SUV

December 6, 2023
BBC cancels Top Gear show indefinitely, due to accident
IT news

BBC cancels Top Gear show indefinitely, due to accident

December 3, 2023
These are the 10 most reliable automotive brands in Mexico this 2023
IT news

These are the 10 most reliable automotive brands in Mexico this 2023

November 30, 2023
Why Top Organizations Partner with Custom eLearning Development Companies
IT news

Why Top Organizations Partner with Custom eLearning Development Companies

November 29, 2023
Scientists are using bacteria to recycle electric car batteries
IT news

Scientists are using bacteria to recycle electric car batteries

November 27, 2023
Next Post
Encrypted data against physical attacks

What you should know about the new standard contractual clauses of the EU, with Stephan Heimel from SEPPmail

Premium Content

playing PC games without cables will be possible (officially) thanks to Oculus Air Link

playing PC games without cables will be possible (officially) thanks to Oculus Air Link

February 19, 2022
Magic Leap concept video

Magic Leap concept video

July 1, 2022
MERLION signed a distribution agreement with IEK

MERLION signed a distribution agreement with IEK

August 13, 2020

Browse by Category

  • Games
  • IT news
  • Tech
  • World

VRB News is ready to cooperate with webmasters and content creators. Send an email to info@virtualrealitybrisbane.com

Categories

  • Games
  • IT news
  • Tech
  • World

Recent Posts

  • We already have prices and models of the Kia EV6 in Mexico, the brand’s first electric SUV
  • BBC cancels Top Gear show indefinitely, due to accident
  • These are the 10 most reliable automotive brands in Mexico this 2023

© 2023 - The project has been developed ServReality

No Result
View All Result
  • Home
  • About us
  • IT news
  • Tech
  • World
  • Contact

© 2023 - The project has been developed ServReality

Are you sure want to unlock this post?
Unlock left : 0
Are you sure want to cancel subscription?