Automatically Delete Old Files from Azure Storage Account
Follow these quick steps to periodically delete old files from Azure storage account.
Create SSIS Catalog in SQL Server
This article describes step by step approach to create SSISDB under Integration Services Catalog in…
Find deadlock in SQL Server
A deadlock occurs when two or more processes or transactions block each other from continuing…
Principle could not be found or this principal type is not supported
This article describes how to solve error: Principle ‘Data factory’ could not be found or…
The server principal is not able to access the database “master” under the current security context.
The server principal is not able to access the database “master” under the current security…
Grant Access to Azure SQL Database
This article describes how to Grant Access to Azure SQL Database for SQL Server users,…
Connect to Azure Analysis Services from SSMS
This article describes how to connect to Azure analysis services from SQL Server Management Studio…
Current date in KSQL
Learn how to get the current date in ksql using FORMAT_TIMESTAMP(FROM_UNIXTIME(unix_timestamp)) function in Confluent ksqlDB.
Open ispac File in Visual Studio
This article describes how to Open SSIS Package from ispac file or from…
Create DACPAC from SQL Server Database
DACPAC file is essential when migrating your on-premise SQL Server database to Azure. This is…
Export Measures From Power BI Desktop
This article describes how to export measures from Power BI Desktop using the Power BI…
Kafka Streaming vs Spark Streaming
Kafka Streams and Spark Streams are potent tools for real-time processing, Here are the key…