May 10
1 min

How to efficiently copy - paste a code

1.add this extention to your web browser (Blackbox - Select. Copy. Paste & Search) https://chrome.google.com/webstore/detail/blackbox-sel...

Data Warehouse Dimension Loading Using Lookup and Conditional Split Transformations.

Marek Vavrovic

Apr 22
3 min

SQL

Data Warehouse Dimension Loading Using Lookup and Conditional Split Transformations.

I will be doing incremental dimension loading amoung 3 databases. All 3 of them are on the same server. I have a transactional DB Salome...

Marek Vavrovic

Apr 16
7 min

SQL

Change Data Capture (CDC) In SQL Server

Incremental load for inserts (no updates or deletes) Incremental load for insert, update, delete Overview SQL Server Change Data Capture...

Marek Vavrovic

Apr 13
1 min

SSRS

SSRS Loan Statement

Using T-SQL Stored Procedure to create a report in Power BI Report Builder. Data set: Using T-SQL to create a bank loan statement...

Connecting to Integration Services Access is Denied in SQL Server

Marek Vavrovic

Apr 9
1 min

SQL

Connecting to Integration Services Access is Denied in SQL Server

Connection to the Integration Services service on the computer " XXX " failed with the following error: "Access is denied" By default...

Using T-SQL to create a bank loan statement

Marek Vavrovic

Apr 6
1 min

BI Solutions

Using T-SQL to create a bank loan statement

CREATE PROC sp_LoanAmount ( --Supplying default values @LoanAmount Money = 1000, @RateOfInterest decimal(5,2) = 5, @TimePeriod tinyint =...

Marek Vavrovic

Apr 5
3 min

BI Solutions

Update table using join statement

Examples of SQL Update Join RIGHT JOIN LEFT JOIN INNER JOIN WHERE clause CASE statement Computed Columns create table MyTarget (id int...

Marek Vavrovic

Apr 4
5 min

BI Solutions

SQL Server Transactions

What is a Transaction in SQL Server? A transaction is a set of SQL statements that should be executed as one unit. That means a...

HuffnerTextile - SSIS Initial data load.

Marek Vavrovic

Mar 30
4 min

BI Solutions

HuffnerTextile - SSIS Initial data load.

Examples of BI joins -Dimensions DimEmployee Select [EmployeeID] [EmployeeKey], case when [EmployeeID] = 2 then 1 when [EmployeeID] in...

Marek Vavrovic

Mar 30
3 min

BI Solutions

Huffner Textile - Data Warehouse Design

Files to download: -sql database backup -SQL Server Database Project Types of Data Warehouse Schema STAR SCHEMA The simplest and the most...

Marek Vavrovic

Oct 25, 2021
11 min

SSIS

SSIS - Incremental Load

Data source: http://www.planecrashinfo.com/database.htm. This is an article describing how I have been extracting data from that data...

Marek Vavrovic

Oct 17, 2021
5 min

SQL

Calculating Average using T-SQL

Calculating average by week number. Calculating average by month number. Using AVG() OVER() Moving average in T-SQL Weighted Moving...

Marek Vavrovic

Oct 16, 2021
2 min

SQL

Window Functions

FIRST_VALUE LAST_VALUE Previous day (Difference between current date and previous date value) LAG() (Calculating price difference...

Create a Stored Procedure in SQL Server.

Marek Vavrovic

Aug 12, 2021
2 min

SQL

Create a Stored Procedure in SQL Server.

A stored procedure is a group of T-Sql statements. If you have a situation, where you write the same query repeatedly, you can save that...

Marek Vavrovic

Aug 10, 2021
2 min

SQL

CREATE VIEW in SQL Server using T-SQL.

A view is a saved query. The following example creates a view by using a simple SELECT statement. A simple view is helpful when a...

Marek Vavrovic

Aug 9, 2021
2 min

SQL

Grouping in SQL Server

SQL Server GROUP BY clause SQL Server GROUPING SETS SQL Grouping Function 1. SQL Server GROUP BY clause The GROUP BY clause allows you...

How to list the most expensive price of items by category in MS SQL Server.

Marek Vavrovic

Aug 7, 2021
2 min

SQL

How to list the most expensive price of items by category in MS SQL Server.

I will use the Northwind database. You can download the db from this page: https://parallelcodes.com/download-sql-northwind-database-bak-...

Marek Vavrovic

Mar 8, 2020
3 min

SQL

Types of SQL Server Joins With Examples

SQL file to download A JOIN clause is used to combine rows from two or more tables, based on a related column between them. SQL Joins are...

Marek Vavrovic

Mar 1, 2020
3 min

SQL

Control-of-Flow

Flow-control statements from T-SQL are rather rudimentary compared to similar commands in other modern programming languages such as...

Marek Vavrovic

Feb 16, 2020
2 min

SQL

SQL Server - Subquery short overview

Many Transact-SQL statements that include subqueries can be alternatively formulated as joins. There are several ways you can categorize...

Power BI

SSIS

Import .CSV files from web site

Data Refresh - Expression.Error column not found

Covid-19 Dashboard

AdventureWorksDW2017 Dashboard

Wide World Importers Dashboard

Slovakia covid-19

DAX measures for Covid-19

Tesla 2009-2020 Financial reports analysis

Covid 19 Dashboard (OWID)

Huffner Textile Dashboard

Northwind dashboard

File System Task

Sequence Container

Execute SQL Task

For Loop Container

Foreach Loop Container

Continue

Project Deployment Model

Slowly Changing Dimensions

Continue

Lookup Transformation

Continue

Derived Column

Continue

Union All vs Merge Transformation

Merge Join

Incremental Load

SSIS Access is denied

Expressions, Parameterized con.

SCD using Lookup and Conditional Split

Append tables

SSRS

DAX

Index

Continue

Pokračovat