Category Archives: Productivity

Powershell commands – my quick reference

Posted in Learn_Powershell, Powershell, 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

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

Process Monitor – Simple and efficient tool to investigate processes

While working with Microsoft on a SQL bug I have used a powerful tool (Process monitor) to troubleshoot the problem. What is interesting with this tool: * Simple, installation not required * Filter is great: Filter can be applied on … Continue reading

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

Using SQL Snapshot backups along with Availability group

Snapshot backup is beautiful option during releases and deploying changes specially when the database size is large like few hundreds of GBs. We have a practice to take snapshot backup during the release and delete once testing is completed on … Continue reading

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