• Adam Thurgar

SSMS or Operations Studio ?


I just upgraded SQL Server Management Studio (SSMS) to 17.6 and the I noticed that I didn't have the latest preview of SQL Operations Studio (new acronym SOS ? or SOPS ?) so I downloaded 0.27.3 and installed that.

I am now wondering what tool should I be using moving forward?

Will Microsoft continue to support both or will all SSMS functionality be integrated into SOPS?

SOPS definitely has the Visual Studio feel that Microsoft favours, but doesn't have all the functionality that SSMS has.

I have read that SSMS is more for DBA's, whilst SOPS is more for database developers, but these days do we really have that hard distinction? I don't see people in a pure DBA role and the job now has many facets including development, more of a database utility role.

For the moment I will stick with SSMS as I am more comfortable and familiar with it, but it won't surprise me that one day in the not too distant future it will no longer be being developed or supported by Microsoft and we make the transition to SOPS.


5 views

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t