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 →

Securely transfer database backups to Amazon S3

Problem When taking native database backups for EC2 everyone prefers to store the backups in Amazon S3 as it is durable and cost effective but the questions you need ask yourself while transferring the backups are the following, Are the backups going to S3 over internal backbone network?Are you using temporary credentials to authenticate to … Continue reading Securely transfer database backups to Amazon S3 →

T-SQL to script out logins and permissions of all databases

T-SQL to script out logins and passwords for the SQL server instance. Can be useful for taking backups for your logins and DB permissions and can also be useful for migrating logins and permissions. Note: In SSMS, check the “Maximum number of characters displayed in each column” settings before executing the below script. It is defaulted … Continue reading T-SQL to script out logins and permissions of all databases →