Category Archives: Azure

How to Point in time Restore Azure SQL Database after deleting the database

Azure SQL Database has feature to restore the database to point in time when the database is live. When we have to move the database to different Server we end up deleting the database from old server, we can not … Continue reading

Posted in Azure, Powershell, SQL, SQL Server, Uncategorized | Tagged , , , , | 2 Comments

catalog

This Catalog is the index for different blog posts in structured order Azure . Azure.Pricing: https://vijredblog.wordpress.com/2016/09/15/azure-database-pricing-tier-selection/ . Azure.Powershell : Frequently used Azure SQL Powershell Commands: https://vijredblog.wordpress.com/2017/07/27/frequently-used-azure-powershell-commands/ Point in Time Restore on Deleted DB: https://vijredblog.wordpress.com/2018/05/23/how-to-point-in-time-restore-azure-sql-database-after-deleting-the-database/ . Azure.SQL . AZURE.SQL.Frequently User SQL … Continue reading

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

How to mound Azure File Service on local machine

You can mound Azure File service account folder on local machine as a drive (Mount point). How to do it: Open Azure Portal (https://portal.azure.com) Open File Service account (Storage account -> Account -> Files ) Click on Connect button You … Continue reading

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

Powershell Workflow for Runbooks, Inline Script

Powershell workflow is the best way to program parallel processing using Powershell and/or in Azure run books. Though the syntax is similar, there are few differences you need to be aware of. Start with below link when you create your … Continue reading

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

Frequently used Azure powershell commands

Few of my frequently used powershell commands on Azure Ref: https://docs.microsoft.com/en-us/azure/search/search-manage-powershell

Posted in Azure, Powershell, Uncategorized | Tagged , , , | 1 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

Azure – All DBs that are not in Elastic pools

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