SQL Server Management Studio

Is it true that editing a single row in Management Studio empties and reloads the entire table?

by Randolph
November 27, 2019September 16, 2022

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… Read More »Is it true that editing a single row in Management Studio empties and reloads the entire table?

Introducing Azure Data Studio

by Randolph
November 29, 2017January 9, 2020

(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… Read More »Introducing Azure Data Studio

Gimmicks that work: XEvent Profiler in SQL Server Management Studio

by Randolph
November 1, 2017July 3, 2018

[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… Read More »Gimmicks that work: XEvent Profiler in SQL Server Management Studio