A deadlock occurs when two or more processes or transactions block each other from continuing because each has locked a database resource that the other transaction needs. This article describes how to find deadlock in SQL Server database.
Find deadlock in SQL Server Read More »
This article describes how to solve error: Principle ‘Data factory’ could not be found or this principal type is not supported
Principle could not be found or this principal type is not supported Read More »
The server principal is not able to access the database “master” under the current security context.
This article describes how to Grant Access to Azure SQL Database for SQL Server users, Azure AD user, and managed identity.
Grant Access to Azure SQL Database Read More »
This article describes how to connect to Azure analysis services from SQL Server Management Studio (SSMS).
Connect to Azure Analysis Services from SSMS Read More »
Learn how to get the current date in ksql using FORMAT_TIMESTAMP(FROM_UNIXTIME(unix_timestamp)) function in Confluent ksqlDB.
Current date in KSQL Read More »
This article describes how to Open SSIS Package from ispac file or from Integration Services Catalog in SQL Server Data tools.
Open ispac File in Visual Studio Read More »
DACPAC file is essential when migrating your on-premise SQL Server database to Azure. This is because Azure SQL database does not support regular SQL Server backups (.bak) files for restorations and requires a separate type of backup file called BAKPAC – Data-Tier Application Export (.bacpac file). Moreover, to create a BACPAC file, you must first create a DACPAC file to ensure that your database is ready for a BACPAC export. This article will show how to take a DACPAC extract of an on-premise SQL Server database.
Create DACPAC from SQL Server Database Read More »
This article describes how to export measures from Power BI Desktop using the Power BI template.
Export Measures From Power BI Desktop Read More »
Kafka Streams and Spark Streams are potent tools for real-time processing, Here are the key differences Kafka Streaming vs Spark Streaming.
Kafka Streaming vs Spark Streaming Read More »
