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.
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.