SQL Server

How to deal with Scheduled Maintenance Mode and SQL Always On

First published on TECHNET on Mar 08, 2018 UPDATE: November 2018 the 9 th – For SCOM 2016 only this issue has been fixed in UR6 Hi everyone, Bruno here. Today I will cover a topic that came to my attention several times, without being previously discussed broadly and deeply. The topic: Have you ever […]

How to deal with Scheduled Maintenance Mode and SQL Always On Continue Reading

Windows Server 2016/2019 Cluster Resource / Resource Types

Over the years, we have been asked about what some of the Failover Cluster resources/resource types are and what they do. There are several resources that have been asked about on multiple occasions and we haven’t really had a good definition to point you to. Well, not anymore. What I want to do with this

Windows Server 2016/2019 Cluster Resource / Resource Types Continue Reading

How to Cluster MaxDB on Windows in the Cloud #Azure #AWS #GCP #SAP

Recently I have had a number of customers looking for a high availability solution for MaxDB on Windows in the cloud. Some customers have been in Azure and some in AWS. But regardless of the cloud platform, they all eventually find the post in the SAP Community WIKI that describes the process. https://wiki.scn.sap.com/wiki/display/MaxDB/HowTo+-+Embed+SAP+MaxDB+in+MSCS The challenge

How to Cluster MaxDB on Windows in the Cloud #Azure #AWS #GCP #SAP Continue Reading

Azure Backup can automatically protect SQL databases in Azure VM through auto-protect

We are excited to share the auto-protection capability for SQL Server in Azure Virtual Machines (VM). This is a key addition to the public preview of Azure Backup for SQL Server on Azure VM, announced earlier this year. Azure Backup for SQL Server is an enterprise credible, zero-infrastructure pay as you go (PAYG) service that

Azure Backup can automatically protect SQL databases in Azure VM through auto-protect Continue Reading

Automate Always On availability group deployments with SQL Virtual Machine resource provider

We are excited to share that a new, automated way to configure high availability solutions for SQL Server on Azure Virtual Machines (VMs) is now available using our SQL VM resource provider. To get started today, follow the instructions in the table below. High availability architectures are designed to continue to function even when there

Automate Always On availability group deployments with SQL Virtual Machine resource provider Continue Reading

Step by Step Windows Server 2019 File Server Clustering With PowerShell or GUI

Installing the Cluster is easy now days. But just this I post a little blog on how to do this, In my blog stats it shows that the 2012 post is still very active , so time for an update to Windows Server 2019. in the creation there isn’t much changed, it gets only easier.

Step by Step Windows Server 2019 File Server Clustering With PowerShell or GUI Continue Reading

Azure Hybrid Benefit for SQL Server on Azure Virtual Machines

Azure Hybrid Benefit (AHB) for SQL Server allows you to use on-premises licenses to run SQL Server on Azure Virtual Machines. If you have Software Assurance, you can use AHB when deploying a new SQL VM or activate SQL Server AHB for an existing SQL VM with a pay as you go (PAYG) license. Bring

Azure Hybrid Benefit for SQL Server on Azure Virtual Machines Continue Reading

Azure Hub-Spoke model by Enterprise Design 2 of 4 Lift and Shift

This blogpost about Microsoft Azure Hub-Spoke model by Enterprise Design 2 of 4 “Lift and Shift” is part of a Datacenter transition to Microsoft Azure Intelligent Cloud. It’s talking about Azure Architecture, Security, Assessment, Azure Policy, and implementation of the design. Here you find the first blogposts : Microsoft Azure Hub-Spoke model It’s important for

Azure Hub-Spoke model by Enterprise Design 2 of 4 Lift and Shift Continue Reading

What Azure permissions are required to create SQL Managed Instance?

Azure SQL Managed Instance is a fully managed SQL Server Instance hosted in Azure cloud that is placed in your Azure VNet. Users who are creating instances need to have some permissions. In this post you will see the minimal permissions required to create managed instance. If you are owner of your Azure subscription, you

What Azure permissions are required to create SQL Managed Instance? Continue Reading

Azure Policy and BluePrints Overview

Microsoft Azure Policy Why is Azure Policy and Blueprints important ? When you made your Enterprise Architecture Design like my last blogpost : Microsoft Azure Hub-Spoke model by Enterprise Design Part 1 of 4 You want to keep in control of your Business policy’s and keep your Azure Virtual Datacenter consistent as by design. Azure

Azure Policy and BluePrints Overview Continue Reading