Constantin Lungudatawise.dev·Mar 27, 2024Boolean data type in BigQueryI remember that one of the things that struck me some years ago when switching from SQL Server to BigQuery was the existence of the bool data type in the latter, which I didn't have before. I still see from time to time BigQuery code that does not le...DiscussPractical BigQuerySQL
Data Punditdatapundit.hashnode.dev·Mar 27, 2024Bridging the Data Chasm: A Data Scientist's Journey in JubaIntroduction: Stepping into the realm of data science in Juba, South Sudan, is akin to embarking on a challenging expedition into uncharted territories. As a data scientist, accustomed to the bustling tech hubs of more developed regions, adapting to ...DiscussData Science
Constantin Lungudatawise.dev·Mar 25, 2024COALESCE vs IFNULL vs NULLIF in BigQueryWhat are they and when to use them? - IFNULL tests a column for the NULL value, returning the original value if it is NOT NULL and the second value we provide otherwise. The two columns need to be coercible to the same datatype. It's works like ISN...DiscussPractical BigQuerySQL
Constantin Lungudatawise.dev·Mar 25, 2024GREATEST & LEAST in BigQueryHave you ever had to compute the biggest or smallest value across multiple columns? If so, note that in addition to using CASE WHEN or IF, we have GREATEST and LEAST, which will do exactly that. I've also though they reminded me of how MIN / MAX ...DiscussPractical BigQuerybigquery
Shiv IyerProshiviyer.hashnode.dev·Mar 25, 2024How to Improve Log File Sync in MySQL InnoDB for Better Performance: A TutorialThe log file sync breakdown in MySQL's InnoDB storage engine is a critical aspect of understanding the performance and efficiency of database transactions. InnoDB uses a write-ahead logging (WAL) strategy to ensure data integrity and consistency, whi...Discuss·3 likesMySQL
Shiv Iyerfor#AzureSQL #SQLServer #Azure #SQLazuresql.hashnode.dev·Mar 24, 2024How to Troubleshoot Performance Issues in Azure SQL Using sys.dm_exec_requestsThe Dynamic Management View (DMV) sys.dm_exec_requests is an invaluable tool in Azure SQL Database for troubleshooting performance issues. It provides real-time data about each request currently executing within SQL Server, including queries, backgro...DiscussSQL
Samriddhi Sharmasamriddhisharma.hashnode.dev·Mar 24, 2024Exploring Data AnalysisIntroduction: Welcome to the world of data analytics, where we turn data into useful information. Whether you're new to this or just curious, this blog will help you understand the basics. We'll break down complicated ideas and give you the skills to...Discussdata
Constantin Lungudatawise.dev·Mar 21, 2024RANGE data type in BigQueryI work quite a lot with temporal/SCD2 type table so the new (still in preview) RANGE data type in BigQuery (and its supporting methods) are a welcome addition. What does it do? So instead of storing valid_from & valid_to in separate columns, we n...Discuss·59 readsPractical BigQuerySQL
Adam Brakhaneblog.adambuilds.com·Mar 20, 2024Ask "Why?" 5 TimesDigging deep into the reasoning behind business outcomes and strategic decisions has always illuminated paths to better understanding and more informed actions. The "5 Whys" technique reliably and quickly brings clarity to any situation. Try it and l...Discussproblem solving skills
Constantin Lungudatawise.dev·Mar 18, 2024DELETE + INSERT vs MERGE in BigQueryHow do you merge changes from staging tables into target tables in BigQuery? I've previously covered swapping out partitions using bq command and using constant false predicate "MERGE on FALSE", but I've learned that you can now DELETE entire parti...Discuss·60 readsPractical BigQuerybigquery