By using this site, you acknowledge that you have read and understand our Cookie policy, Privacy policy and Terms .

If you have used Visual Studio Code, you probably will also enjoy a new client tool SQL Operations Studio. Currently it is available as preview version and not formally released yet.

What is SQL Operations Studio

SQL Operations Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. It is very lite compared with SSMS (SQL Server Management Studio) but still easy to use and powerful.

Open source code

If you are interested in the source code, visit the following link:

https://github.com/Microsoft/sqlopsstudio

More details about download and install

Please refer to the following page to install. You can install it in Windows, macOS and Linux.

What is Microsoft SQL Operations Studio (preview)?

Sample interface

image

Sample interface when running in Linux openSUSE

image

Have fun!

info Last modified by Raymond at 2 years ago * This page is subject to Site terms.

More from Kontext

local_offer pyspark local_offer spark-2-x local_offer teradata local_offer SQL Server

visibility 45
thumb_up 0
access_time 12 days ago

In my previous article about  Connect to SQL Server in Spark (PySpark) , I mentioned the ways t...

open_in_new View

local_offer python local_offer SQL Server

visibility 132
thumb_up 0
access_time 2 months ago

Python JayDeBeApi module allows you to connect from Python to databases using Java JDBC drivers.

open_in_new View

Spark Read from SQL Server Source using Windows/Kerberos Authentication

local_offer pyspark local_offer SQL Server local_offer spark-2-x

visibility 134
thumb_up 0
access_time 2 months ago

In this article, I am going to show you how to use JDBC Kerberos authentication to connect to SQL Server sources in Spark (PySpark). I will use  Kerberos connection with principal names and password directly that requires  ...

open_in_new View

local_offer lite-log local_offer spark local_offer pyspark

visibility 2141
thumb_up 0
access_time 9 months ago

When creating Spark date frame using schemas, you may encounter errors about “field **: **Type can not accept object ** in type <class '*'>”. The actual error can vary, for instances, the following are some examples: field xxx: BooleanType can not accept object 100 in type ...

open_in_new View

info About author

Kontext Column

Kontext Column

Created for everyone to publish data, programming and cloud related articles. Follow three steps to create your columns.

Learn more arrow_forward
info Follow us on Twitter to get the latest article updates. Follow us