ShimainDev 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 21Aug 21
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…Aug 14Aug 14
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…Aug 13Aug 13
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.Aug 13Aug 13
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 codesAug 10Aug 10
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