Author: Sandeep Arora

Automated Database Backups for Cloud Spanner Using Terraform

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.  …

Read More >

How to Send Custom Emails and Notifications In Azure Data Factory

custom email

If you’ve used Azure Data Factory (ADF), you’ve probably sent email alerts. But these don’t provide any clarity or customization in the message subject line or body. How do you send an email from the ADF pipeline with a custom…

Read More >

SQL Server AlwaysOn Availability Groups on Google Kubernetes Engine

Infrastructure Design

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. GCP Resources…

Read More >

SQL Server Distributed Availability Group with Forwarder in Microsoft Azure

mysql queries

Architecture diagram Register the application with the name terraform. Leave all options as default. Add a secret that will be used as a password to authenticate terraform. Provide a description and expiry period for the secret. Copy the Secret ID…

Read More >

Monitoring Azure Data Factory, Self Hosted IR and Pipelines

developers

Architecture diagram Azure Data Factory Analytics solution For monitoring and analyzing data factory pipelines, I recommend installing the Azure Data Factory Analytics solution from Azure Marketplace. This solution provides you a summary of the overall health of your Data Factory,…

Read More >

Build a CI/CD pipeline using AWS developer tools

Building and delivering software isn’t easy. Everyone wants to have a consistent quality and to be able to deliver new functionality quickly. In this write-up, I will demonstrate Continuous Integration and Continuous Delivery for a Simple .NET application using AWS…

Read More >

SQL Server storage review using PowerShell

Problem There’s no doubt that storage is one of the key components to SQL Server performance and availability for both large and small SQL Server instances. With today’s increases in server and virtual server processing power and large-scale memory support,…

Read More >

Automate SQL server version and database compatibility report using PowerShell

Sandeep Arora, SQL Server Database Consultant, provides a script for automating SQL Server Version and Database Compatibility Report by using PowerShell.

Read More >

SQL server security review using PowerShell

Sandeep Arora, SQL Server Database Consultant, explains how to automate a SQL Server Security review using PowerShell.

Read More >