Azure Databricks Tutorial: How to work with Azure Databricks – Part 3

Working with Azure Databricks involves various tasks related to data engineering, data analysis, and machine learning. Below, I’ll provide a step-by-step guide with examples for common tasks…

Read More

Error when Connecting ADF(Azure data factory) pipeline to ADLS( Azure Data lake storage) for Data Copy – service principal/managed identity don’t have enough permission to access the data.

Error Operation on target iteratetables failed: Activity failed because an inner activity failed; Inner activity name: Copytabledata, Error: ErrorCode=AdlsGen2ForbiddenError,’Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 failed for forbidden: Storage operation ‘CreateFile’ on…

Read More

How to Get SQL Server database transaction log usage?

What is transaction log in SQL Server? In SQL Server, the transaction log is a crucial component of the database that records all changes made to the…

Read More

What is SQL Server Statistics and how to Collect/Update Statistics in SQL Server Database.

In Azure SQL Server, statistics are database objects that contain information about the distribution of data in one or more columns of a table or indexed view….

Read More