Azure Data Studio vs SQL Server Management Studio part 3

This post continue to look at the differences between Azure Data Studio and SQL Server Management Studio. This post is focus on Security. In SSMS you can find a dedicated Security node.


In ADS is the same, it has a dedicated Security node.


When you right click a credential such as sa. There will be a list of shortcut menu. The most important item in the list is actually the Properties. That allow you to grant permission to a database, define the role(s) for that credential and more.


In ADS, beside a Refesh, when I was right clicking the credential, there is nothing else.


In SSMS, when you click on a security role. There is also a list of item display in a shortcut menu.

In ADS, it is still only the Refresh for now. Whether Microsoft going to extension the features?

Resources:

https://chanmingman.wordpress.com/2019/03/10/azure-data-studio-vs-sql-server-management-studio-part-1-2/

https://chanmingman.wordpress.com/2019/03/14/azure-data-studio-vs-sql-server-management-studio-part-2/

About chanmingman

Since March 2011 Microsoft Live Spaces migrated to Wordpress (http://www.pcworld.com/article/206455/Microsoft_Live_Spaces_Moves_to_WordPress_An_FAQ.html) till now, I have is over 1 million viewers. This blog is about more than 50% telling you how to resolve error messages, especial for Microsoft products. The blog also has a lot of guidance teaching you how to get stated certain Microsoft technologies. The blog also uses as a help to keep my memory. The blog is never meant to give people consulting services or silver bullet solutions. It is a contribution to the community. Thanks for your support over the years. Ming Man is Microsoft MVP since year 2006. He is a software development manager for a multinational company. With 25 years of experience in the IT field, he has developed system using Clipper, COBOL, VB5, VB6, VB.NET, Java and C #. He has been using Visual Studio (.NET) since the Beta back in year 2000. He and the team have developed many projects using .NET platform such as SCM, and HR based applications. He is familiar with the N-Tier design of business application and is also an expert with database experience in MS SQL, Oracle and AS 400.
This entry was posted in .Net, Cloud, Community, Computers and Internet, Data Platform and tagged , , . Bookmark the permalink.

1 Response to Azure Data Studio vs SQL Server Management Studio part 3

  1. Mark Burns says:

    Worse, with SSMS 18.x versions, key features like Source Control support are now left on the cutting room floor (which is curious from several points of view, not the least of which is that the Visual Studio product that architecturally underlies the new SSMS 18.x version DOES include Source Control support, the SSMS coding team had to actually _deliberately excise it_ from SSMS).
    Yet, questions on that subject are given replies from MS like “Oh, well Azure Data Studio supports Source Control.” Oh yeah? Where are the tutorials for that? …and how does it actually replace the need for Source Control of SQL Server entities (from _any_ means of modification: SSMS, SMO, AzureDS)? Obvious Answer: It doesn’t.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.