Constantin Lungudatawise.dev·Apr 24, 2024Raising ERRORS in BigQueryDoes anyone have interesting use cases for the ERROR function in BigQuery? If you like BQ errors so much that you've decided to create your own, or if you're debugging with dirty data, maybe check it out. If will raise an error that you specify w...DiscussPractical BigQuerybigquery
Constantin Lungudatawise.dev·Apr 24, 2024Cleaning up STRINGS in BigQueryData is collected and processed in a number of ways, and it should come as no surprise that it's not always perfect. Perhaps the most important thing you need to do before analyzing data is have a look at how it's presented and check for irregulari...DiscussPractical BigQuerybigquery
Desk Investordeskinvestor.hashnode.dev·Apr 24, 2024Using Microsoft Clarity: A Developer's Guide to Advanced AnalyticsIntroduction to Microsoft Clarity Microsoft Clarity offers an advanced analytics solution that gives developers detailed insights into how users engage with their websites or applications. By providing tools like heatmaps, session recordings, and det...DiscussMicrosoft clarity
Paul PhanforWeaverse Blogsweaverse.hashnode.dev·Apr 24, 2024Shopify Hydrogen Analytics got Fixed.Introduction Integrating analytics tools like Shopify Analytics and Google Tag Manager into Shopify Hydrogen stores has been a technical challenge for many merchants. However, the April 2024 update to Shopify Hydrogen has introduced new features that...Discussshopify
Shiv IyerProshiviyer.hashnode.dev·Apr 23, 2024Optimizing Linux Server Settings for Enhanced ClickHouse Performance: A Guide for High-Volume Data IngestionOptimizing a Linux server for ClickHouse, especially to handle high-velocity, high-volume data ingestion, involves several layers of system tuning. These enhancements are designed to maximize the performance of ClickHouse by leveraging the full poten...DiscussClickHouse
Constantin Lungudatawise.dev·Apr 22, 2024Using INSTR in BigQueryIf you ever need to do something different based on the existence of a particular substring in hashtag#BigQuery, take a look at the INSTR function. It returns the 1-based index of the first occurrence of a substring (1 or more characters) in another ...Discuss·40 readsPractical BigQuerybigquery
Shiv Iyerfor#AzureSQL #SQLServer #Azure #SQLazuresql.hashnode.dev·Apr 22, 2024How to Manage DML Locks in SQL Server: Implementation and Best PracticesIn SQL Server, Data Manipulation Language (DML) locks are used to manage access to database resources during insert, update, or delete operations. These locks help maintain data integrity and ensure transaction consistency across the database. Unders...DiscussSQL Server Internals SQL
CreativeTrulyforCreativeTrulycreativetruly-1712535850238.hashnode.dev·Apr 21, 2024How does performance measurement improve content delivery?Performance measurement significantly improves content delivery by providing a systematic approach to evaluating and enhancing the effectiveness, efficiency, and impact of content strategies. Enhanced User Experience: By tracking metrics such as pag...DiscussSEO
Shiv Iyerfor#AzureSQL #SQLServer #Azure #SQLazuresql.hashnode.dev·Apr 20, 2024Strategies for Enhancing SQL Server Performance with Reduced LoggingAchieving optimal SQL Server performance with reduced logging involves several strategies to minimize the amount of data logged to the transaction log. This is especially relevant in high-volume transaction environments where logging can become a bot...DiscussSQL
Shiv IyerProshiviyer.hashnode.dev·Apr 19, 2024ClickHouse for SQL Server DBAs - Optimizing Query Performance with Skipping Indexes in ClickHouseIn ClickHouse, narrow indexes, often referred to as "skipping indexes" or "data skipping indexes," are used to improve query performance by allowing the system to skip over blocks of data that do not match the query conditions. This is particularly e...DiscussSQL Server