Monthly Archives: July 2016

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

TSQL to add a database to existing Availability group

Following are the TSQL statements that can be used to add database into existing Availability group.

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