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.
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.
SQL Express Size Limit for Data File
A client of mine. who is using SQL Server Express recently reached out to me to know SQL Express Size Limit for Data File?
SQL SERVER – Identify Table Creation Date from Traces
I often discuss this during Comprehensive Database Performance Health Check. Let us learn about how to Identify Table Creation Date from Traces.