Discussion with a client during the Comprehensive Database Performance Health Check. The topic is AdHoc Queries and Optimize for Adhoc Workloads.
Azure Free Courses at Pluralsight
I also work on SQL Azure, MySQL, MariaDB, PostgreSQL as well as Visualization areas. I am going to share details about Azure Free Courses at Pluralsight.
SQL Azure – Install Module Fails with Error
My client told me that they need help with an error related to Install Module on SQL Azure. Let us learn how we can fix the error.
Kali Linux Installation Error Fix: An installation step failed. You can try to run the failing item again from the menu, or skip it and choose something else
W made a huge change in the server and needed to reboot the environment, during that time I witness errors related to Kali Linux Installation.
SQL SERVER – Adaptive Threshold Rows
Today we are going to learn about what drives the decision to join Adaptive Join. Well, the answer is very simple – Adaptive Threshold Rows.
SQL SERVER – Table or View – OBJECTPROPERTY
Let us learn how I use a quick trick to know the object property with the keyword OBJECTPROPERTY. Let us learn how we can figure it out.
SQL SERVER – Maximum Column Per Index – 32
Well, the answer is you can have 32 Maximum Column Per Index but that does not mean you should have 32 indexes. Let us learn today.