I often see the command SHUTDOWN underutilized when it is about turning SQL Server services gracefully. Let us learn about it today.
SQL Server on Linux – SQL in Sixty Seconds #162
I wrote a blog post SQL SERVER on Linux – Commands, lots of people asked me that I should create a video about it as not everyone has Linux.
SQL SERVER on Linux – Commands
Let us learn how to install SQL Server on Linux in this quick blog post. I have recently worked with a client wanting multiple installations of SQL Server.
Query Ignoring CPU Threads – SQL in Sixty Seconds #161
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.