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 – Function to Calculate Simple Interest
It was very surprising that they would write a complicated function. Let us see a very simple way to write Function to Calculate Simple Interest.
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 – CHECK CONSTRAINT to Allow Only Digits in Column
My client during Comprehensive Database Performance Health Check. Today we will learn about CHECK CONSTRAINT to Allow Only Digits in Column.
CONCAT and NULL – SQL in Sixty Seconds #123
I have decided to convert the blog into the video of SQL in the Sixty Seconds. Let us learn about CONCAT and NULL – SQL in Sixty Seconds #123.
SQL SERVER – NULL Values and CONCAT Function
A lot of SQL in the Sixty Seconds video recently, we will be looking at a very interesting T-SQL CONCAT function and how it works with the NULL Values.
SQL SERVER 2019 – Disabling Scalar UDF Inlining
Working on the Comprehensive Database Performance Health Check, we will learn how I helped a client by Disabling Scalar UDF Inlining in SQL Server 2019.