ETL/SSIS/Azure Data Factory

Technical Article

Top 10 Methods to Improve ETL Performance Using SSIS

  • Article

Extraction Transformation Load (ETL) is the backbone for any data warehouse. In the data warehouse world data is managed by the ETL process, which consists of three processes, Extraction-Pull/Acquire data from sources, Transformation-change data in the required format and Load-push data to the destination generally into a data warehouse or a data mart.

2023-10-25

Blogs

Friday Flyway Tips–Quick Command Line Access

By

One of the things I had to do recently in a demo was access...

A New Word: Aesthosis

By

aesthosis– n. the state of feeling trapped inside your own subjective tastes – not...

A First Look at Redgate’s Subsetter

By

I have been a proponent of subsetting databases in dev/test for a long time....

Read the latest Blogs

Forums

Frustrated trying to get Cross DB Access by Signing SP with Certificate

By Ken McKelvey

Maybe it is lack of caffeine, but I cannot see why the following test...

SSIS Execute Package Fail in SSMS but Agent Job Succeeds

By jerryszz

Hello, I created a SSIS package to transfer data from an XML file to...

Cyber Insurance for War

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cyber Insurance for War

Visit the forum

Question of the Day

Writing to Clones

I run this code on SQL Server 2019:

DBCC CLONEDATABASE(imdb, imdb_dev)
I then change to the cloned database, imdb_dev, and run some queries. I then run this code while testing:
INSERT dbo.Title (TitleID, Title, DateReleased) VALUES (3234, 'Maestro', '2023')
GO
What happens?

See possible answers