Tag Archives: productivity

QueryStore – Regressed queries based on execution count

Handy TSQL statement to find gergressed queries on a given time based on execution count. I had a scenario to validate if application is executing any statements more frequently on a given time. Following SQL can be used to find … Continue reading

Posted in knowledge, Performance, Script, SQL, SQL Query, Uncategorized | Tagged , , , , , | Leave a comment

Search Windows Server patches using KBXXXX / Microsoft Security Update Guide

Server http://www.catalog.update.microsoft.com using KB number to find the patch information and download link. Security Update Guide: https://portal.msrc.microsoft.com/en-us/security-guidance Example: http://www.catalog.update.microsoft.com/Search.aspx?q=KB4489882

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

Visual Studio Code – What I liked!

Visual Studio Code is the new code editor from Microsoft. Following are few reasons why started using it and liking it! * Cross Platform availablity: VS Code is available across Windows, Linux, and mac. This provides same experience using different … Continue reading

Posted in Productivity, Referene, Uncategorized, Visual Studio | Tagged , , , | Leave a comment

Command to find domain group members

Related: https://vijredblog.wordpress.com/2016/04/21/activedirectory-group-user-membership-validation-tool/ (Active Directory Helper)

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

Conditional Formatting – Excel

Simple tip on using Conditional formatting. This sample is to format a cell if it exceeds certain threshold (which is a different column on the same row). 1. Identify first row, first column where the formula needs to be created. … Continue reading

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

How to provide access to SSRS Reports – Giving access only on specific activity

SSRS Access will be managed through Roles only. Giving access to a user or group is assigning the user/group to a specific role. This can be done through the SSRS Reports. Each roles will be assigned with specific tasks so … Continue reading

Posted in Productivity, 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