SQL Server Error: Principal Cannot Access Database “master” — Fix
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.
Connect to Azure Analysis Services from SSMS
This article describes how to connect to Azure analysis services from SQL Server Management Studio (SSMS).
Current date in KSQL
Learn how to get the current date in ksql using FORMAT_TIMESTAMP(FROM_UNIXTIME(unix_timestamp)) function in Confluent ksqlDB.
How to Open an 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.
Create DACPAC from SQL Server Database
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.
Export Measures From Power BI Desktop
This article describes how to export measures from Power BI Desktop using the Power BI template.
Kafka Streaming vs Spark Streaming
Kafka Streams and Spark Streams are potent tools for real-time processing, Here are the key differences Kafka Streaming vs Spark Streaming.
Export and import SSISDB in just a few clicks
In this article, you will learn how to export and import SSISDB using SSIS Catalog Migration Wizard in just a few clicks.
Step-by-Step Guide : SSISDB Migration to a New Server
SQL Server Integration Services (SSIS) is a powerful data integration tool that allows you to automate complex data migration and transformation tasks. In simple steps, this guide will show you how to migrate the SSISDB catalog from one server to another.
How To Test RLS in Power BI Service
Access to a specific user can be restricted at various levels to protect data. It is essential to test whether the security implementation is working as expected. In that case, you might try if the report shows relevant data to a particular user via a specific Power BI role. This article describes how to run Power BI report as a different user to test row-level security.
ClickOnce does not support the request execution level ‘requireAdministrator’
ClickOnce does not support the request execution level requireAdministrator. However, we have a workaround to fix this problem. This article describes how to achieve it.