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.
Read-Only Routing for Availability Group Replicas
Configure availability group read-only routing, listener connections, replica URLs, balanced lists, and verification after failover.
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 SERVER – List of Trace Events
I posted a blog post SQL SERVER – Identify Table Creation Date from Traces. Let us see how to see all the list of trace events.
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?