Stefan GrafinCodeXStabilize your ETL based data offerings via schema/table switching — example with SQL ServerConsistency and high availability are 2 big concerns for everything regarding data based applications. This is also true for your data…4 min read·Dec 9, 2023----
Stefan GrafBring your (py)spark code to the next level with User Defined Functions (UDFs) and the native…Photo by Alejandro Piñero Amerio on Unsplash7 min read·Nov 21, 2023----
Stefan GrafinCodeXElevate your KQL with Detective Kusto — explanation for Season 2 — Case stolen carsIf you want to improve your Kusto query language knowledge you can do so while solving exciting challenges with the Kusto Detective game…5 min read·Nov 11, 2023----
Stefan GrafinCodeXMaster These 4 SQL Techniques for Interview SuccessNo matter what role you’re interviewing for — Data Science, Data Engineering, Analytics Engineering, or Data Analysis — SQL will likely be…4 min read·Jul 9, 2023----
Stefan GrafinCodeXDelta Lake — game changing update to productionize Change Data FeedEverybody who worked with Delta probably already knows the great benefits of using Change Data Feed (CDF). This feature enables your…4 min read·Jun 4, 2023----
Stefan GrafNew Approach — CI/CD for Synapse Analytics Pipelines with Azure DevOps yaml pipelines (Part 1.1)Photo by Danil Shostak on Unsplash4 min read·Feb 3, 2023----
Stefan GrafinCodeXAzure data engineering game changer — Managed Airflow in ADFAirflow is the most common orchestration tool, but until now there was no easy way to create an Airflow service inside Azure. Different to…3 min read·Feb 2, 2023----
Stefan GrafinCodeXSolving Data Analysis Challenges using SQL with every step explained (Part 1)Looking into the thought process of other developers can be often very beneficial in order to understand how some concepts are working…4 min read·Sep 20, 2022----
Stefan GrafinCodeXSQL — CASE VS PIVOTPivot tables often provide great value to your Analysis. In this blog, I’ll show you how to create them in SQL using CASE and Pivot(T-SQL).4 min read·Aug 28, 2022----
Stefan GrafinCodeXSQL — Advanced Usage of CASE StatementData Cleaning, Binning and Flexible Ordering can be all done by using the CASE statement. I’ll show you how to use it and how you can…3 min read·Jul 25, 2022--3--3