I have an interesting experience to share about the Query Ignoring CPU Threads. I was hired by a large eCommerce organization.
SQL SERVER – OS Threads Used by SQL Scheduler
Today we will answer the question asked by my client during Comprehensive Database Performance Health Check, about OS Threads Used by SQL Scheduler.
SQL SERVER – CONVERT Empty String To Null DateTime
Let us learn today how to CONVERT Empty String To Null DateTime. While I focus on SQL Server Performance Health Check, let us learn about it today.
Apache2 Linux – Common Commands
I do not remember all the commands all the time so I had written down a few of the commands which I was using with Apache2 Linux.
SQL SERVER – List Service Broker Queue Count
Clients ask me questions, I try my best to help if I know the answer. Recently I was asked if I know the how-to List Service Broker Queue Count.
SQL SERVER – Enable or Disable All Triggers
As soon as we did disable all triggers on the tables, we were able to see a huge performance improvement. Let us learn how we can do it.
SQL SERVER – Function to Calculate Simple Interest
It was very surprising that they would write a complicated function. Let us see a very simple way to write Function to Calculate Simple Interest.
SQL SERVER – Difference Between Count and Count_Big
Let me answer you first – there is no difference between Count and Count_Big in terms of functionality. They are almost the same.
Impact with Slowloris – DDoS and Red Team Engagement
I am super excited to share with all of you that today, I released my 40th Pluralsight course. The topic of the course is Impact with Slowloris.
Learning Resources I Use and Recommend (Updated: April 2020)
In today’s blog post I will be sharing a few of the learning resources which I have been using to further train my skills.