paint splatter on glass panel

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 the background when you commit the changes. This is false, but there had to be a good reason why they
-> Continue reading Is it true that editing a single row in Management Studio empties and reloads the entire table?

T-SQL aside: replace PRINT with RAISERROR

I was minding my own business innocently reading a blog post by Erik Darling, when this tip smacked me in the proverbial forehead. I even learned something that had always bothered me but had been too lazy to investigate further. Tip #4: Know Your Place Don’t be afraid to use RAISERROR to mark off sections
-> Continue reading T-SQL aside: replace PRINT with RAISERROR

Introducing Azure Data Studio

[Last edited on 15 November 2019] Note: This was originally written for the book SQL Server 2017 Administration Inside Out, that did not meet the publishing deadline. A version of it is included in the book SQL Server 2019 Administration Inside Out, so there’s a good chance this post may be modified or deleted at some
-> Continue reading 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 that’s XEvent Profiler, which allows you to monitor your instance in real time using Extended Events from inside SSMS with just
-> Continue reading Gimmicks that work: XEvent Profiler in SQL Server Management Studio

Post image

SQL Server Management Studio v17.0

Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server, was decoupled from the server product for SQL Server 2016. For the last 18 months or so, we have been receiving semi-regular updates to SSMS (which we can download from Microsoft, for free), which is
-> Continue reading SQL Server Management Studio v17.0