SSIS Bad Habits (6 articles)
I have been working with SSIS for more than ten years and answering related questions on Stack Overflow for more than five years. During this period, I noted several bad practices that may affect the package performance used by SSIS users. I decided to start writing a series to explain those practices’ side effects and provide valuable resources.
- SSIS Bad Habits: Using Sort and Merge Join Components
- SSIS Bad Habits: Inefficient Data Staging Strategies
- SSIS Bad Habits: Wrong OLE DB Components configuration
- SSIS Bad Habits: Slow Lookup transformations
- SSIS Bad Habits: Inefficient Data Staging Strategies - Part 2
- SSIS Bad Habits: Decreasing SSIS Package Performance
SSIS features face-to-face (18 articles)
A series that aims to remove any confusion and to illustrate some of the differences between similar features provided by SQL Server Integration Services.
- SSIS OLE DB Source: SQL Command vs Table or View
- SSIS Expression Tasks vs Evaluating variables as expressions
- SSIS OLE DB Destination vs SQL Server Destination
- Execute SQL Task in SSIS: SqlStatementSource Expressions vs Variable Source Types
- Execute SQL Task in SSIS: Output Parameters vs Result Sets
- SSIS Derived Columns with Multiple Expressions vs Multiple Transformations
- SSIS Data types: Change from the Advanced Editor vs Data Conversion Transformations
- SSIS Connection Managers: OLE DB vs ODBC vs ADO.NET
- SSIS Flat Files vs Raw Files
- SSIS Foreach Loop vs For Loop Container
- SSIS: Execute T-SQL Statement Task vs Execute SQL Task
- SSIS Lookup transformation vs. Fuzzy Lookup transformation
- SSIS Pivot transformation vs. Unpivot transformation
- SSIS Merge Join vs. Merge transformation
- Data access modes in SSIS OLE DB Destination: SQL Command vs. Table or View
- SSIS XML Source vs. XML Task
- SSIS Script Task vs. Script Component
- SSIS term extraction vs. term lookup
Learn Biml (10 articles)
An introduction to Business Intelligence Markup Language (BIML).
- Getting started with Biml
- Converting SSIS packages to Biml scripts
- Using Biml scripts to generate SSIS packages
- Extending Biml with C# scripts
- Using external C# script files within Biml
- Biml alternatives: Building SSIS packages programmatically using ManagedDTS
- Biml alternatives: Building SSIS packages programmatically using EzAPI
- Building databases using Biml
- Building SSAS OLAP cubes using Biml
- Building SSAS Tabular models using Biml
SSIS Hadoop Components (3 articles)
A series that explains the SSIS Hadoop features added in SQL Server 2016.
- SSIS Hadoop Connection Manager and related tasks
- Importing and Exporting data using SSIS Hadoop components
- Connecting to Apache Hive and Apache Pig using SSIS Hadoop components
Sphinx search engine (3 articles)
A series that explains how to install and use this search engine to create full-text indexes over relational databases (SQL Server).
- Getting started with Sphinx search engine
- Building full-text indexes using the Sphinx search engine
- Manticore search: a continuation of the Sphinx search engine
Integrating SQL Server with NoSQL databases (5 articles)
A series that explains different NoSQL database technologies, and how to integrate them with SQL Server databases
- Import data from MongoDB to SQL Server using SSIS
- Getting started with the Neo4j graph database
- Migrating SQL Server graph databases to Neo4j
- Export indexes and constraints from SQL Server graph database to Neo4j
- Migrating SQL Server graph databases to ArangoDB
Installing Hadoop ecosystem technologies on Windows (4 articles)
A series that helps system administrator or data engineers while installing Big Data technologies on Windows operating system
- Installing Hadoop 3.2.1 Single node cluster on Windows 10
- Installing Apache Hive 3.1.2 on Windows 10
- Installing Apache Pig 0.17.0 on Windows 10
- Reasons to not install Hadoop on Windows
Installing Hadoop ecosystem technologies on Ubuntu (3 articles)
A series that helps system administrator or data engineers while installing Big Data technologies on Ubuntu operating system
- Installing Hadoop 3.1.0 multi-node cluster on Ubuntu 16.04 Step by Step
- Getting Started with Apache Kafka and Apache Flume (Import data to HDFS)
- Getting Started With Apache Spark, Python and PySpark