INDEXES

What are Indexes in SQL Database? What is the advantage and disadvantage of Indexes?

ByKaushlendra Mishra

Indexes are schema objects in a SQL database that can boost query performance while executing queries with a filter condition using where clause.

Indexes are used to retrieve data from databases very fast. An Index is a quick lookup table that is used to find a record that user search very frequently. An index helps to speed up select queries and where clauses, but it slows down data input, with the update and the insert statements.

QUICK REPORT IN POWER BI SERVICE

How to create a report quickly in Power BI Service?

ByKaushlendra Mishra

Do you want to create a quick report in Power BI? The latest Power BI version has made it possible to create a quick report using data from the web and existing published datasets in Power BI Service. So, now you do need to download the Power BI Desktop software into your PC and directly make a report using the Power BI service.

WHAT IS AVAILABILITY SET & AVAILABILITY ZONE

What is Availability Set and Availability Zone in Azure?

ByKaushlendra Mishra

What is Availability Set and Availability Zone in Azure? In Availability Set, VM`s copy is created and is isolated with separate physical servers, computer racks, storage units, network switches in a data center within a region so if one of the VM stops working then still we have the copy of the VM working within the same datacenter. While Availability Zone ensures that complete datacenter data is replicated to another place at a distance within the same region so that even if complete data center fails due to any reason then also Availability of data is ensured.

prepare-DP-200-exam

How to Prepare for DP-200 Exam?

ByKaushlendra Mishra

I have passed the DP-200 exam on 28 Oct 2020. I have gone through the various study material and courses in order to prepare for the exam. Overall, the time taken by me for the DP-200 exam is approx 3 months. Ideally, you should not take 3 months of time but due to lack of guidance, I happen to take a number of online courses which was not required to be taken for passing the DP-200 Exam.

Difference between sum of values for recent date and 2nd most recent date.

Difference between sum of values for recent date and 2nd most recent date.

ByKaushlendra Mishra

      While going through the Microsoft Power BI Community, I saw a post where a fellow member was asking for a solution to the problem in getting the difference between the sum of values for the most recent date and Just the previous date. I worked to find a solution for the problem…

How to refresh dataset using button in Report View of PowerBI?

How to refresh dataset using button in Report View of PowerBI?

ByKaushlendra Mishra

You can add a button in your report which will refresh the data once you click on the refresh button in the report view. I have seen in various forums that this has been asked by many clients. For achieving this functionality we will use Microsoft Power Automate and also use Wrap API. I hope…