I am having a 7 + years of experience in microsoft technologies including Asp .NET, C# Power BI, SQL Server, SSRS, SSIS, Azure Fundamentals, & Python.
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
86 total views, 8 views today
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 ?
53 total views, 6 views today
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
102 total views, 10 views today
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
110 total views, 4 views today
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
198 total views, 5 views today
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
215 total views, 7 views today
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
546 total views, 13 views today
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
267 total views, 8 views today
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
637 total views, 12 views today
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
220 total views, 4 views today
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
530 total views, 6 views today
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
456 total views, 6 views today
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
434 total views, 5 views today
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
532 total views, 8 views today
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
557 total views, 6 views today
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
661 total views, 6 views today
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,283 total views, 5 views today
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
550 total views, 2 views today
This article demonstrate how to load data from Excel file into SQL Server table using SSIS. Lets see step by step implementation of simple basic… Read More »Load data from Excel file to SQL Server table using SSIS
946 total views, 2 views today
This article demonstrate how to load flat file into SQL Server table using SSIS. Lets see step by step implementation of simple basic SSIS package… Read More »Load flat file into SQL Server table in SSIS
1,158 total views, 8 views today