Category Archives: SQL Server

Availability Group Fail Over date/time – TSQL

I have been using this quick script to verify AG Status Change details from error log. Advertisements

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

Most common challenges and solution with Availability group listener and multisubnetfailover

Industry started using SQL availability groups on most of their environments, DBA is coming across multiple issues related to AGListener connectivity. This blog explains 2 major challenges and solutions in detail: https://blogs.msdn.microsoft.com/alwaysonpro/2014/06/03/connection-timeouts-in-multi-subnet-availability-group/ I recommend option-1 to enable client to use … Continue reading

Posted in Learn_Powershell, SQL, SQL Server, Uncategorized | Tagged , , , , , | Leave a comment

Azure Scripting errors after upgrading Powershell to V4 – Select-AzureRmProfile / Save-AzureRmProfile

After upgrading Powershell to V4, few of my scripts started failing. Few updated commandlets are missing backward compatibility, Select-AzureRmProfile/ Save-AzureRmProfile are couple of the broken commandlets. You can replace them with Import-AzureRmContext, and Save-AzureRmContext. Code block I use for reference: … Continue reading

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

Search SQL Error Logs using TSQL – xp_readerrorlog

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

Using Idera to investigate a problem during specific time

I had a situation to troubleshoot a performance problem on a server which occurred a few days back. Following is quick reference on how Idera can be used to drill down details. 1. Select History Icon and select the time … Continue reading

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

All Databases without geo-replica on Azure Server

Query to find all Azure database without geo-replica configured.

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

SQL database and backup size of all databases on a server

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