Azure Databrick – DataFrame column

Using DataFrame columns in Azure Databricks offers various operations for data manipulation. How to use…

What is DataFrame API in Databrick?

In this tutorial we will learn in depth about DataFrame API in databrick What is…

Basic Concept to Start with Azure Databricks

In this lesson will give go step by step concept building for Azure Databricks and…

Query to get list of Schema and table name in Azure SQL database

The query below lists all tables in an Azure SQL Database. select schema_name(t.schema_id) as schema_name,…

Direct access and access through Azure Active Directory (AD) groups – Azure SQL Database

Direct Access to User Direct User Mapping: Granting direct access involves assigning specific permissions directly…

What is Azure SSIS and its Use cases?

What is Azure SSIS? Azure SQL Server Integration Services (SSIS) is a cloud-based data integration…

ADF pipeline Failed with error 2407 code for ADLS file copy.

If Azure data factory (ADF) pipeline failed with error 2407 for Azure data lake storage…

Azure Databricks Tutorial: How to create notebook and Query the Data in different way Part 5

Creating a notebook in Azure Databricks and querying data in multiple ways using SQL and…

Azure Databricks Tutorial:Explanation about Databricks navigation panel with Examples-Part4

The Azure Databricks workspace navigation panel provides an organized view of your Databricks environment, offering…

Different levels or types of branches in Azure DevOps in Simple words

In this context, these branches likely represent different levels or types of branches within a…

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…

How to Get SQL Server database transaction log usage?

What is transaction log in SQL Server? In SQL Server, the transaction log is a…

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…

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…

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…

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…

What is CrowdStrike? How to install CrowdStrike with Azure VM?

CrowdStrike is a leading cybersecurity company that specializes in cloud-native endpoint protection. It provides solutions…

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…