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!!

Get started with latest release of Microsoft SQL Operations Studio

Read my previous articles (9) on previous versions.

Download the February (latest) release of Microsoft SQL Operations Studio here.

There are couple of enhancements over the previous release. The following has been fixed or added:

Added Auto-Update Installation feature
Added Connection Dialog ‘Database’ Drop-down
Added functionality for new query tabs keeping active connection
Fixed bugs in SQL Editor and auto-completion

This is the version I have now.

When I update, my version is:

When I launched my previous release, I could access the latest. Clicking on this I could install the latest release.

Set up preparatory stage.

I did not see a drop-down of all databases. It did not find the databases. It just reverted to default in the drop-down.

However, it could keep two query windows open at the same time, maintaining two different connections.

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

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!

Connect to SQL Server 2016 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

Run a simple query in Microsoft Operations Studio

In order to run a query in Microsoft Operations Studio you must first to connect to a database on an instance of SQL Server.

It is so easy to connect to SQL Server database.

Step 1: Understand what is meant by Microsoft Operations Studio

Read here: What is Microsoft SQL Operations Studio?

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

Step 2: Get a handle on using this new Interface

Read here: Microsoft SQL Operations Studio User Interface

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

Step 3: Learn how you may connect to SQL Server (In this example SQL Server 2016 Developer)

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

Microsoft SQL Operations Studio

Step 4: Running a query on SQL Server after connecting to Northwind database

Now that you are connected, you can access all the tables, views, etc as shown.

 For any table you have three options Select top 1000, edit or script table to create as shown.

When click on New Query icon in the Microsoft Operations Studio, the query plane is open as shown.

 You will be required to enter a query starting at Line 1. When you type SEL, the Select statement begins.

 You do not get the columns of employees as it is not yet even mentioned. Type in the rest of the query. Click Run. The results pane opens below the Select statement as shown.

 The Results pane has a few controls on the right. This is cool. Now you can export the results to CSV, JSON or EXCEL. You could also view it as a chart.

Perhaps, SSMS should have a view of viewing data as chart.

In summary, it is easy to connect to SQL Server and run queries. It should be noted that there is no syntax check for queries as well as intellisense.

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!!

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