Many companies do hardening of servers to make sure they are protected from any known vulnerabilities. It is important to test all the application in test server before doing hardening. Let us learn about how to fix Eventlog Service not starting.
How to Show Results of sp_spaceused in a Single Result? – Interview Question of the Week #135
Question: How to Show Results of sp_spaceused in a Single Result?
Answer: When I hear this question from my co-interviewer, I objected. I think it is not a good interview question. I do not expect any of the candidates to remember any of the syntax. Remembering basic syntax should be a good idea, but it should not be the sole requirement of the hiring a good candidate. I believe I am a good DBA but trust me personally I do not remember all the syntax.
SQL SERVER – How to Clear Plan Cache with Database Scoped Configuration?
Question: How to Clear Plan Cache with Scoped Configuration?
SQL SERVER – Difference Between spid, kpid and ecid in sysprocesses
Question: What is the difference between spid, kpid and ecid in sysprocesses?
SQL SERVER – How to Build Three Part Name from Object_ID – Part 2?
Earlier this week, I posted an interesting interview question How to Build Three Part Name from Object_ID? – Interview Question of the Week #134. In its response, I have received a very interesting reply from Rin Sitah over here.
SQL SERVER – How to Convert CollationID to Collation Name?
One of my blog readers sent email to me asking if there is a way to convert CollationID to Collation name. I replied asking more details about the requirement. Here is her reply.
Pinal,
I am in a trouble right now. Due to a hardware crash, I lost many of database files. Unfortunately, I don’t have backups, but I was able to retrieve MDF files. I was trying to follow your blog
How to Build Three Part Name from Object_ID? – Interview Question of the Week #134
Question: How to Build Three Part Name from Object_ID?