SQL Operations Studio

Prashanth Jayaram

Getting started with SQL Operations Studio (SOS); initial installation and configuration

August 14, 2018 by

Microsoft SQL Operations Studio is a new GUI-based (vs CLI) lightweight tool for developing and managing your modern SQL databases. The tool resembles Microsoft’s lightweight code editor, the open source IDE Visual Studio Code in terms of functionalities and the UI in general. If you’ve used Visual Studio Code (or VS Code), you’d feel at home with SQL Operations Studio. SQL Operations Studio also integrates really well other products like Azure SQL Database and Data Warehouse has been made very simple. SQL Operations Studio is a cross-platform tool available for Linux, Windows, and Mac to manage the SQL Server databases. You can go ahead and download Microsoft SQL Operations studio to try it out!

Read more »
Prashanth Jayaram

Backup and Restore operations with SQL Server 2017 on Docker containers using SQL Operations Studio

July 19, 2018 by

In this 18th article of the series, we will discuss the concepts of database backup-and-restore of SQL Server Docker containers using SQL Ops Studio (SOS). Before proceeding, you need to have Docker engine installed and SQL Ops studio configured on your host machine.

This article covers the following topics:

  1. Overview of SQL Operations Studio (SOS)
  2. How to use SQL Ops Studio integrated terminal
  3. Definition of Docker containers
  4. Step by step instructions to initiate backup-and-restore of SQL Server 2017 Docker containers using the SQL Ops Studio interface
  5. And more…
Read more »