MANOJ PRADHAN·1d agoHow I Cut 10,000+ Db2 CPU Hours a Year: The FrameworkWhat 23+ years as a z/OS DBA taught me about turning tuning into a repeatable practice. Db2 13 for z/OS.
Pranay Ravi·1d agoNot Every Slow Query Needs a New IndexWhat a SQL review taught me about assumptions, AI-written queries, and common-sense tuning
Shree Kavya·Oct 28Why Your Lakehouse Queries Got Slower Every Month: The Small Files Problem, Measured and FixedHow tiny files quietly pile up, how to measure the damage in five minutes, and the compaction commands for Delta and IcebergA response icon1A response icon1
Robert Broeckelmann·Oct 22iya-sts: One Million OIDC SessionsWe wanted to know whether iya-sts could hold a million people signed in at once through OpenID Connect, with each session kept alive the…
Igor Vinicius·Oct 16Performance tuning: removendo LOB da página de dados no SQL ServerSe a sua query não seleciona uma coluna VARCHAR(MAX), ela também não paga o custo de lê-la, certo? Foi o que eu pensei por muito tempo, até…
Ebru Karadeniz·Oct 13Bulk Processing in PL/SQL: Elevating Performance with FORALL and BULK COLLECTBulk Processing in PL/SQL: Elevating Performance with FORALL and BULK COLLECT
InTowards AIbychakshu_salgotra·Oct 6Part XI — RDD vs DataFrame vs Dataset: Why Your “Type-Safe Refactor” Made Spark 3x SlowerThree APIs, two execution worlds — how Catalyst and Tungsten treat structured plans, why typed lambdas are black boxes, and when dropping…A response icon1A response icon1
InTowards Data EngineeringbyFahad Shamim·Sep 28Data Partitioning Deep Dive: From SQL Server and Azure SQL to Microsoft FabricPartitioning is a key technique for managing and optimizing large datasets, but its implementation differs across data platforms. In this…A response icon1A response icon1
TIRSO ANDRADE·Sep 14Optimizing CLOB/LOB usage with Oracle and JavaStep-by-step guide: CLOB + LobHelper in Spring Boot 3.5
