SQL Server Management Studio uses the Visual Studio installer
Yes, SSMS 21 uses the Visual Studio installer. No, you don’t need to download it every time. No, you don’t need a Visual Studio license to use it.
Is it true that editing a single row in Management Studio empties and reloads the entire table?
TL;DR: No. A customer recently brought up an interesting thesis, that if you edit a table’s values using SQL Server Management Studio (SSMS) using the edit feature, that the table is dropped and recreated in… Is it true that editing a single row in Management Studio empties and reloads the entire table?
Introducing Azure Data Studio
(Last edited on 9 January 2020) Note: This was originally written for the book SQL Server 2017 Administration Inside Out, but did not meet the publishing deadline. A revised version is now included in the… Introducing Azure Data Studio
Gimmicks that work: XEvent Profiler in SQL Server Management Studio
[2018-07-03 edit: The original name of this feature was XE Profiler, but it was changed to XEvent Profiler in SSMS 17.4.] I have a favourite new feature of SQL Server Management Studio 17 (SSMS), and… Gimmicks that work: XEvent Profiler in SQL Server Management Studio