When we connect to Azure SQL Databases or Managed Instances using the “Proxy” connection policy, idle sessions are closed after 30 minutes of inactivity. However, with the “Redirect” policy, idle…
Problem Datastage jobs are failing when running a query against the Azure SQL Server database with the error: SQLSTATE = 08S01, Native Error Code = 0, Message = [IBM(DataDirect OEM)][ODBC…
Below Issue occurring when User running fastload jobs from DataStage end against Teradata What is cause for this Issue? Network glitch happened while fastload operation was underway. Solution for this error Resubmit the failed fastload job. If the issue…
Error Code Solution select Storage Blob Data Contributor role select name of manage identity name.
To create an external table in Azure SQL Database that accesses data across different databases, you need to first establish a “database scoped credential” on the target database, then create an…
Scenario Want to write data into a SQL dedicated pool using a pipeline in Synapse Workspace. In a copy activity I read data from ADLS V2 and write into the…
The error you’re encountering is on the Sink side when trying to perform an operation on Azure Data Lake Storage Gen2 (ADLS Gen2), with a specific message stating that the…
The error message you are encountering is a login timeout issue when trying to connect to the EDH_DEV database using the ODBC Driver 18 for SQL Server from your on-premises…
In Azure SQL Server, the time zone is generally set to UTC (Coordinated Universal Time), and it cannot be changed at the server or database level like on-premises SQL Server…
Query Audit Logs for Failed Logins Using T-SQL Connect to the master database to run below queries: Query the sys.event_log view Query login failures for users The following query returns connection failures…
Here are some common Integration Runtime (IR) registration errors you might encounter when setting up a Self-hosted Integration Runtime (SHIR) in Azure Data Factory, along with their types and potential…
Setting up a Self-hosted Integration Runtime (IR) in Azure is crucial when you need to securely transfer data between on-premises and Azure services or even between different cloud environments. Below…
Here is a list of Azure SQL Server Database administration interview questions and answers, organized from basic to advanced levels: Basic Level Intermediate Level Advanced Level Part 1 : Scenario-based…
Here is a list of Azure SQL Server Database interview questions and answers, organized from basic to advanced levels: Basic Level Intermediate Level Advanced Level cenario-based questions are designed to…
Syllabus for Databricks Unity Catalog, organized from beginner to advanced levels: Module Topics Covered Level Introduction to Databricks and Unity Catalog Overview of Databricks PlatformIntroduction to Unity CatalogUse Cases and…
When an Azure Virtual Machine (VM) unexpectedly stops, conducting a root cause analysis (RCA) involves several steps to identify the underlying issue. Here’s a step-by-step guide on how to perform…
In today’s fast-evolving digital landscape, the pressure on businesses to innovate rapidly and efficiently has never been greater. As companies strive to remain competitive, the adoption of DevOps—a practice that…
o provide permission for SHOWPLAN access in an Azure SQL Database, you’ll need to follow these steps. SHOWPLAN allows users to view the execution plans of queries, which is useful…
Artifacts in Azure DevOps can be used in various scenarios to facilitate different aspects of the CI/CD pipeline. Here are some additional use cases that demonstrate the versatility of artifacts:…
Artifacts in Azure DevOps play a crucial role in the continuous integration and continuous delivery (CI/CD) process by storing and transferring the outputs of a build process. They ensure that…