'Azure Data Studio (ADS) is getting all sorts of love and attention these days. So much so that they have finally gotten around to adding Extended Events (XE) to the tool – sort of. Now we have the power to run traces on SQL Server via ADS.
The presence of XE in ADS comes via an extension and comes with a few other caveats. I will explore the extension for XE available in ADS in this article and discuss some of the caveats. As you read the article, it might be helpful to go ahead and download ADS if you do not already have it.'...
http://jasonbrimhall.info/2018/11/21/azure-data-studio-and-xevents/
'Microsoft has a number of security features in SQL Server 2017 that are useful for different purposes, depending on what you are trying to protect and what threat(s) you are trying to protect against. Some of these security features can have performance implications that you should be aware of as you decide which ones you want to implement. As an introduction, I’ll cover some the highlights of several of these security features.
- Transparent Database Encryption (TDE)
- Row-Level Security (RLS)
- Dynamic Data Masking (DDM)'...
https://sqlperformance.com/2018/12/sql-server-2017/security-features
'If you’re on SQL Server 2016 or above, maybe you’re thinking about using the Query Store. That’s good! It’s an incredibly useful tool for performance tuning, and it can help you scale to handle performance on many servers.
There’s one thing I think you should know. The max size limit for the Query Store is not a hard limit.'...
http://www.dba-art.com/query-store-max-size/
'There are so many tools within SQL Server Management Studio (SSMS) that can make your job as a DBA or Developer easier that you may or may not be using. One of the tools available is the customization of the Scroll Bar. You can change the display and the behavior of the scroll bars, which can make working with code a lot easier and more efficient, especially when working with long code. The two options we will discuss are Scroll Bar Display and Behavior.
To change the settings, go to:
Tools > Options > Text Editor > All Languages > Scroll Bars'...
https://witsociety.wordpress.com/2018/12/13/sql-server-management-studio-scroll-bar-enhancements/
'Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, MacOS, and Linux.
Previously released under the preview name SQL Operations Studio, Azure Data Studio offers a modern editor experience with Intellisense, code snippets, source control integration, and an integrated terminal. It is engineered with the data platform user in mind, with built in charting of query result sets and customizable dashboards.'...
https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is?view=sql-server-2017