Conditional Column in Power BI
A conditional column is a column that is generated based on a condition imposed on an existing column in data model. In general, conditional column… Read More »Conditional Column in Power BI
94 total views
Custom column in Power BI
Power BI Custom column adds a new column in data model based on the existing columns in data model. You can create a custom column… Read More »Custom column in Power BI
193 total views
How to compare column names in two tables in SQL
Assume that, you have two tables and you are asked to find out the columns which exists in both table with same name or column… Read More »How to compare column names in two tables in SQL
250 total views, 1 views today
How to find leading and trailing spaces in SQL Server ?
You may have faced a situation where you are asked to find values in a column with leading or trailing spaces or remove the leading… Read More »How to find leading and trailing spaces in SQL Server ?
175 total views
How to show last refresh date in Power BI
Showing a last refresh date and time in Power BI report let you know how fresh your report data is as sometimes report viewer can… Read More »How to show last refresh date in Power BI
259 total views
Search string in xml
How to search for string within xml column in SQL table? As you can see here we have a sample table having categories and products… Read More »Search string in xml
174 total views
Refresh error from changing column names in data source
You may have faced a refresh error when a column name is changed in data source, it happens in such scenario when you have renamed… Read More »Refresh error from changing column names in data source
336 total views
Generate a range of numbers between two numbers in SQL Server
Sometimes, you need to show range of numbers or may be asked to generate a range of numbers between two numbers in SQL Server. Well,… Read More »Generate a range of numbers between two numbers in SQL Server
346 total views
Export Measures and Calculated columns
Documenting DAX formulas is always a good practice as it saves a lot of time in various scenario such as when your PBI report having… Read More »Export Measures and Calculated columns
1,069 total views
Formatting DAX
Formatting a DAX is good practice as it makes your DAX code well defined and readable. If you have written a DAX code which is… Read More »Formatting DAX
384 total views
Lost update problem in concurrent transations
A lost update problem occurs in concurrent transactions, when two transactions try to read and update the same column on the same row within a… Read More »Lost update problem in concurrent transations
838 total views
SQL Return
SQL Return is a control-of-flow language keyword which is used to exit unconditionally from a query or stored procedure. It can be used at any… Read More »SQL Return
310 total views
Aggregate Transformation Basic Mode in SSIS
The Aggregate transformation applies aggregate operations such as maximum, minimum, average, sum, and count to column values and copies the results to the transformation output.… Read More »Aggregate Transformation Basic Mode in SSIS
769 total views
Send Multiple files to FTP Server in SSIS
This article demonstrate how to send multiple files from local system folder to FTP Server. If you want to send only single file from your… Read More »Send Multiple files to FTP Server in SSIS
579 total views
Send file to FTP Server in SSIS
This article demonstrate how to send, or upload file from local system to FTP Server. SSIS allows you to use FTP task which helps you… Read More »Send file to FTP Server in SSIS
674 total views
Conditional Split Transformation in SSIS
The Conditional Split transformation moves data rows to different outputs depending on the content of the data. The implementation of the Conditional Split transformation is… Read More »Conditional Split Transformation in SSIS
789 total views, 1 views today
Merge Transformation in SSIS
The Merge transformation in SSIS combines two datasets into a single dataset. It takes two datasets and must be in sorted order, so the output… Read More »Merge Transformation in SSIS
782 total views
SSIS Connection Managers
SSIS connection managers are used to configure a connection between source and destination data stores such as Excel, Text, XML, FTP, Relational databases and so… Read More »SSIS Connection Managers
859 total views
Derived Column Transformation in SSIS
The Derived Column transformation in SSIS allows us to create new column values by applying expressions to transformation input columns. An expression can be created… Read More »Derived Column Transformation in SSIS
1,780 total views
Create a new SSIS project
This article demonstrate how to create a new SSIS project using SSDT (SQL Server Data Tool). SSIS projects are created to transform data from a… Read More »Create a new SSIS project
720 total views, 2 views today