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”
Category Archives: sql server
How to start migration MS SQL Databases to the Azure Cloud
For one of my clients, I had to prepare a presentation on how to start migrating SQL Server databases to Azure Cloud. My goal was to start with the basics and answer the questions that both myself and the client should ask at the beginning of the migration process. I would like to share myContinue reading “How to start migration MS SQL Databases to the Azure Cloud”
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”
Register SPN for SQL Server authentication with Kerberos
Today a continued work with SQL Server, but for another customer:-), I write this to share with you about my experience with SQL, but also for my as a documentation of my daily work. What is Kerberos? Kerberos is a network authentication protocol. It is designed to provide strong authentication for client/server applications by usingContinue reading “Register SPN for SQL Server authentication with Kerberos”
Home 