Category Archives: Azure

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 , , , , | Leave a 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

TSQL – Monitor to check number of records every hour in a given table

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