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…
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…
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….
Query session status runnable, sleeping, suspended, running and background meanings in SQL server Database
In SQL Server, when you query the session status, you can encounter various states that provide information about what a session is currently doing. Here are some…
Troubleshooting Connectivity issues & Timeout error [258]. Unable to complete login process due to delay in prelogin response/ Pre-Login Handshake Failed
If trying to connect Azure SQL Server database and getting below Error: Error Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Timeout error [258]….
How to Create User login and User in Azure SQL server using SQL Server Management Studio(SSMS)
To Create User login and User in Azure SQL server using SQL Server Management Studio(SSMS) Step 1 : Create user logon from master database where ‘abc’ is…
How to use Azure Key Vault for Azure Data Factory?
What is Azure Key Vault? Azure Key Vault is a cloud-based service provided by Microsoft Azure that allows you to securely manage and store sensitive information such…
What is fragmentation in Azure SQL Server? How to check fragmentation for table? How to rebuilt table to reduce fragmentation?
What is fragmentation in Azure SQL server? Fragmentation in Azure SQL Server, or any SQL Server, refers to the condition where the data pages of a database…
How to install AZ Modules in Power shell. How to Connect Azure from PowerShell?
Determine if the version of PowerShell you’re running meets the minimum requirements before attempting to install the Az PowerShell module. The .NET Framework 4.7.2 or higher is…
What are Azure Users, Groups, service principals, and managed identities?
In Azure, users, groups, service principals, and managed identities are all components related to identity and access management (IAM). They help control access to Azure resources and…