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.
SQL SERVER – Empty Database Authentication Cache with DBCC FLUSHAUTHCACHE
A very interesting DBCC command I recently came across and that is DBCC FLUSHAUTHCACHE. DBCC function applies to Azure SQL Database.
SQL SERVER – Last Used Stored Procedure
“Is there any way to know the last used stored procedure in SQL Server?” Well, I was asked this during Health Check.
SQL SERVER – Converting Unix TimeStamp to DateTime
There is a very easy method to convert Unix TimeStamp to DateTime. Let us learn that in today’s blog post.
SQL SERVER – Source Database in Restoring State
A client whom I often help with Health Check recently reached out to me with an interesting problem about Source Database in Restoring State.
SQL SERVER – Renaming distributor_admin Bad Idea
A client of Health Check, recently send me an email after reading best practices. Why Renaming distributor_admin Bad Idea.