Tuesday, December 12, 2017

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?

Step 2: Get a handle on using this new Interface

Read here: Microsoft SQL Operations Studio User Interface

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.

No comments:

Post a Comment

What is SQLOISIM? What is it used for in SQL Server?

SQLIOSIM is a tool for simulating SQL Server IO. SQLIOSIM performs reliability and integrity tests on the disk systems that SQL Server uti...