How do you install Azure Data Studio?

As per previous post SQL Operations Studio has become Azure Data Studio.
You can download from this site here:

https://docs.microsoft.com/en-us/sql/azure-data-studio/download?view=sql-server-2017

You will be downloading this executable file:
azuredatastudio-windows-setup-1.2.4.exe (77,371KB)

You can double click and install. Here are some instllation screen shots.

After clicking Finish you should find the app added to your All Programs.

Because of your choice, the file will be in this folder.

C:\Program Files\Azure Data Studio\azuredatastudio.exe (64.5MB)

Does Microsoft SQL Operations Studio support Windows Power Shell?

Yes. It does.
You can access the console in Microsoft SQL Operations Studio by clicking this option in the User Interface as shown.

PS_SQLOPS_0.png

This displays the terminal.

PS_SQLOPS_1.png

The following version of Power Shell is supported:

PS_SQLOPS_2.png

How can I connect to SQL Server with an IP Address using Microsoft Operations Studio?

Take for example, SQL Server 2017 Developer's edition. It is the latest release version. When you install it you can only access using 'localhost' as shown.

Enter localhost

SQLServrConfig0

Click Connect and you are connected as shown.

SQLServrConfig00

Now instead of localhost, try the IPAddress as shown.

SQLServrConfig4

Trying to Connect you get the following message.

The reason for this is that the Protocols for MSSQLSERVER (the instance we are considering) has only Shared Memory enabled as in the SQL Server Configuration Manager.

SQLServrConfig1

The error message indicated that it was due to Named Pipe provider error.

Let us enable Named Pipes protocol in SQL Server Configuration Manager as shown.

SQLServrConfig2

Make a note that when you change (enable/disable), you need to stop and start the server. You can do this in SQL Server Configuration Manager.

Now attempt to connect using IPAddress as before.

SQLServrConfig4

Click Connect and you are connected as shown.

SQLServrConfig3

That is all there is to it. 

How do you restore a database from its backup using Microsoft SQL Operations Studio?

It is quite easy. In fact you can restore Northwind database from the CodePlex site to SQL Server 2017 Developers edition.

Watch this video on YouTube:
https://www.youtube.com/edit?o=U&video_id=-KOXjlRACSU

Read this post of how you may do this using SQL Server Management Studio:
http://hodentekhelp.blogspot.com/2017/07/how-do-you-restore-database-from-its.html


If you are interested in installing SQL Server 2017 Developer Edition on Windows 10 Pro.
Read this post:
https://hodentekmsss.blogspot.com/2017/12/installing-sql-server-2017-developer-on.html

Restore using Windows PowerShell:
https://hodentekmsss.blogspot.com/2016/03/easy-way-to-backup-sql-server-database.html

There are no user databases in my SQL Server 2017, can I connect to it using Microsoft SQL Operations Studio?

Yes you can. There are already system databases. Make sure that the server has started. Start it if it has not started in Control Panel, or otherwise.

I have a default instance of SQL Server 2017 Verion 17.3 and I connect to it as described here.

Launch SQLOPS from its shortcut and click New Connection as shown

SQLServer17SQLOPS_0

The New Connection window opens as shown.

SQLServer17SQLOPS_1

Enter the items as shown.

SQLServer17SQLOPS_3

Click Connect.
You are connected as shown.

Click New Query to open a new query window as shown.

SQLServer17SQLOPS_6

Type S and a drop-down list appears.

SQLServer17SQLOPS_7

Complete a query as shown:

SELECT @@version

SQLServer17SQLOPS_8

Click Run and review the result as shown:

SQLServer17SQLOPS_9

Right click the result, copy and paste it in Notepad as shown:

Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64)  Aug 22 2017 17:04:49  Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro Insider Preview 10.0 (Build 17025: ) (Hypervisor)

Note: It was mentioned that you type in msdb as a database. In fact just localhost is all that is neccessary to connect.

How do you connect to SQL Server using Microsoft SQL Operations Studio?

It is so easy to connect to SQL Server database.

Read here: What is Microsoft SQL Operations Studio?
http://hodentekhelp.blogspot.com/2017/12/what-is-sql-operations-studio.html

Read here: Microsoft SQL Operations Studio User Interface
https://hodentekmsss.blogspot.com/2017/12/sql-operations-studio-user-interface.html

Watch this video: Connecting to SQL Server 2016 Developer edition database using
Microsoft SQL Operations Studio