ShimaOLAP 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…2d ago2d ago
ShimainDev 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…2d ago2d ago
ShimaA Guide to Common Characters in SQL QueriesIn this article, I will cover the most common characters you will see while writing an SQL Query.3d ago3d ago
ShimaUnconventional 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 codes6d ago6d ago
ShimaUnderstanding 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 6Aug 6
ShimaNorth Star MetricBusinesses usually struggle to measure their success in the tech world. North Star Metric (NSM) is the key indicator that guides entire…Aug 4Aug 4
ShimainDev GeniusTutorial Series: Ignore .DS_Store File in Git forever!Here is the solution that I just came to and look at that. A lifesaver way to get rid of .DS_Store files forever.Jul 291Jul 291
ShimainCode Like A GirlCron ExpressionsCron expressions are simply strings. We use them when we need flexible automated scheduling on a Unix-like OS. Each cron expression…Jun 26Jun 26
ShimainDev GeniusCatchup vs Backfilling in AirflowBoth the Backfilling and Catchup mechanisms are concepts of airflow and really important for managing and ensuring the execution of tasks…Jun 24Jun 24