Dinesh's Blog :::: Being Compiled ::::

You might be experiencing the following error with bcp when loading text data to SQL Server table; It is possible to see this erro...

The posts I made on date dimension table ( Script for populating Date Dimension with Financial Year and  Loading Data Script for Snowflak...

Even though SEQUENCE object is available with much more flexibility, we still use IDENTITY property for adding sequence values to tables, ...

Once I published the code I used for creating date dimension tables and populating data. But it had not handled finance year related date ...

We generally expect a proper row terminator with files loaded using bcp  and with all accurately defined switches, data should be loaded w...

This is not something released this month but March 2017. These new capabilities of Power BI Slicer is available but many do not use it be...

Normalization is a process of identifying the optimal grouping (relations at the end) for attributes that satisfies data requirements in a...

Microsoft Power BI supports adding parameters for queries and use them with various areas. However, since it has some limitations and cann...

I wrote a post on Relational Algebra that discusses most of operations related to it. This is the continuation of it and this explains Jo...

Power BI Desktop allows us to import data from files such as CSV and Excel . Once imported, it automatically creates a Model  that can be ...

Power BI allows us to add shapes like rectangle or oval  for marking specific area, showing covered visuals as they are related and operat...

How do you name columns returned from your created view? Generally, you do not need to explicitly name them as the names of view-columns  ...