Today we are going to see some of the courses authored by my friend Jaya Bodkhey on Java and C at Pluralsight. They are very interesting.
SQL Puzzle – SELECT ~ 1 : Guess the Answer
Of course, I have one where you have to guess the answer for a simple select statement. Let us see if you can guess it correctly or not.
Learn SQL Fundamentals for FREE
Team DataQuest has three SQL Server Courses which are absolutely free and help to get started with the SQL fundamentals. Let us learn.
SQL SERVER – Parallelism and Threads with No Work
One of my repeat clients asked me if a query goes to parallel do they use all the threads. We can have parallelism and thread with no work.
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.
Free All Pluralsight Courses for April 2021
Pluralsight is repeating the history again by announcing all the courses for FREE access for April 2021. Yes, you read it a reality.
SQL SERVER – Top 1 and Index Scan
Scans are not always bad they are there because they are needed. Let us see a very simple demonstration about Top 1 and Index Scan.
SQL SERVER – Cached Data Per Object in Memory
“How to build a list of cached data per object in memory pool?” I just received this question from my client who hired me for Health Check.
SQL SERVER – Disable Adaptive Joins
My client sent me an interesting scenario where a query with adaptive join was performing badly. Let us learn how to disable adaptive joins.