Install
SQL, Shell & Data Science
SQL, Bash/PowerShell, and scientific computing languages for analysis and ops.
- 8 Tracked terms
- Last 30 days Feed window
What this topic collects on
An article joins this feed when it matches these terms. Each one is also a search of its own.
Related topics
Latest in SQL, Shell & Data Science
Fixing Misleading Incident Metrics and Broken Links in the Condos Dashboard
3+ hour, 2+ min ago (501+ words) TL;DR: I corrected the condos incident KPI, repaired broken navigation links, and added a missing table by updating the DB migration, stats controller, and front‑end components. The changes eliminate false‑positive metrics and dead‑ends, making the dashboard…...
The Senior Engineer Who Lost a $200K Opportunity Because He Couldn’t Explain One Database Decision
4+ hour, 35+ min ago (967+ words) The interviewer opens with a familiar scenario. “Your Spring Boot application is experiencing slow database queries under heavy traffic. What would you do?” The candidate has nine years of Java experience. “I’d add indexes, optimize the queries, increase the connection…...
SQL Server 2022 Administration Inside Out
6+ hour, 25+ min ago (427+ words) This book aims to update your DBA skills to cover SQL Server 2022, how does it fare? Each version of SQL Server offers both new functionality and builds on existing features. This book aims to help SQL Server DBAs expand and…...
Fundamentals of Database Management Systems
6+ hour, 25+ min ago (333+ words) This book is aimed at people taking a one-semester course in database management as part of their larger information systems management course. As such, it deliberately sets out not to be encyclopedic but to provide a firm grounding. Gillenson starts…...
PostgreSQL Partitioning: When It Helps and When It Does Not
7+ hour, 40+ min ago (190+ words) Understand partition pruning, partition keys, indexes, uniqueness constraints, retention, maintenance overhead, and the workloads that… PostgreSQL Partitioning: When It Helps and When It Does Not Understand partition pruning, partition keys, indexes, uniqueness constraints, retention, maintenance overhead, and the workloads that…...
TryHackMe: The Hollow Shell
11+ hour, 55+ min ago (197+ words) Gunicorn on 5000 redirecting to /login - a Flask app behind a WSGI server. SSH open but no creds yet, so 5000 is the way in. Default/guessed creds worked on /login: Session cookie in hand, /dashboard rendered the upload panel: Two things…...
How Your Database Architecture Shapes the Way Machines Tell Records Apart
8+ hour, 7+ min ago (58+ words) Bioengineer.org Subject of Research: Entity resolution techniques across SQL and NoSQL database management systems Article Title: Entity resolution across SQL and NoSQL database management systems: a comprehensive review News Source: Denise Maddox. (October 12, 2026). How Your Database Architecture Shapes the…...
Lakehouse Tower of Babel: Handling Identifier Resolution Rules across Database Engines
12+ hour, 14+ min ago (578+ words) Physical data layout is one of the most consequential decisions in lakehouse engineering. The author compares Liquid Clustering, ZOrdering, and partitioning across four workload types on Delta Lake, uncovering two undocumented failure modes that likely affect production systems today and…...
What is dbt in data engineering? Architecture guide
1+ week, 14+ hour ago (1700+ words) Scaling Core Apps For Delivery Hero, Local Delivery & Q-Commerce Giant How Vinted Expanded its Global Marketplace with On-Demand Team Extension Building Data Foundations: The Key to Scalable Enterprise AI dbt (data build tool) isn't a pipeline orchestrator or a warehouse,…...
SQL best practices
18+ hour, 29+ min ago (496+ words) Build, deploy & monitor voice agents Boards are built from widgets, and each widget is powered by a SQL query. The SQL dialect here is column-oriented and tuned for fast aggregations over large call datasets, so some of its functions and…...