ChistaDATA Inc.

@nick_white @deedydas Using a recursive SQL CTE for BFS in a graph traversal? That’s next-level SQL wizardry! 🚀 Not your everyday use case, but a testament to the versatility of SQL. Props to them for thinking outside the box! 👏 #SQL #GraphTraversal #DataEngineering

@deedydas Using a recursive SQL CTE to run BFS for graph traversal in an interview. Definitely not your typical SQL use case. sounds like they really knew their stuff. impressive!

The most bizarre coding interview I've ever done was at Facebook when as usual I asked a candidate to write in any language of their choice.. And they nonchalantly said "I'll write it in SQL", to which I almost let loose a chuckle until...

@deedydas I had a candidate do a very simple linked list question (find and remove a node) entirely via C++ template metaprogramming. We made an offer but he turned us down saying the work would be too boring

For non programmers, SQL (structured query language) is usually used to get data in and out of tables. Few people know it can be used as a full feature programming language and have the skill to do it. It's like asking someone to take a picture and they draw a photorealistic one in pencil.

Using strace to troubleshoot #MySQL performance issues can be highly effective, especially for diagnosing low-level system calls and pinpointing issues like excessive I/O, network delays, and file access bottlenecks. strace captures and logs system calls made by a process, which helps you understand MySQL's interactions with the operating system. #MySQLPerformance @MinervaDB #dba zurl.co/6jaj

chistadata.com/tune-clickhous… How to Tune #ClickHouse for Performance immediately after Installation #DBATips #SQLTips #BigDATA #Analytics

zurl.co/iwgT How do you implement row-level security in MariaDB? #MariaDB #DBATips #OpenSource #DBA #DataSecurity

lnkd.in/gMDWfG5R How Long-Running Queries Negatively Influence PostgreSQL Execution Plans and Database Performance? hashtag#PostgreSQL hashtag#DBA hashtag#SQL hashtag#OpenSource hashtag#PostgreSQLTips

zurl.co/fKPL Implementing an Oracle RMAN-Like Backup and Recovery Toolkit for ClickHouse #ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics #Oracle #RMAN

Use tools like Apache Avro or Protobuf to handle schema changes seamlessly in your data pipeline, ensuring backward compatibility. #SchemaManagement #DataPipelines #BigData #AI #ML #DataScience

Reduce disk I/O bottlenecks by using compression and partitioning in your data pipelines. This speeds up data ingestion and processing! #DataEngineering #BigData #IOPerformance

Projections in ClickHouse are a powerful feature designed to optimize query performance by precomputing and storing the results of specific queries or aggregations. #ChistaDATA @chistadata chistadata.com/performance-tr…

zurl.co/fOof Achieving Real-time Analytics with ChistaDATA's ClickHouse #ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics

zurl.co/Ilpx Addressing #Kafka Partition Imbalance @chistadata @ChistaData #DataScience #DataScientist #OLAP #AI #ML #BigDATA #Analyics #RealTimeAnalytics #ClickHouse

zurl.co/RDn9 Understanding ClickHouse MergeTree #ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics

Great episode! 🎙️ Excited to hear how AI is transforming customer experiences at the contact center level. Looking forward to the future of #TheNewCX with @Five9 and how #AI will continue driving innovation. 🔥 #CXNation #AIForCX Tuning in now! 🎧

Exciting move towards transparency and collaboration! 👏 Open-source public service code fosters innovation, accountability, and community-driven improvements. Hope more countries follow Switzerland's and Bulgaria's example! 🌍 #OpenSource #DigitalSovereignty #TechForGood

zurl.co/B4Av Enhancing ClickHouse Performance: Strategic Insights on Partitioning #ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics

zurl.co/H9bz Why Delta Updates Are Not Recommended in OLAP Databases #ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics

zurl.co/4mwl Mastering Performance Tuning in ClickHouse: Tips for Inspecting Statistics Objects #ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics

zurl.co/hSxg Implementing a High-Performance 3-Node ClickHouse Cluster with ClickHouse Keeper for Read-Write Splitting and TTL-Based Archiving #ClickHouse #OLAP #SQL #SQLTips #DBA #Analytics #ColumnStore #RealTimeAnalytics