Automated Database Backups for Cloud Spanner using Terraform

This post shows how to use cloudspannerecosystem/scheduled-backups to configure scheduled backups for your cloud spanner database. The setup of the required resources (cloud scheduler, pub\sub and cloud function) will be done by using terraform in this tutorial. The Architecture is as follows: We will provision the following GCP services using terraform: Cloud Scheduler: trigger tasks … Continue reading Automated Database Backups for Cloud Spanner using Terraform

SQL Server Always On Availability Groups on Google Kubernetes Engine

This tutorial shows you how to configure SQL Server AlwaysOn availability groups (AG) using DH2i DxEnterprise and Google Kubernetes Engine (GKE). This offering helps you achieve high availability for your SQL Server databases running on containers in Kubernetes. Infrastructure Design GCP Resources that will be created for this demonstration VPC Network named network-1privatenet subnetpublicnet subnetPrivate … Continue reading SQL Server Always On Availability Groups on Google Kubernetes Engine

Running SQL Server 2019 on Google Kubernetes Engine

Have you tried to run a SQL Server deployment on Google Kubernetes Engine yet? Here is a complete guide to create and run SQL Server 2019 on GKE. You will be creating the following resources to successfully host SQL Server on GKE. A namespace to host resources for SQL Server deploymentA secret for 'sa' accountPersistent … Continue reading Running SQL Server 2019 on Google Kubernetes Engine

Azure Data Factory – Self Hosted IR (Scaling, Best Practices and Disaster Recovery Solutions)

We are going to explore following about Self Hosted Integration runtime for Azure Data Factory When and How to scale Self Hosted IR for Data Factory?Some best practices you should consider for Self Hosted IRDisaster Recovery Solutions for Self Hosted IR Scaling of Self Hosted IR Identifying Self Hosted IR bottlenecks How do we know … Continue reading Azure Data Factory – Self Hosted IR (Scaling, Best Practices and Disaster Recovery Solutions)

Monitoring Azure Data Factory, Self Hosted IR and Pipelines

Architecture Diagram For effectively monitoring ADF pipelines we are going to use Log Analytics, Azure Monitor and Azure Data Factory Analytics Solution. The above illustration shows the architectural representation of the monitoring setup. The details of setting up log analytics, Alerts and Azure Data Factory Analytics Solution are further discussed in this section. Send to … Continue reading Monitoring Azure Data Factory, Self Hosted IR and Pipelines

SQL Server Distributed Availability Group with forwarder in Microsoft Azure

Architecture Diagram To create a distributed availability group, you need two availability groups each with its own listener. You then combine these availability groups into a distributed availability group. In this case one availability group is on-premises and other needs to be created on Microsoft Azure. This example doesn't cover all of the details like, … Continue reading SQL Server Distributed Availability Group with forwarder in Microsoft Azure

Run a ASP.NET Core App on Kubernetes

Prerequisites You will need .NET Core and Docker installed on your local machine to continue with this implementation. You will also need a Kubernetes cluster either running locally or on a cloud platform. I used Google Kubernetes Engine in this case to expose the service as load balancer but all other steps were executed on … Continue reading Run a ASP.NET Core App on Kubernetes