This is a very interesting function and it helps us to list databases where User Has DB Access. Well, it is pretty straightforward to know with the help of function HAS_DBACCES.
Lots of people who watched the video also asked me to build a similar video. Let us see today a video where I explain how to detect memory pressure.
Recently, I got the opportunity to talk about SQL Server, Snowflake, IT Industry Advice on the Datascape Podcast. SQL Server Performance Tuning
I am sure by this time you all are aware that Microsoft has announced SQL Server 2022. It will be released sometime next year.
Today I complete my 15th year of blogging at SQLAuthority.com. I am truly honoured that many are reading my blog after 15 years.