SQL Table Partitioning: Boost Query PerformanceIf you’re working with large datasets, you’ve likely noticed that as your data grows, so do your query times. Scanning through millions of…Oct 14, 2024Oct 14, 2024
What’s New in dbt?One dbt, Salesforce Partnership, and the Future of AI-Driven Data Collaboration announced at Coalesce 2024Oct 9, 20241Oct 9, 20241
Published inDev GeniusNVL vs Coalease in SQLA few days ago, while watching a SQL tutorial, I came across the NVL function for the first time. I was curious about how it compared to…Aug 21, 2024Aug 21, 2024
OLAP vs OLTP vs HTAPTimes are changing, the same as the concepts. During these changes, concepts came to the game that we needed to name them. In a fast phase…Aug 14, 2024Aug 14, 2024
Published inDev GeniusHow to use Substack like a Pro?As I’m writing this Medium post, I have to say that using Substack on a mobile phone is really tough. The interface is full of too many…Aug 13, 2024Aug 13, 2024
A Guide to Common Characters in SQL QueriesIn this article, I will cover the most common characters you will see while writing an SQL Query.Aug 13, 2024Aug 13, 2024
Unconventional SQL CodesThink outside the box with SQL coding. You can write it in many unexpected ways. Here are some of the most surprising and creative SQL codesAug 10, 2024Aug 10, 2024
Understanding Slowly Changing Dimensions: Different typesWhen we deal with data management, specially data warehouses, we come across the concept of Slowly Changing Dimensions, or SCDs. What is it?Aug 6, 2024Aug 6, 2024
North Star MetricBusinesses usually struggle to measure their success in the tech world. North Star Metric (NSM) is the key indicator that guides entire…Aug 4, 2024Aug 4, 2024
