▼
Thursday, 24 April 2025

Inside Spark Joins: A Deep Dive into Physical Join Strategies

›
Joins are central to transforming and analyzing data. In Apache Spark—a distributed data processing engine—the efficiency of a join can vary...
Tuesday, 15 April 2025

From Synapse to Fabric: Embracing Cost Flexibility with Autoscale Billing for Spark

›
  As a Principal Architect evaluating enterprise data platforms, one of the most appreciated features for customers using Azure Synapse Anal...
Tuesday, 21 February 2023

Powershell to Restore Azure SQL database PITR backup

›
Today there seems to be a bug on Portal resource Manager API not allowing any SQL databases pitr restores from portal and the only way to do...

Power BI DAX for Start of Year To End of Prior Month Sales

›
We had a requirement for Power BI Measure Start of the year To End of Prior Month Sales sum for one of the report which was failed for Janua...

Bug In Azure API creating Data Factory Default AutoResolveIntegrationRuntime on Managed Virtual Network

›
Recently our terraform Infrastructure as code effort to create a datafactory resource with default AutoResolveIntegrationRuntime in Managed ...

Powershell Azure Devops REST API to create/update a variable group based on json variable input

›
 I had a requirement to automate creation and updating of Azure devops variable group based on a configuration variable json file proved to ...
Thursday, 3 November 2022

Work with Azure SQL with Python import result to pandas dataframe

›
I am going start a series of blogs working with python on Azure SQL, what we can do and limitations, In this first blog we look look into co...