Azure

Mohammad Gufran Jahangir November 23, 2023 0

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 container ‘dese’ and…

READ MORE +

Mohammad Gufran Jahangir November 20, 2023 0

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 database. It’s a…

READ MORE +

Mohammad Gufran Jahangir November 7, 2023 0

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. These statistics provide…

READ MORE +

Mohammad Gufran Jahangir October 27, 2023 0

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 common session statuses…

READ MORE +

Mohammad Gufran Jahangir October 27, 2023 0

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]. . Error: Microsoft…

READ MORE +

Mohammad Gufran Jahangir October 18, 2023 0

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 login name Step…

READ MORE +

Mohammad Gufran Jahangir October 17, 2023 0

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 as cryptographic keys,…

READ MORE +

Mohammad Gufran Jahangir October 11, 2023 0

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 or index are…

READ MORE +

Mohammad Gufran Jahangir October 10, 2023 11

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 also required by…

READ MORE +

Mohammad Gufran Jahangir October 7, 2023 0

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 services. Here, I’ll…

READ MORE +