ETL (Extract Transform and Load)

SQLServerCentral Article

The Art of Data Ingestion - Part 1

  • Article

Data movement is a fundamental piece of a data engineer’s duties, and recently I’ve been thinking about the art of data movement. What are some of the most important pieces that a data engineer needs to think about when confronted with data ingestion? There is of course data exporting as well, and in that case, […]

5 (6)

2022-11-11

2,627 reads

External Article

Scala and Apache Spark in Tandem as a Next-Generation ETL Framework

  • Article

Scala and Apache Spark might seem an unlikely medium for implementing an ETL process, but there are reasons for considering it as an alternative. After all, many Big Data solutions are ideally suited to the preparation of data for input into a relational database, and Scala is a well thought-out and expressive language. Krzysztof Stanaszek describes some of the advantages and disadvantages of a scala-based approach to implementing and testing an ETL solution.

2017-06-12

4,658 reads

Blogs

Creating a user for a STONITH resource in vSphere

By

I previously blogged about how to create a STONITH resource for a pacemaker cluster...

Default event_file path for Extended Events

By

Foreword Have you ever wondered where the .xel file is saved when you create a...

Query Store Hints in SQL Server 2022

By

Another neat little feature in SQL Server 2022 is Query Store Hints. This is...

Read the latest Blogs

Forums

Display Top N values of a table with calculation next to it

By Soof1234

Hi, In Power BI Report Builder I need to use SSRS code for my...

Package runs in Debug mode but fails otherwise

By Alexp012

Hi We have a SSIS package that uploads data to Blob storage. The package...

Can anyone suggest a plan with backup full and backup log without backup diff ?

By vpmaciel

I need only one backup full at mid night, and one backup log each...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers