Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2
In the first article in this transforming data series, I discussed how powerful PostgreSQL can be in ingesting and transforming data for analysis. Over the last few decades, this was traditionally done with a methodology called Extract-Transform-Load ( …
Giving Feedback on Microsoft Data Platform Tools
As a data professional, there is a set of tools that you use on pretty much a daily basis. Before I started as the editor of Simple-Talk, there were two Microsoft tools I used every day of the work week, and also for my hobby work: SSMS (SQL Server Man …
Joining Queries in Azure Data Factory on Cosmos DB Sources
This article illustrates how to join two queries using ADF (Azure data factory). Prerequisites First, prepare your data sources. Make sure you have at least two data sources (such as tables, files, or databases) that you intend to join together. Additi …