“Can I Change Join Type for Query?” I was recently asked this during  Comprehensive Database Performance Health Check. Of course Yes!
Install Python3 on Linux
My major focus is always on SQL Server. I know a little bit about other technology as well. It is very straightforward to install Python3 on Linux.
SQL Puzzle – Unsolved CASE Expression
Lots of people have asked me to share another puzzle. Well, let us see a very simple puzzle of Unsolved CASE Expression in today’s blog post.
SQL SERVER – Change Password at the First Login
Just like many other databases and applications, SQL Server also supports the feature to change password at the first login.
SQL SERVER – AdHoc Queries and Optimize for Adhoc Workloads
Discussion with a client during the Comprehensive Database Performance Health Check. The topic is AdHoc Queries and Optimize for Adhoc Workloads.
Neutralize Troublesome SQL Server Indexes – Fun Stories & Demos – Video
This video is hosted on SQLPASS youtube channel: Neutralize Troublesome SQL Server Indexes – Fun Stories & Demos. Let us watch it.
SQL SERVER – Map SQL Server Session ID to OS Thread ID
He wanted to track the OS Thread ID in Performance Monitor. He asked me if I know any script which can Map SQL Server Session ID to OS Thread ID.Â
Top 5 SQL in Sixty Seconds Videos
I have received lots of views and comments over them. Today we will be seeing the top 5 SQL in Sixty Seconds Videos.
Java and C at Pluralsight
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.