There is a very easy method to convert Unix TimeStamp to DateTime. Let us learn that in today’s blog post.
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.
Current Date Time in Python and SQL
After installing and getting started with Python, the very first exercise I did was to print the current date time in Python. Let us learn about it today.
SQL SERVER – Find Business Days Between Dates
I often receive a very common question during my Comprehensive Database Performance Health Check about how to find Find Business Days Between Dates.
SQL SERVER – Display Dates in Different cultures FORMAT
Today we are going to learn a very simple and interesting concept used very little. It is about how to Display Dates in Different cultures FORMAT.
SQL SERVER – CONVERT Empty String To Null DateTime
Let us learn today how to CONVERT Empty String To Null DateTime. While I focus on SQL Server Performance Health Check, let us learn about it today.
SQL SERVER – Convert Date Time AT TIME ZONE
My client last week about Comprehensive Database Performance Health Check. The question was how to Convert Date Time AT TIME ZONE.