The Anti-Pattern Unveiled: EXECUTE with String Variables Dynamic SQL involves constructing and executing a SQL statement as a string. The simplest method is using the EXECUTE (or EXEC) command with...

Introduction  If you’re using Azure Kubernetes Service (AKS), you will need a mechanism for accepting and routing HTTP/S traffic to applications running in your AKS cluster. Until recently, this wa...

In this continuation (part 3) of the previous blog, you will create a simple metadata driven pipeline to ingest data into the Data Warehouse and populate the dimension tables. Task4: Create a metad...

Introduction  Nginx (pronounced as "engine x") is an HTTP web server, reverse proxy, content cache, load balancer, TCP/UDP proxy server, and mail proxy server. It is one of the common ingress (used...

Leveraging Spot instances in Azure Databricks can greatly reduce costs; however, we strongly advise against their use for critical production workloads requiring high SLAs. Since Spot instances are s...

Customer business case  "Using Azure Monitor I want to get alerted when we are running out of available IP addresses on any virtual network (vNet) subnets"    Investigation  Together with ...

Introduction  A service mesh is a dedicated infrastructure layer that manages service-to-service communication in microservices architectures. It is essential for managing communication between mic...

In this continuation (part 2) of the previous blog, you will create the required Fabric items within a workspace and create the tables in Lakehouse and Data Warehouse. Task1: Create a Microsoft Fab...