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

Create SQL Script to restore Transaction logs

I was part of a Major incident this week and we had to restore days worth of transaction logs on multiple databases. Created SQL Query which generates the restore script

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

Windows Server storage capacity and usage report using Powershell

Below Scrip generates list of all Drives and mount points configured, thery storage capacity and free space. Following Script to check the storage on a single server; If you want to calculate the storage to be added to maintain certain … Continue reading

Posted in Powershell, Productivity, Uncategorized, Windows Server | Tagged , , , , | Leave a comment

Generate SQL Query for Database Snapshot creation using Powershell

Following PowerShell script generates SQL Query to take a snapshot;

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