Question: How to Generate Random Password in SQL Server?
Answer: This is a fantastic question and here is the script to generate a random password in SQL Server
How to Check Edition Specific Features Enabled In SQL Server? – Interview Question of the Week #180
Question: How to Check Edition Specific Features Enabled In SQL Server?
How to Find Service Account for SQL Server and SQL Server Agent? – Interview Question of the Week #179
Question: How to Find Service Account for SQL Server and SQL Server Agent?
Answer: As they say – There are more ways than one to skin a cat. In this blog, we will find multiple methods to find out service account used for SQL Server service and SQL Agent Service
How Much Work Each Processor (CPU) is Doing in SQL Server? – Interview Question of the Week #178
Question: How Much Work Each Processor (CPU) is Doing in SQL Server?
Answer: To be honest, I have not seen this question asked in any of the interview questions so far. Actually, this question was asked by one of my clients during Comprehensive Database Performance Health Check. Every time whenever he logs into his system, he finds his CPU running very very high even though he had over 56 active processors. What he really wanted to know what exactly is going on behind the scene of his processors. He really wanted to figure out, how busy his servers are and how much work is pending per Processor (CPU)?
How to Find Cardinality or Uniqueness for any Column? – Interview Question of the Week #177
Question: How to Find Cardinality or Uniqueness for any Column?
How to Enable Files & Folders Level Auditing in SQL Server? – Interview Question of the Week #176
Question: How to Enable Files & Folders Level Auditing in SQL Server?
How to Write Errors in Error Log? – Interview Question of the Week #175
Question: How to Write Errors in Error Log ?
Answer: This question was asked by my one of my customer during SQL Server Performance Tuning Practical Workshop. The workshop is really fun as during the workshop we usually discuss quite a lots of things along with SQL Server Performance Tuning subjects.