Friday, 17 November 2017

SOS - Save Our Souls or SQL Operations Manager

On Wednesday Microsoft Announced the release in preview of SQL Operations Studio (SOS)... What is that I hear you cry! Well I asked myself the same question and did some digging.



SQL Operations Studio a client tool for working with SQL Server... It was announced at the PASS summit last week and it hit public preview on Wednesday.

"ARE THEY GETTING RID OF MANAGEMENT STUDIO?????" I hear you scream, well  that was my initial thought too.

Fear not though, Management Studio is hear to stay, at least for now, according to this interview  in visual studio magazine of Microsoft executive  Rohan Kumar.

https://visualstudiomagazine.com/blogs/data-driver/2017/11/sql-operations-studio.aspx

Q: Will this tool replace SSMS?
A: It is not in our roadmap.

It's not a No. So not necessarily conclusive. "It is not in our roadmap" - I keep adding a "yet" to the end of that sentence. Road-maps do change overtime but I think we can assume that SQL Operations Manager will be around for a while yet.

I downloaded SQL Operations Studio earlier today and from the download page I can instantly how this differs from SQL Server Management Studio. Its cross-platform! Download SQL Operations Studio

You can run SQL Operations Studio  on Linux, Mac OS and Windows - Management Studio  only  runs on Windows.

SQL server 2017 can run on non-windows operating systems, its stands to reason that Microsoft might want a client tool that can connect and work from SQL Server on non windows operating system too. SQL Server is now multi-platform!

I have heard SQL Operations Manager being  described as SSMS lite - I have also heard and seen questions asked on social media such as, "is SQL Operations Manager for Devs?" The official answer according to the interview is  "it's for Developers and Ops" 
Hmmm Dev Ops maybe? - everybody's favourite buzz word at the moment.

From the quick look around SOS I have managed to squeeze in this week it has a different look and feel to Management Studio.

Anyway we'll have a look at SQL Operations Studio in a  more detail and report back in a few other posts and maybe a video

No comments:

Post a Comment

Featured post

Creating a Linked Server to an Azure SQL Database

Why would you create a Linked Server to an Azure SQL Database? If you work in a hybrid environment with some databases stored on your on ...