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