I had implemented Data Compression at my client Performance Health Check. Let us discuss how we can estimate compression.
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.
Today I complete my 15th year of blogging at SQLAuthority.com. I am truly honoured that many are reading my blog after 15 years.
A very interesting DBCC command I recently came across and that is DBCC FLUSHAUTHCACHE. DBCC function applies to Azure SQL Database.