I faced my client while working on Comprehensive Database Performance Health Check. They wanted to run SQL Server Agent Job After Completing Another Job.
SQL SERVER – Deny Drop Permission for a Table
Lots of people asked me to write a follow-up blog post where we can deny drop permission for a table from the SQL Server Security Standpoint.
SQL SERVER – Check If a Column Exists 2016 Onwards
However, sometimes it is fun to learn new things as well. Let us learn how you can check if a column exists in a table from SQL Server 2016 and onwards.
SQL SERVER – Find Total Sessions by Database
Today we will see a very simple script that I often use during my Comprehensive Database Performance Health Check. Let us find Total Sessions By Database.
SQL SERVER – Threads Not Counted for Max Worker Threads
I had a very interesting situation where I had to find all the threads which are not counted for max worker threads in SQL Server. Let us see the script.
SQL SERVER – Types of Triggers
A client of Comprehensive Database Performance Health Check asked me questions about types of triggers. Let us learn about it.
SQL SERVER – How to Break Mirroring?
I am helping my clients with a Comprehensive Database Performance Health Check. Today we will see a very simple script to break mirroring in SQL Server.