Executing a stored procedure in Microsoft SQL Operations Studio(SQLOPS)

Executing a stored procedure is as easy as running query in SQLOPS.

For example, I restored the Northwind database from a backup file from CodePlex site to the default instance of SQL Server 2017 Developer's Edition.

I connected to the SQL Server 2017 in Microsoft SQLOPS as shown. Here you can see all the objects in the server.

SP_SQLOPS_0

Right click the stored procedure (herein, dbo.CustOrderHist) to display a pick list as shown.

SP_SQLOPS_1

Click Script as Execute.
A query is created as shown:

SP_SQLOPS_2

In the TODO section add-in the value of CustomerID.
Look up the data type of CustomerID as shown here:

SP_SQLOPS_3

You need to modify this query somewhat to see the results (this is Preview software). Add statements to the SQLOPS created script to read as shown here:
---------------------
USE Northwnd
GO
DECLARE @RC int
DECLARE @CustomerID nchar(5)
-- TODO: Set parameter values here.
Set @CustomerID='ALFKI'
EXECUTE @RC = [dbo].[CustOrderHist]
   @CustomerIDGO
-----------------
Now click Run and you can see the response as shown:

That's all.

Microsoft SQL Operations Studio- January Public Preview is ready

You can downlaod it from here for all of the three platforms, Windows, macOS and Linux.
https://docs.microsoft.com/en-us/sql/sql-operations-studio/download

Before using review the following:

What is SQLOPS?
https://hodentekmsss.blogspot.com/2017/12/light-weight-database-management-and.html

Description of user interface:
https://hodentekmsss.blogspot.com/2017/12/sql-operations-studio-user-interface.html

Connecting to SQL Server 2016 using SQLOPS:
http://hodentekhelp.blogspot.com/2017/12/how-do-you-connect-to-sql-server-using.html

It is very easy to download and run immediately (Windows Installer and ZIP).

Using Installer:
Download and run the SQL Operations Studio (preview) installer for Windows.
Start the SQL Operations Studio (preview) app.
Link to click: https://go.microsoft.com/fwlink/?linkid=866480

Using the ZIP file:
Download SQL Operations Studio (preview) .zip for Windows.
Browse to the downloaded file and extract it.
Run \sqlops-windows\sqlops.exe
Link to click: https://go.microsoft.com/fwlink/?linkid=866479

Supported platforms:
Windows
Windows 10 (64-bit)
Windows 8.1 (64-bit)
Windows 8 (64-bit)
Windows 7 (SP1) (64-bit) - Requires KB2533623
Windows Server 2016
Windows Server 2012 R2 (64-bit)
Windows Server 2012 (64-bit)
Windows Server 2008 R2 (64-bit)
+
macOS
macOS 10.13 High Sierra
macOS 10.12 Sierra

Linux
Red Hat Enterprise Linux 7.4
Red Hat Enterprise Linux 7.3
SUSE Linux Enterprise Server v12 SP2
Ubuntu 16.04

Uninstall:
Since it is preview, if you need to uninstall at a later date:
------------------------------------------
If you installed SQL Operations Studio (preview) using the Windows installer, then uninstall the same way you remove any Windows application.

If you installed SQL Operations Studio (preview) with a .zip or other archive, then simply delete the files.
-------------------------------------------
Enjoy!

Querying SQL Server 2017 Version 17.3 using SQLOPS

 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.

Using SQL Operations Studio

In order to use a program, it is first of all necessary to have a clear understanding of the User Interface for screen driven application.

SQLOPS when invoked brings up the user interface screen. It is here you do most of your development.

As mentioned in previous posts this is a light-weight tool. It provides a much easier interface then the SQL Server Management Studio, a heavy-weight option.

You invoke the program by double clicking the sqlops.exe in the folder where you saved the application files.

The following window is displayed:

The following icon joins the taskbar in Windows 10.

The UI is simple and the main menu items opens the following sub-menus.

The File menu item has the query related and has access to folder/file sysyem

 The Edit meu item is like any other Microsoft application (Word, Excel, ...)

The View menu item has many more important items such as Servers, Explorer,

The Help menu is important as it is here you get he main documentation as well as initial knowledge for you to start using it.

The icons in the panel on the left gives access to the tasks and the keyboard key shortcuts.

I think even non-DBA types can use this interface. It is cool!!

SQL Operations Studio - Light-weight database management and development tool

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.

Read more here:
http://hodentekhelp.blogspot.com/2017/12/what-is-sql-operations-studio.html

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.

SQLOPS user interface in Windows 10

SQL Operations Studio User Interface

In order to use a program, it is first of all necessary to have a clear understanding of the User Interface for screen driven application.

SQLOPS when invoked brings up the user interface screen. It is here you do most of your development.

As mentioned in previous posts this is a light-weight tool. It provides a much easier interface then the SQL Server Management Studio, a heavy-weight option.

You invoke the program by double clicking the sqlops.exe in the folder where you saved the application files.

The following window is displayed:

The following icon joins the taskbar in Windows 10.

The UI is simple and the main menu items opens the following sub-menus.

The File menu item has the query related and has access to folder/file sysyem

 The Edit meu item is like any other Microsoft application (Word, Excel, ...)

The View menu item has many more important items such as Servers, Explorer,

The Help menu is important as it is here you get he main documentation as well as initial knowledge for you to start using it.

The icons in the panel on the left gives access to the tasks and the keyboard key shortcuts.

I think even non-DBA types can use this interface. It is cool!!

Install the latest version of SQL Operations Studio (0.31.4)

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.

Installing Microsoft SQL Operations Studio (preview) on Windows 10

Screen shots taken while installing the January Public Preview (ver 0.25.4) of Microsoft SQL Operations Studio (MSFT SQLOPS) are included in this post. The details of this version are as shown:

SQLOPS_JANPreview.png


MSFT SQLOPS will be installed on a Windows 10 Professional on a Dell Laptop.

SQLOPS_JanPublicPreview9_Win.png

We will use the installer route to install. You start installing by double clicking the installer file you downloaded.

SQLOPS_JanPublicPreview2

SQLOPS_JanPublicPreview3

Accept license terms and click Next.

SQLOPS_JanPublicPreview4

SQLOPS_JanPublicPreview5

SQLOPS_JanPublicPreview6

SQLOPS_JanPublicPreview7

SQLOPS_JanPublicPreview8

It is installed and it is launched as shown