How to create a native PowerShell app registration to connect to Azure SQL DB

How to create a native app registration This guide assumes that you already own an Azure Subscription, an Azure Active Directory properly setup and your PowerShell environment properly set for running scripts.  You might want to refer to this article first: https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/10/26/azure-sql-database-token-base-authentication-with-powershell/ Problem summary:  There might be a time when we you will want to…


Azure SQL Database Token-based authentication with PowerShell

How to connect to Azure SQL Database using token-based authentication in PowerShell native apps This guide assumes you already have a deployment of an Azure SQL Database, your PowerShell environment configured and you have an app registration for a native app in Azure Active Directory. How to configure a native app registration: https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/10/30/how-to-create-a-native-powershell-app-registration-to-connect-to-azure-sql-db/ Problem summary: There…


I cannot see the Long-Term Retention (LTR) backups

Sometimes a user is assigned permissions at Resource Group level or Resource level. When using Long-Term Retention we have several advantages like each backup will be kept in the long-term storage for the period specified by these parameters or the database can be restored to any existing server under the same subscription as the original…