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.
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?
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.