Tag 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

Find In-Memory table in a given database

Note: In Azure if we use premium database functions we can not downgrade those databases into standard pricing tier. We need to remove premium database features before downgrading to Standard tier. I had to create multiple database copies to reproduce … Continue reading

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

TSQL to find Databases, corresponding elastic pool names and DB edition – Azure

Note: User has no option to change the edition/Service tier of master database. This is expected to change based on the number of databases on a given Azure SQL Server. But Microsoft has the ability to change to address performance … Continue reading

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