Table Scan Vs Index Scan in SQL Server
A table scan or an Index scan are performed in response to any query when SQL Server has to scan the data or index pages… Read More »Table Scan Vs Index Scan in SQL Server
Home » Archives for Pradeep Raturi »
Pradeep Raturi
I have 11+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.
DIVIDE Function DAX
DIVIDE function is a power bi DAX mathematical and trig functions that performs the division and returns alternate result or BLANK() on division by 0.
Word Cloud custom visual in Power BI
Word Cloud custom visual in Power Bi
A Word Cloud visual is a Power Bi custom visual that visualize the frequency of word for the given text. The word which has the highest frequency is shown larger than others in visual.
It can be download or import to Power BI from Power BI marketplace.
Load Files from Blob Storage to Azure SQL Server Database
Load Files from Blob Storage to Azure SQL Server Database
Azure Storage Account
Azure storage account is used to store azure storage data objects such as blobs, files, queues, tables, and disks.
Edit interactions in Power BI
Edit interactions in Power BI
Edit interactions is a Power BI features that is used to control the interaction of visuals in report page.
Connect POWER BI with AZURE blob storage
Connect Power Bi With Azure blob Storage
To connect Azure blob storage with POWER Bi , First you need to go through the following step to verfiy that everything is ready on Azure to go ahead.
LEN Function DAX
LEN Function is a Text Function that returns the number of characters in a text string. It returns a integer value.
IFERROR Function DAX
IFERROR Function is a Power BI DAX Logical Function that evaluates an expression and returns a specified value, If the expression returns an error else returns the value of the expression itself.
COALESCE Function DAX
COALESCE Function is a power Bi Dax Logical function that returns the first expression that does not evaluate to BLANK.
SQL Server FLOOR Function
SQL Server FLOOR Function is a mathematical function that returns the largest integer value that is less than or equal to a number.
SQL Server CEILING Function
SQL Server CEILING Function is a mathematical function that returns the smallest integer value that is greater than or equal to a number.
Cascading referential integrity in SQL Server
Cascading referential integrity constraints are foreign key constraints that is used to defines the action that SQL Server performs when a user try to delete or update a primary key value to which an existing foreign key points.
SQL Server Dirty Reads in concurrent transactions
SQL Server Dirty Reads problems in concurrent transactions
SQL Server LAST_VALUE function
SQL Server LAST_VALUE function is a Analytic function which returns the Last value in an ordered set of values.
SQL Server FIRST_VALUE function
SQL Server FIRST_VALUE function is a Analytic function which returns the first value in an ordered set of values.