Microsoft has recently taken us on a word lingo with the launch of Azure Synapse Analytics. At Kohera, we've experienced some confusion in the market between Azure Synapse as a standalone product and Azure Synapse Analytics as a SaaS platform. We guess it's time to set things straight once and for all, or at least for a while.
Sometimes, Databricks can be a bit sluggish. Caching with, for instance, the Delta Cache Accelerated Worker can help you speed it up. We'll explain how it does that.
Oh, this is cheesy, can’t believe we could ever dare to mention Mariah Carey in our blogpost series. Well, the holiday season is starting, so there is no escape at all 😊. By the way, what I meant with the title was: All I need for Christmas is you… Azure Data Flow.
In previous blogposts we have been creating the Linked Services in Azure and CTAS’ing files from Azure Data Lake into tables on Azure DWH. I finished my previous post by advising you to use Azure Data Factory V2 (ADF) as an orchestration tool for your ELT load. This is exactly what we’ll be doing in this post.
Enter Polybase External Tables. A technology introduced in SQL Server Parallel Datawarehouse (PDW) around 2013 and became more generally available since SQL 2016, allowing you to read flat files as easy as if they were database tables.
How to best describe Azure Data Factory (ADF) V2? A friend of mine described it as the ETL of the skies. And since I based almost my entire career on ETL tools, this sounded like music to my ears. After running a nice project in ADF I can now look back on this statement, and conclude there is some truth behind it.
In SQL Server 2016 heeft Microsoft ons voorzien van tal van nieuwigheden. Naast de talrijke mooie wijzigingen in de SQL Server engine, SSAS en SSRS, is er ook aandacht besteed aan SSIS 2016. Deze verbeteringen staan wat minder in de kijker, maar zijn daarom niet minder de moeite waard.