This tutorial explains how lookups may highly decrease SSIS package performance and when they should only be used in Business Intelligence projects.
SSIS Bad Habits: Wrong OLE DB components configuration
MSSQLTips.com
SSIS Bad Habits: Inefficient Data Staging Strategies
MSSQLTips.com
SSIS Bad Habits: Using Sort and Merge Join Components
MSSQLTips.com
SSIS Extension for Visual Studio 2022
Stack Overflow
An overview of DIFFERENCE and SOUNDEX SQL functions
SQL Shack
Import flat files into seperate SQL Server Tables using SSIS
Stack Overflow
Professional Certification Exams provided at NO COST
GitHub
Since many students and developers cannot pay for the certifications exams fees, I created a #GitHub repository to list all free professional exams provided by tech companies even if it was offered on a specific occasion (ex: Microsoft Ignite Cloud Skills Challenge). I will be grateful for any contribution. And...
[Read More]
Getting started with SQL Server CLR functions
SQL Shack
This article will explain how to create a SQL Server CLR function stored in a C# class library without creating a SQL Server database project. We will first briefly explain the concept of .NET common language runtime (CLR) and then build a C# class library using the .NET framework. Then,...
[Read More]