Technical Article

Build a Metadata-Driven ETL Platform by Extending Microsoft SQL Server Integration Services

SQL Server 2008 Integration Services (SSIS) provides a flexible and scalable architecture that enables high-performance data extract, transform, and load (ETL). The Microsoft Business Intelligence Center of Excellence has extended SSIS to a metadata-driven platform to more effectively build, deploy, and manage ETL processes in large data warehousing environments.

Technical Article

Data Warehouse Capacity Planning as Capacity Enforcement

Capacity planning is a problem for a data warehouse because it sets contrasting functional requirements against each other. On one hand, data warehouse customers consume data warehouse capacity as they query the data in the data warehouse business intelligence (BI) reporting. Meanwhile, applications consume data warehouse capacity as they load data into a data warehouse through the extract, transform and load (ETL) process.

Blogs

Why Claude?

By

Every major model out there can summarise documents, write code and answer multi step...

Overcoming Imposter Syndrome: A Plan

By

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

By

“On the way to a grand goal, celebrate the smallest victories as if each...

Read the latest Blogs

Forums

How are you handling sensitive data when using AI for queries or transformations

By rom_c99

Hi everyone, I’ve been looking into using AI for helping with data-related tasks (writing...

BCA KCP Jalan Panjang TLP/WA 08216977749

By deveiljames62

Graha Elok Mas, Jl. Panjang No.79 EF, RT.6/RW.1, Kedoya Sel., Kec. Kb. Jeruk, Kota...

BCA KCP Daan Mogot Dua TLP/WA 08218573837

By deveiljames62

Jl. Daan Mogot No.48 A, Jelambar, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah Khusus...

Visit the forum

Question of the Day

May the Fourth Be With You Fun

In honor of May the fourth and Star Wars (may the force be with you), finish this quote:

"Do, or do not.  ..."

See possible answers