Troubleshooting user defined routes in Azure
In this blog, we will discuss how to troubleshoot the user-defined route in Azure. I have faced this issue in one of my projects. Typically when you want to test the traffic from a specific VM you will have to log in to the VM and see the output of the Traceroute command and it becomes cumbersome if you have so many routes because now you have to log in to each VM to verify whether the routes are working correctly or not. Another problem is that even if the routes are not working traceroute will not show why it is not working. So if you do not know why routes are not working you can not fix anything. To overcome this issue I wrote a small script that can be used as it is by changing the parameters and it will display the connectivity status (success or failure) if there is an issue then this script will also show what is causing that issue.
Azure landing zone design best practices
Recently I have come across a requirement to design the Azure landing zone for a customer who wants to migrate their workloads from on-premise to Azure. This article explains the best practices implemented in Azure landing zone design.
Dynamic Azure Automation with Ansible
In this blog post, we will learn how to automate Azure workloads with Ansible. We will do the end-to-end automation for Azure virtual machine.
Bulk tagging of Azure resources with PowerShell
In this post, I have provided an important useful configurable script to tag multiple Azure resources or Resource Groups.
Deploying SQL server Always on Availability Group on Azure Kubernetes Services(AKS).
In this blog, we will learn how to deploy the SQL server Always on Availability group on Azure Kubernetes Services.
How to deploy SQL Server containers to a Kubernetes cluster for high availability?
In this blog, we will learn how to deploy the SQL server container on Azure Kubernetes services with High availability. We will use the persistent storage feature of Kubernetes to add resiliency to the solution. In this scenario, if the SQL server instance fails, Kubernetes will automatically re-create it in a new POD and attach it to the persistent volume. It will also provide protection from Node failure by recreating it again. If you are new to Kubernetes we will start by understanding the basic terminology of Kubernetes and its Architecture.
Retrieve Azure VM details by using PowerShell.
Suppose you built a large environment in Azure with more than 1000 Virtual machines. Now we need to provide the Virtual Machine details to the customer(or raise the SNOW ticket) and it is very difficult to collect each VM detail manually from Azure Portal. Also, there can be another use case if you want to verify the VMs to compare with each other to ensure all the VMs are created the same way. For example, the Cache setting for all the VMs should be Read /Write. You may also want to grab details of all the data disks and OS disks and their size, name info, and cache settings. This script grabs all the info in one shot and exports it into a CSV file for further manipulation.Let’s dive in.
How to deploy Databricks in your private VNet without exposing public IP address (VNet Injection)?
The default installation of databricks creates its own Virtual network and you do not have any control over it. But If you want to deploy Databricks into your own private network due to security reasons. So this blog is for you. We will learn how to deploy Databricks into its own Private VNet. Let’s dive in.
How to Deploy SQL server on Azure Container Services?
In this blog we will learn about Azure container services and how to deploy SQL server 2019 on Azure Container Services.
How to choose Right data distribution strategy for Azure Synapse?
Azure Synapse (Azure SQL Data Warehouse) is a massively parallel processing (MPP) database system. The data within each synapse instance is spread across 60 underlying databases. These 60 databases are referred to as “distributions”. As the data is distributed, there is a need to organize the data in a way that makes querying faster and more efficient.In this blog we will learn how to choose the right distribution strategy.
Remote Software Deployment on multiple Azure Linux and Windows VMs.
In this blog, we will discuss a real-time scenario of deploying software on multiple Linux and Windows Virtual machines simultaneously. Suppose you have 500 virtual machines both Windows and Linux and you want to push the software to these virtual machines. Obviously, it is not a workable solution to perform the manual installation on these 500 VMs. But there is good news that Azure provides a custom script extension for remote command execution. Let’s learn how to use it?
Retrieve Azure Resource Inventory by using PowerShell.
In this blog, I will share the script to retrieve the Azure resources inside the Azure subscription. This script iterates through each resource group inside an Azure subscription and retrieves each resource name resource type and resource tag and dumps the information inside a CSV file. So let’s dive in.
How to mount Azure Storage Account to Databricks with SAS key?
This blog discusses the step by step approach to mount the storage account to Azure Databricks.
How to setup Service Chaining in Azure?
In this blog post, we will learn about VNet Peering, Hub, and spoke Architecture and Service chaining in Azure.
How to route Network traffic in Azure?
In this blog, we will learn how Azure manages network traffic by using system routes and user-defined routes. Let’s dive in.
How to configure Azure Load balancer with Azure CLI?
In this blog, we will learn how to set up and configure the Azure load balancer in the quickest possible way and test some Azure features. We will develop an Azure CLI script for the same. I have also created a video to showcase the Azure Load balancer functionality.
How to host Python Flask API on Apache web Server?
In this blog, we will go thru the step-by-step instructions to host Python Flask APIs in the Apache Web server.
How to resolving Mozilla Certificate error (SEC_ERROR_UNKNOWN_ISSUER ) while browsing Https site from Apache web server.
In my earlier post, I provided step-by-step instructions to host a website on an Apache web server and secure it thru HTTPS. I have found that the site works perfectly fine in IE and Chrome but it throws a certificate error while browsing it thru Mozilla. It throws the SEC_ERROR_UNKNOWN_ISSUER error. So in this blog post we will explore the solution of this problem.
Step by Step :How to install Apache Web Server and deploy SSL (HTTPS) enabled site?
In this post, we will go thru step by step instructions for Apache Web server installation. After Apache Server Installation we will create an SSL certificate creation request to generate the certificates from Certificate Authority and then deploy the SSL certificates on Apache Web Server. We will also learn how to modify browser settings to make the certificate works in case the site is accessed from outside the corporate intranet where Root certificates are not installed on the machine.
Quick Tip: How to prevent your Azure Resources from accidental deletion?
A common concern with resources provisioned in Azure is that the ease with which they can be deleted. A careless administrator can accidentally erase months of work with a few wrong clicks. Azure Resource manager locks can help here. Let’s learn how?
How to configure Power BI Enterprise Gateway Proxy configuration?
Power BI service allows connectivity thru PowerBI Gateway in case you do not want to expose the on-premise data sources. Power BI Gateway can be installed on a server /VM deployed in the on-premise environment. Now If you deploy the Enterprise gateway in the On-Premise network your network team may not be happy and they will not open the firewall to expose the Enterprise Gateway to connect to the Internet. But do not worry and here is the good news, in order for the Enterprise gateway to function properly it requires certain ports to be open. Let’s learn how to configure the environment so it is secure.
How to assign Permissions to Azure AD App by using PowerShell?
I have published my last blog to describe to PowerShell script to register the App in the Azure AD, In this blog, we will discuss the PowerShell script to assign the necessary permissions for the App.
How to register an App in Azure AD by using PowerShell
Recently I came across a situation where I was supposed to register an App in Azure Ad for multiple Environments, I felt it to be very cumbersome to do it using the Azure UI interface so I thought to create a script for it.
Power BI Reporting with Reader-Writer cube Implementation.
Recently I have implemented the Reader Writer cube scenario with Power BI reporting. In this blog, we will discuss it’s implementation.
How to create Azure Key Vault-backed secret scope?
In this blog, we will learn how to create Databricks Azure Key Vault-backed secret scope. So let’s dive in.
How to create and use Databricks backed secret scope?
In this article, we will learn how to create a Databricks-backed secret scope. So let’s dive in.
Databrick CLI important commands.
In this blog, we will learn some useful Databarics CLI commands, tips, and tricks.
How to connect Databricks to Azure Data Lake?
Databricks is a version of the popular open-source Apache Spark analytics and data processing engine. Azure Databricks is the fully managed version of Databricks and is a premium offering on Azure, that brings you an enterprise-grade and secure cloud-based Big Data and Machine Learning platform.
Data can be ingested in a variety of ways into Azure Databricks. For real-time Machine learning projects, you can ingest data through a wide range of technologies including Kafka, Event Hubs or ,IoT Hubs. In addition, you can ingest batches of data using Azure Data Factory from a variety of data stores including Azure Blob Storage, Azure Data Lake Storage, Azure Cosmos DB, or Azure SQL Data Warehouse which can then be used in the Spark-based engine within Databricks.
In this article, we are going to connect the data bricks to Azure Data Lakes.
Quick Tip: How to Recover the lost password of Remote Desktop Manager?
I have recently come across a typical situation where I completely forgot the Remote Desktop manager’s password. I thought to recover the password by calling the help desk but I knew it is going to take so much time to get it back because of many regulatory and compliance issues. So I found a quick alternative. I wrote a power shell script to decrypt the lost password. Here are the steps:
PowerShell: Azure Point to Site Connectivity Step By Step
Point-to-site connectivity is the recommended way to connect to the Azure Virtual network from a remote location for example while traveling or working from the home office. In this blog post, we will learn how to set up Point-to-site connectivity.
On-Premise to Azure Connectivity Options
In this blog post, we will learn the various options which Azure provides for establishing connections between On-premise to the Azure data center.
Power BI Report Server Production Debugging
In this blog post, we will learn tips and tricks on how to debug Production Issues in the PowerBI Report server. Let’s dive in.