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.
SQL SERVER – List All Dates Between Start and End Date
We will see a very simple script where we will take advantage of the Common Table Expression and list all dates between two dates (Start and End Date).
SQL SERVER – Convert Formatted Integer Values into Date
One of my clients of Comprehensive Database Performance Health Check asked me a question about how to Convert Formatted Integer Values into Date.
SQL SERVER – Capturing INSERT Timestamp in Table
The other day while working on a topic of Comprehensive Database Performance Health Check recently asked if I know any trick for capturing insert timestamp.