SQL Server

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

Extracting insights from IoT data using the warm path data flow

This blog continues our coverage of the solution guide published by Microsoft’s Industry Experiences team. The guide includes the following components: Ingesting data Hot path processing Cold path processing Analytics clients We already covered the recommendation for processing data for an IoT application in the solution guide and suggested using Lambda architecture for data flow.

Extracting insights from IoT data using the warm path data flow 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

SSMS 17.9.1 is now generally available

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.9.1. Download SSMS 17.9.1 today and for details please see the Release Notes. This is a minor update to 17.9 with the following important improvements: Occasionally, SSMS closes MFA query editor connections with no outstanding transactions. A simple way to repro this

SSMS 17.9.1 is now generally available Continue Reading

Create Azure SQL Managed Instance using Azure CLI

Azure command line interface (CLI) is a set of commands that you can use to create and manage Azure resources. In this post your will see how can you create Managed Instance using Azure CLI. The Azure CLI is Microsoft’s cross-platform command-line experience for managing Azure resources. You can use it in your browser with

Create Azure SQL Managed Instance using Azure CLI 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