Monthly Archives: April 2017

Search SQL Error Logs using TSQL – xp_readerrorlog

Advertisements

Posted in Productivity, Script, SQL, SQL Server, Uncategorized | Tagged , , | Leave a comment

Powershell commands – my quick reference

Posted in Learn_Powershell, Powershell, Productivity, Uncategorized | Tagged | Leave a comment

Using Idera to investigate a problem during specific time

I had a situation to troubleshoot a performance problem on a server which occurred a few days back. Following is quick reference on how Idera can be used to drill down details. 1. Select History Icon and select the time … Continue reading

Posted in SQL, SQL Server, Uncategorized | Tagged , , | Leave a comment

Azure – All DBs that are not in Elastic pools

Posted in Azure, SQL, SQL Query, Uncategorized | Tagged , , , | Leave a comment