Tag Archives: search

Frequently used Azure powershell commands

Few of my frequently used powershell commands on Azure Ref: https://docs.microsoft.com/en-us/azure/search/search-manage-powershell

Posted in Azure, Powershell, Uncategorized | Tagged , , , | Leave a comment

Refine your search in outlook

After moving all alerts and typical less priority mail I receive 150 mails daily in my inbox. over the time it is very difficult to search a mail. All these years I have been using Outlook search only with keyword. … Continue reading

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

Tip – Excel formula to convert Instance Name to Server Name

Below formula will give sub string preceding \

Posted in Script, Uncategorized | Tagged , , , , , | Leave a comment

Powershell script to search specific error on all log files in given servers

I have used this code to find specific activity failure during a critical process which is running across 25 different servers. this script also searches the log files which are created in last 5 days.

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

SQL-dependency analysis-Identify impacted modules

I am sharing this script which will help during dependency analysis! One of the table needs to be updated in my database, I had to identity all the Views/ Functions/ Procedures along with the usage stats which will be impacted … Continue reading

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , , , , , | 3 Comments

How to Search a Text/String in SQL Stored Procedure

Recently I found a problem with Symmetric Key, fixed it in one of the stored procedures. I had to find similar problem in all Stored Procedures in the database, had to search for a string all the Procedures. Following query … Continue reading

Posted in SQL, SQL Query | Tagged , , , | 2 Comments