During the recent Comprehensive Database Performance Health Check, I got a question from a client if there is an easy way to figure out the Network port.
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.
5 SQL in Sixty Seconds Video on SSMS Efficiency
I make my living by Comprehensive Database Performance Health Check and one of the constant struggles which I see of my client is to use SSMS Efficiency.Â
SQL SERVER – Configurable KeyBoard Query Shortcuts for SSMS
Today we will learn something very simple but fun stuff for SQL Server Management Studio (SSMS) which is about Configurable KeyBoard Query Shortcuts.
SQL SERVER – Logical Processing Order of the SELECT Statement
Why the result we get is the result we get. The answer is very simple – it is because of the Logical Processing Order of the SELECT Statement.
SQL SERVER – Disable Statistics Update for a Single Table
Recently I had encountered an interesting issue with one table where we had to disable statistics update for a single table. How we can do that?
PostgreSQL Learning Path at Pluralsight
Today I want to share PostgreSQL Learning Path at Pluralsight where you can learn this technology systematically. PostgreSQL is known as Postgres as well.