Organizations are increasingly using cloud computing for new initiatives or to replace legacy systems. What this means is that the spending that previously went to building and maintaining traditional IT solutions is being diverted to the cloud. The growing preference for cloud first and cloud smart services means that cloud…

Over the years, I’ve worked on dozens of data engineering projects and these 5 queries have queries have gotten me out of few jams! Hope you find them useful 1. Using the APPLY Operator Ever find yourself trying to find the last transaction, a set of customers made? Struggled with trying to use combinations of…

Amazon Athena makes it easy to analyze semi-structured and non-structured data like json, csv & xml directly in Amazon S3 using SQL. However, it also allows you to easily query a number of relational databases hosted in AWS such as mySQL and PostgreSQL. …

SQL Server data tools (SSDT) for those that don’t know is an IDE for building SQL server content (Relational DBs, SSIS, SSRS or SSAS projects and packages). It’s gone by a few different names over the years (and versions) but broadly speaking, no matter the name, they all have the…