Cloud Technology – Why you should upgrade your skills now!
5 reasons why you should jump on the proverbial bandwagon and start to upgrade your cloud skills.
Cloud Technology – Why you should upgrade your skills now! Read More »
Logical Query Processing
Understanding the logical query processing of SQL will help you write better and cleaner code
Logical Query Processing Read More »
5 Advanced SQL queries every Data Engineer & Scientist should know!
Over the years, I’ve worked on dozens of data engineering projects and these 5 advanced SQL queries have queries have gotten me out of few jams! Hope you find them useful 1. Using the SQL APPLY Operator Ever find yourself trying to find the last transaction, a set of customers made? Struggled with trying to
5 Advanced SQL queries every Data Engineer & Scientist should know! Read More »
Querying PostgreSQL with AWS Athena
Amazon Athena make it easy to analyze semi-structured and non-structured data like json, xml etc. 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. For any Data Scientist, this opens up a world of potential because now it’s possible to write SQL queries that combine data from both relational and non-relational data source in a single query!
Querying PostgreSQL with AWS Athena Read More »
Installing SSDT
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 same look and feel. What
Stop using SSMS to build you SQL server DB. Use SSDT instead.
Stop using SSMS to build you SQL server DB. Use SSDT instead.
Stop using SSMS to build you SQL server DB. Use SSDT instead. Read More »