Implement SFTP File Transfer with SSIS and PSFTP
In this tip we will use the free tool PSFTP (from the PuTTy software family) in combination with SQL Server Integration Services (SSIS) to download a file from an SFTP server.
Koen Verbeeck is a seasoned business intelligence consultant with over a decade of experience with the Microsoft Data Platform. He holds several certifications, including Azure Data Engineer. He's a prolific writer, with over 375 articles on technologies such as Microsoft Fabric, SSIS, ADF, SSAS, SSRS, MDS, Power BI, Snowflake and Azure services. He has spoken at various events such as PASS, SQLBits, dataMinds Connect and many others. He frequently delivers educational webinars on MSSQLTips.com. For his efforts, Koen has been awarded the Microsoft MVP data platform award for many years.
- MSSQLTips Awards:
- Leadership Award (200+ Tips) - 2021
- Author of the Year - 2014/2020/2022
- Author Contender - 2024/2025
Configure an Azure SSIS Integration Runtime
In this tip we are going to configure an Azure-SSIS IR using an Azure SQL database. The advantages of using Azure SQL DB is that it is lightweight and easy to set-up.
Intra-Day Changes for Type 2 Slowly Changing Dimensions in SSIS
This is the final part of a series of tips on implementing a slowly changing dimension type 2 in SQL Server Integration Services (SSIS). In this final part we will introduce a solution for dealing with intra-day changes.
Optimizations for Type 2 Slowly Changing Dimensions in SSIS
In the previous tips of this series we looked at how to implement a type 2 slowly changing dimension in SSIS. In this tip we look at how we can further optimize the process.
Optimize Type 2 Slowly Changing Dimensions in SSIS – Part 2
In this tip we continue our discussion on how to implement a slowly changing dimension type 2 in SQL Server Integration Services.
Implement a Slowly Changing Type 2 Dimension in SSIS – Part 1
In this tip we look at how you can implement a type 2 slowly changing dimension with SQL Server Integration Services.
How to Create an Index Line Chart in SSRS
In this tip we look at how to create an index line chart in SSRS.
How to Create A Lollipop Chart in SSRS
In this tip we look at how to create a Lollipop Chart in SQL Server Reporting Services.
How to Create Dumbbell Plots in SSRS
In this tip we look at how to create Dumbbell Plots in SQL Server Reporting Services.
How to Create a Slope Chart in SSRS – Part 2
The goal of this tip is to create a slope chart using the built-in capabilities of SQL Server Reporting Services (SSRS).
How to Create a Slope Chart in SSRS – Part 1
In this tip we look at how to create a Slope Chart in SQL Server Reporting Services.
SQL Server T-SQL Window Functions Tutorial
This tutorial covers SQL Server windows functions like aggregates, ranking, statistical functions and more.
SQL Server Window Functions Examples
In this section, we look at a couple of simple examples of windows functions in SQL Server using OVER, RANK and PERCENTILE_CONT.
SQL Server Window Function Syntax
In this part of the tutorial we will look at how window functions by breaking down each component.
SQL Server Window Aggregate Functions SUM, MIN, MAX and AVG
In this part of the tutorial we’ll look at aggregate functions – sum, min, max, avg, etc. – and their relation with window functions.
SQL Server Window Functions ROW_NUMBER
In this section we look at how to use the SQL Server ROW_NUMBER function.
SQL Server Window Functions RANK, DENSE_RANK and NTILE
The topic of this part of the tutorial is about ranking functions like rank, dense_rank and ntile.
SQL Server Window Functions LEAD and LAG
In this section we look at how to use lag, lead, first_value and last_value.
SQL Statistical Window Functions PERCENTILE_DISC and PERCENTILE_CONT
In this part of the tutorial we look at using PERCENTILE_DISC, PERCENTILE_CONT, CUME_DIST and PERCENT_RANK functions.
SQL Server Window Functions Performance Improvement
In this section we look at how to use windowing functions along with performance in mind.
SQL Server Window Functions Gaps and Islands Problem
In this last part of the tutorial, we’ll look into one final use case that can be solved with window functions: gaps and islands.
How to use the TREATAS function in DAX
One of the relatively new functions for Analysis Services Tabular, Power Pivot and Power BI is TREATAS. In this tip, we’ll introduce you to the syntax and concepts of the function and show some uses cases where this function can be useful.
Calculating Employee Attrition with DAX – Part 2
In this tip we show how you can calculate employee attrition rates with SSAS. We look at using DAX with related and unrelated dimensions to show how this can be done.
Calculating Employee Attrition Rate with DAX – Part 1
In this tip we show how you can calculate employee attrition rates. You can apply these methods in Power BI Desktop, Analysis Services Tabular or Azure Analysis Services.