Published On: 6/28/2022
Top 15 Power BI interview Questions with detailed Answers
1. What are the filters available in Power BI Report?There are four different filters available in Power BI such as Visual level filters, Page level filters, Drill through filters and Report level filters.
Visual level Filters: Visual level filters work on individual visualization and the relevant value/data can be changed on the page if we click o…
Read More »
Solved: Error INSTALL_FAILED_USER_RESTRICTED in Android Studio
This problem occurs if the device/phone blocks to install an app from external device. To resolve this error you need to enable the option “Install via USB” under "Developer Options" in "Settings".
Enable the Developer Options in Android PhoneThis guide helps you troubleshoot issues connecting and running your app on a physical …
Read More »
Fill Factor in SQL Server: Optimizing Index Performance
When it comes to optimizing performance in SQL Server, one
factor to consider is the fill factor. The fill factor determines the percentage of space on each leaf-level page that is filled with data, leaving room for future growth. By setting an appropriate fill factor, you can reduce fragmentation and improve index performance.
What is Fill Fac…
Read More »
Customize SSIS Logs and Send attractive Email Notification of SSIS Job
SSIS provides inbuilt logging option to trace the audit information in text file or SQL table while executing the SSIS package. But if we need to retrieve all the information from single file or table it is not easy task when we use inbuilt option in SSIS package.
For instance, we are going to load the data from flat file to SQL table. We need to t…
Read More »
Published On: 5/19/2020
Install and Configure the PGP tool for file Encryption or Decryption
PGP InstallationStep 1: Click https://www.gpg4win.org/download.html to download the GPG tool. Select 0$ to skip the donate process.
Step 2: Select all the components during the GPG4win setup Installation.
Step 2: Click next to navigate to next screen.
Once completed the GPG4win setup, we can configure the keys on GPA tool in following steps.
Conf…
Read More »
Published On: 2/14/2019
Reading connection string from connection manager by SSIS Script task
Sometimes, we may encounter the scenario to load/read the data from database using script task and that time we need to get the connection string from the connection manager to handle this scenario dynamically. In this topic, we are going to look how can we read the connection string from connection manager's connection using script task step …
Read More »
Published On: 2/08/2019
Fixed: The EXECUTE permission was denied on object xp_sqlagent_notify
Error Message: The EXECUTE permission was denied on the object ‘xp_sqlagent_notify’, database ‘mssqlsystemresource’, schema ‘sys’.
Error Reason: This problem occurred due to the insufficient permission to Report Server database Role (RSExecRole) when we are creating new subscription in SSRS report.
Solution: We need to grant few permissions to re…
Read More »
Published On: 11/23/2018
Experience SQL Server/Developer Interview Questions and Answers
Collection of recent, popular scenario based SQL Server/SQL developer Interview questions and answers for freshers, beginners and experienced candidate/professional.
SQL Server/Developer Interview Questions and AnswersWhat is the difference between ROW_NUMBER, RANK, DENSE_RANK and NTILE?
ROW_NUMBER, RANK, DENSE_RANK, NTILE are functions in SQL serve…
Read More »
Published On: 11/15/2018
How to Encrypt and Decrypt the files and text using GPG/PGP tool
PGP (Pretty Good Privacy) is an encrypted file format by combination of public and private that used to share the data or message with confidential. Say for example, in the hackers world we cannot say the data transfers are safe to client and we need to tight up the security on data using some tool.
PGP is used to sign messages so that the receiver…