Many did not believe in the real world and based on the request, I have made the recent video on the same topic of the bitwise puzzle.
Android Greenbox Around Icon – Unable to Scroll
I thought it might be just a temporary thing and I had restarted it but that was not the case. In My android phone, I had a Greenbox Around Icon.
SQL SERVER – Change Join Type for Query
“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.