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.Â
Why should you attend the PASS Data Community Summit?
I was one of those cheering on from the sidelines. Let us learn Why should you attend the PASS Data Community Summit?
SQL SERVER – Fix Error – Cannot execute as the database principal because the principal “dbo” does not exist
One of my clients recently sent me an email with the following error. The error was visible in the error log and was about the database principal.Â
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.
MySQL Learning Path
Learning should never stop and particularly new technology, every year, I focus on learning new technology. Today I am sharing the MySQL Learning Path.
SQL SERVER – Adjust Memory with Dedicated Administrator Connection (DAC)
the services did not start at all. Let us learn today how to Adjust Memory with a Dedicated Administrator Connection (DAC).
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.