diponkar.paul

Diponkar Paul has 11+ years of experiences in IT industry and specialized in Business Intelligence domain, currently working as a Senior Data Engineer at Fiera Capital, Canada. Through his career, he designs and developed medium and large data warehouses and delivered business critical analytical solution. He is leading Toronto PASS Group; which is part of the world largest data professional community named PASS. He got diverse background, has been working and studied in different Geo location includes Canada, Denmark, UK, Sweden and Bangladesh. He writes technical blog and love to share his learning within the community.
  • Blog: http://allaboutdata.ca/
  • Jobs: Senior Data Engineer
  • Skills: Big data, Business Intelligence, Database, ETL, ELT, Data Warehouse

How to simulate Case statement in Azure Data Factory (ADF) compared with SSIS?

This post will describe how you use a CASE statement in Azure Data Factory (ADF). If you are coming from SSIS background, you know a piece of SQL statement will do the task. However let's see how do it in SSIS and the very same thing can be achieved in ADF. Problem statement For my […]

4.5 (2)

2020-11-12

2,046 reads

Blogs

Updating my Kubernetes Raspberry Pi Cluster to containerd

By

There’s been a lot of conversations happening on twitter over the last couple of...

Daily Coping 3 Dec 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – December 2020 – Participate in the Advent of Code.

By

Christmas. Depending on where you live it’s a big deal even if you aren’t...

Read the latest Blogs

Forums

Export nvarchar(4000) to Excel

By Sailor

I'm trying to use the SSMS 18.7.1  Export Wizard to export to an Excel...

not able to use my user defined function

By DaveBriCam

I have a function I have created and need some help in how to...

SSRS site settings security and Home folder Security

By graham.measures

I am rewriting 100 or so reports on a SSRS 2012 server and migrating...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers