How do you install the latest SQL Operations Studio?

I was using SQL Operations Studio (SQLOPS) Ver 0.26.7 and I am upgrading to the July 2018 Public Preview version 0.31.4.

It is Available on Windows, macOS and Linux and you can download from here:
https://docs.microsoft.com/en-us/sql/sql-operations-studio/download?view=sql-server-2017


Installation procedute for all the OS's available on the above site.

This is the file for Windows OS:
sqlops-windows-setup-0.31.4.exe (74.3 MB)

Double click the executable to launch the application.
Here are the installation screen shots.

Accept license terms.

 The program is added to the PATH and you can launch soon after installing.

I connected to the SQL Server 2016 named instance after launching.

In the Preview you can see a number extensions that you will be able to access.

How do you use SQL Server Agent in SQL Operations Studio(SQLOPS)?

You must install the July update to SQLOPS (July 2018 Public Preview version 0.31.4)  to access the extensions. You find the SQL Server Agent extension in the extensions MARKET place as shown here.

Agent_0

Troubleshooting SQL Server Agent jobs and configuration is the most important aspects of ths extesion.

Things you can ddo with this extension in SQLOPS:
List SQL Server Agent Jobs configured on a SQL Server
View Job History with job execution results
Basic Job Control to start and stop jobs

You need to install before you use it which can implemented inside SQLOPS.

Agent_1

Installing is as easy as clicking the Install button.

Agent_2

The Agent screen is broken in the right pane above. Perhaps it is not turned on.

I start the agent inside SSMS 17. SQL Server Agent starts and it turns green in the Object explorer.

With this I should be able to see the July 2018 Public Preview version 0.31.4 in SQLOPS. I have tried both SQL Server 2016 and SQL Server 2017. I have seen the SQL Server Agent in some earlier screen shots.

However, off the extension you see a tabbed page as shown.

This extension may not work with SQL Server 2016 Agent.

Here is the same job you would see on SQL Server 2017.

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

What is SQL Operations Studio?

Well there is a heavy-weight tool, SQL Server Management Studio that is installed as a separate application from SQL Server installation (used to be a part of the SQL Server installation).

SQL Operations Studio is a lighter tool. It is free and you can carry out database development operations using it. It is available for SQL Server on Windows, Linux and Docker, Azure SQL Database and Azure SQL Data warehouse on Windows, Mac or Linux.

The preview version became available in November of 2017.

If you would like to use it you need to download the version you want from here:

I downloaded the Windows version. You need to extract the files into a folder. 

The executable is sqlops.exe and it is indeed a small file.