Shiv IyerforAll things PostgreSQL from MinervaDBpostgresqlblog.hashnode.dev·Apr 2, 2024How to Improve PostgreSQL Efficiency: Removing Duplicate Rows EasilyImpact of Duplicate Rows on PostgreSQL Performance Duplicate rows in a PostgreSQL database can significantly impact its performance and efficiency in several ways: Increased Disk Space Usage: Duplicates consume additional disk space unnecessarily, w...Discuss·66 readsSQL
Shiv IyerProshiviyer.hashnode.dev·Feb 2, 2024How Log Shipping and Delayed Log Shipping are implemented in ClickHouse?Log shipping is a method ClickHouse uses to replicate data across different instances or clusters to ensure high availability, fault tolerance, and disaster recovery. Delayed log shipping extends this concept by introducing a deliberate lag in replic...Discuss·31 readsClickHouse
Shiv IyerProshiviyer.hashnode.dev·Jan 28, 2024Troubleshooting MySQL Deadlocks due to lock partitioningDealing with MySQL deadlocks, especially those arising from lock partitioning, can be challenging. Let's break down the problem and work through some strategies to address it. Understanding Deadlocks and Lock Partitioning Deadlocks: In MySQL, a dead...DiscussMySQL
Kgothatso Mampyekgothatso.hashnode.dev·Sep 23, 2023Take the role of a Business Analyst with your FirstStoreFirstStore sample sites helps you become a business analyst (BA) which is a professional who works within an organization to identify business needs and find technological solutions to business problems. Their main responsibilities often include: Req...Discussanalysis
Jamie Richardsphp-developer.hashnode.dev·Sep 4, 2023Build, measure, learn - part 2So development for BML has stalled a little due to the amount of development work coming in (three large web projects queued up at the moment) so I've had time to sit back and ponder about progress so far and what will be next for the project. Why? S...DiscussBuild, Measure, LearnBuild In Public
Masievu Alvinalvo.hashnode.dev·Jul 10, 2023The Part of Analytics in Driving Commerce ChangeIntroduction: In the present era of a digital revolution, Analytics has a crucial role to play in bringing about a transformation in businesses. With the enormous amount of data that the digital age offers, Analytics helps us gain valuable insights i...Discussanalytics
Ramiz Thebaramiztheba.hashnode.dev·Jun 7, 2023Upgrading to GA4: A Guide for E-Commerce WebsitesIntroduction: With the upcoming deprecation of the classic version of Google Analytics (Universal Analytics), website owners and marketers are urged to make the transition to the latest iteration of the platform - Google Analytics 4 (GA4). GA4 repres...Discuss·1 like·27 readsga4
Malcolm MikaZukimikacodez.hashnode.dev·May 29, 2023How to use Analytics to improve your Technical documentation's performanceTechnical documentation plays a crucial role in helping users understand and utilize complex products or services. However, creating effective documentation is only half the battle. To truly optimize its impact, you need to continuously monitor and i...Discussdocumentation
Md Junayed Hossainjunayedhudbrac.hashnode.dev·May 20, 2023Small Project on Data Analysis of Inventory Dataset-- Returns first 100 rows from tutorial.excel_sql_inventory_data SELECT product_id, product_name, product_type, unit, price_unit, wholesale, current_inventory FROM tutorial.excel_sql_invento...Discuss·58 readsSQL