Recently I was asked by one of my clients of Comprehensive Database Performance Health Check recently asked if there is any way to Check Backup Reliability.
SQL SERVER – Who Dropped Table? Part 2
There is a way to find out few more things. However, before we continue I strongly suggest that you watch the following video about the dropped table.
SQL SERVER – Hide Code in SSMS
Today we are going to learn something very simple but asked a lot by all of you as well as my client is that how to hide code in SSMS.
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.
SQL SERVER – Find a Table in Execution Plan
Of course yes, we can easily find a table in the execution plan with the Find Node feature of SSMS (SQL Server Management Studio).
Transactions and Variables – SQL in Sixty Seconds #150
Transactions and Variables both are not related at all. There is no impact of a transaction on a variable. Let us learn about it today.
SQL SERVER – Datatype Decimal Explained – Datatype Numeric
Just the other day I received an email from a client who was confused about the Datatype Decimal. Let us learn today how it works.