Category Archives: Azure

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

Azure – All DBs that are not in Elastic pools

Posted in Azure, SQL, SQL Query, 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

TSQL to find Deadlock count in Azure Server by date

   

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

TSQL to find size of all databases on a Server – Azure

Posted in Azure, Script, SQL, SQL Query, SQL Server, Uncategorized | Tagged , , , , | 1 Comment

TSQL to find database count in each Elastic pool and its storage utilization – Azure

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

Creating the deployment would exceed the quota of 800 – Azure Error resolution

While performing multiple Azure operations from portal we get below error. This error occurs while performing multiple operations like creating elastic pool, moving a database to a new elastic pool, creating Secondary database, etc. Error: Error submitting the deployment request. … Continue reading

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