Learning ADF part 3

Learning ADF part 3. Created my first dynamic pipeline in @AzDataFactory #AzureDataFactory #learning #sharing #Azure

Computed columns acting weird

A fun little problem having to do with calculated columns in a join.

Learning ADF part 1

I'm learning ADF. I know the basics of what it does, but I'm in no way really knowing of what to do. In this blog series I'll try and record the steps I've followed to get to grips with basics and maybe more. Transferring your data from on premises to Azure I'm assuming you've got … Continue reading Learning ADF part 1 →

Building the session

My review on building and presenting a session for New Stars of Data.

Unexpected view behaviour

A short demo about a view returning an error when it contains a native sql function.

Losing SQL Agent history

A short blog to show and preserve SQL Agent history.

Bulk insert and the Foreign Key mystery

Today i ran into a weird thing. One of our clients found out that with using SAP Data Services (an ETL tooling by SAP) where you can use the bulk load setting, foreign keys on a table got disabled. Demo To test this out, i've created a small demo CREATE TABLE BASE_TABLE ( ID INT … Continue reading Bulk insert and the Foreign Key mystery →

T-SQL Tuesday-118, What are your wishes for SQL Server?

This month the T-SQL Tuesday is hosted by Kevin Chant (b | t) and he asks us what our fantasy feature would be for SQL Server To answer that question, the starting point is the way i work with SQL Server. My company is mostly working with ETL software, meaning the databases are 99% datawarehouses. … Continue reading T-SQL Tuesday-118, What are your wishes for SQL Server? →