Update Secret in Azure Key Vault using PowerShell
This article describes how to update secret in azure key vault using PowerShell using AAD and managed identity authentication.
Update Secret in Azure Key Vault using PowerShell Read More »
Automatically Delete Old Files from Azure Storage Account
Follow these quick steps to periodically delete old files from Azure storage account.
Automatically Delete Old Files from Azure Storage Account Read More »
Create SSIS Catalog in SQL Server
This article describes step by step approach to create SSISDB under Integration Services Catalog in SQL Server.
Create SSIS Catalog in SQL Server Read More »
Find deadlock in SQL Server
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 »
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 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.
The server principal is not able to access the database “master” under the current security context.
Grant Access to Azure SQL Database
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 »
Connect to Azure Analysis Services from SSMS
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 »
Current date in KSQL
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 »
Open ispac File in Visual Studio
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 »