As a data modeler, sometimes you might need to write a DAX expression that counts table rows. The table could be a model table or an expression that returns a table. Your requirement can be achieved in two ways. You can use the COUNT function to count column values, or you can use the COUNTROWS function to count table Read More
Category: SQL
What is the Difference Between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?
There are different types of joins available in SQL: INNER JOIN: returns rows when there is a match in both tables. LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table. RIGHT JOIN: returns all rows from the right table, even if there are no matches Read More
SSAS, SSIS, and SSRS
What are SSAS, SSIS, and SSRS? Microsoft SQL Server provides many tools to manage and utilize your data. SSAS is Microsoft SQL Server’s Analysis Services which is an online analytical processing (OLAP), data mining and reporting tool used in Business Intelligence to make your data work for you. SSIS stands for Sql Server Integration Services. The key Read More
How to Add a New Table by Using DISTINCT with Multiple Columns
The SELECTCOLUMNS function simply takes some column/columns from another table and create a new table from them. For example, you can take only one column, Revenue, The syntax of SELECTCOLUMNS is simple: Smaller table = SELECTCOLUMNS(Table1;”This day revenue”;[Revenue]) It is the new table name, column name in the new table, column name in the original Read More
Understand OData Connection Manager in SSIS
Applies to: SQL Server (all supported versions) SSIS Integration Runtime in Azure Data Factory Connect to an OData data source with an OData connection manager. An OData Source component uses an OData connection manager to connect to an OData data source and consume data from the service. For more info, see OData Source. Adding an OData Connection Manager Read More
How to Download OData Source to SQL or a TXT File in SSIS
Applies to: SQL Server (all supported versions) SSIS Integration Runtime in Azure Data Factory This tutorial walks you through the process to extract the Employees collection from the sample Northwind OData service (https://services.odata.org/V3/Northwind/Northwind.svc/), and then load it into a flat-file. 1. Create an Integration Services project Launch SQL Server Data Tools or Visual Studio. Click File, point to New, and click Project. In the New Project dialog box, Read More