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

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 Developer tools. Assumptions - I  am assuming that you have prior working knowledge of AWS … Continue reading Build a CI/CD pipeline using AWS developer tools

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, storage and I/O can easily become the bottleneck for overall system throughput. To gain the … Continue reading SQL Server Storage Review using PowerShell

SQL Server Security review using PowerShell

Problem How often do we do Security Reviews for your SQL Server Instances? We aim to stay on top of security and to be able to so we need to regularly review your Instance security configurations. It’s helpful to build a checklist to be used as part of an internal security audit review, and follow that checklist every time you conduct … Continue reading SQL Server Security review using PowerShell