Category Archives: devops

Create SQL Server for SQL Database in Azure

In this post, we will quickly create a SQL Server in Azure. To achieve this I will use a PowerShell script. Prerequisite is: Azure Subscription existing Resource Group First, we will define a variable. After that, we will check if there is already a server if not, then the script will start to create one.Continue reading “Create SQL Server for SQL Database in Azure”

Sync Login for SQL Server Availability Groups AG Multiple Server

The Problem: In your SQL Availability Group environment and you have created a new login. After failover the users reports that they cannot connect to the database with the application. Because the connection to database goes via AG Listener, the application will be redirect to the secondary SQL Server Node after failover of Availability GroupContinue reading “Sync Login for SQL Server Availability Groups AG Multiple Server”