My client reached out to me asking if there is a way to measure the performance of the newly created index. How to measure index performance.
A very interesting DBCC command I recently came across and that is DBCC FLUSHAUTHCACHE. DBCC function applies to Azure SQL Database.
There is a very easy method to convert Unix TimeStamp to DateTime. Let us learn that in today’s blog post.