SELECT DISTINCT is a command used to show unique records in a table. Its use is broad but it is mainly used to remove duplicities in the records when...
Loop is a repeated call of a part of a code with different parameters. Usually the code is bound to certain DML operation such as INSERT or UPDATE. We...
Power BI is a cloud technology by Microsoft which enables user to analyze and visualize data easily. Creating reports is a task anyone can do. You do not have...
Today, I prepared for you an SQL quiz for experienced beginners and slightly advanced. Successful completion of the quiz should be routine for a person who uses SQL on...
Let’s start with what the average means. In terms of descriptive statistics, the average is a certain reference (typical) value. It is a property of the data set that...
SQL Command INSERT is suitable for situations when we want to insert entries into the table. Insertion of rows can be done in multiple ways (further description below): You...
In the last article, I introduced the Control Flow feature. Using control flow we can manage through tasks what SSIS package does. The most frequently used is a Data...
Before introducing Control Flow, let me recap the previous tutorial SSIS | Introduction, BIDS, Project, Package, SSIS Toolbox where I introduced the SQL Server Integration Services (SSIS) feature for...
This article serves as an introduction to SQL Server Integration Services (SSIS) for SQL Server. It contains information about this function and its basic parts. SQL Server is generally...
Most calculations in the area of financial mathematics are relatively easy – for example, to calculate an annuity payment, interest rate or target amount value with regular deposits. However,...
A trigger is a database object (procedure) that works as a watchdog for certain event. Using database triggers we can catch this event and initiate some additional action –...