I have helped my clients with MySQL Performance when I know the solution. Let us discuss Slow Query and innodb_buffer_pool_size.
Experience – My Very First YouTube Live
Today I am going to share my experience with my very first YouTube Live. I realized that there is a lot of improvement required in my efforts, and I also need to bring some more fineness in my presentation. Let us discuss that in detail.
SQL SERVER – 5 Recent Underperforming Videos – Dec 2020
Today we are going to see the 5 recent underperforming videos. I often build short videos based on my real-world experience.
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.
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.
SQL SERVER – What is Latch?
Earlier I wrote about SQL SERVER – SQLOS Scheduler and the Process States, lots of people liked the blog post and asked me another question – What is Latch?