Skip to content

Instantly share code, notes, and snippets.

View diegoeche's full-sized avatar

Diego Echeverri diegoeche

45 followers · 19 following
View GitHub Profile
@diegoeche
diegoeche / mssql-index-bloat-analysis.md
Created March 13, 2026 17:09
MSSQL Prod Index Bloat Analysis (2026-03-13)

MSSQL Index Bloat Analysis — Prod (2026-03-13)

Queries Used

1. Space bloat (via sys.allocation_units)

SELECT TOP 30
  OBJECT_NAME(p.object_id) AS TableName,
 i.name AS IndexName,
@diegoeche
diegoeche / widget-cache-summary.md
Last active March 10, 2026 22:26
Widget Cache Layer — Varnish + NVMe design

Widget Cache Layer — Design & Progress

Goal: Cache widget API responses (reviews, badges) with Varnish on NVMe SSD to reduce latency and backend load.

Architecture:

                    ┌───────────────────────────────────────────────┐
                    │      widget-cache node (m6id.2xlarge)         │
@diegoeche
diegoeche / 2026-03-09-sql-server-incident-battle-report.md
Created March 9, 2026 22:36

Battle Report: SQL Server Meltdown & Recovery — March 9, 2026

The Scene

Sunday morning. Merchants can't load review widgets. Dashboard inaccessible. Churn reported. The legacy .NET monolith (app-backend-api) running on a self-managed SQL Server (r6a.16xlarge — 64 vCPUs, 512 GB RAM) was completely unresponsive.

What followed was a 12-hour debugging marathon that uncovered five cascading failures, a year-old regression, and a SQL Server death spiral that required a force-kill to resolve.

@diegoeche
diegoeche / k8s-mvp-environments.md
Created February 4, 2026 20:54
k8s-mvp environment structure and GitOps flow

k8s-mvp Environment Structure

How the k8s-mvp repository environments are structured using Kustomize overlays and GitOps.

Directory Layout

clusters/platform/
├── base/                          # Shared service definitions
│   ├── app-backend-api/
@diegoeche
diegoeche / *shell*.txt
Created October 11, 2018 10:54
Models::Audience.first
=> #<FormsHub::Models::Audience @values={:id=>"ccdd57f2-d24f-4ff7-9356-b41f82756c94", :iid=>17, :account_id=>"0166cbcb-7827-4698-a267-fec98676db0b", :type=>"company", :name=>"Paid companies", :description=>nil, :facebook_account_id=>"act_10150428762524283", :facebook_audience_id=>"6103550209001", :company_segment_id=>"c6eddfbe-23ff-4287-b31c-9d3291c89da3", :person_segment_id=>nil, :company_exclusion_segment_id=>nil, :person_exclusion_segment_id=>nil, :role=>nil, :seniority=>nil, :search=>nil, :path=>nil, :status=>"active", :created_at=>2018-04-04 02:05:48 UTC, :updated_at=>2018-10-11 10:42:55 UTC, :last_sync_at=>nil, :archived_at=>nil}>
@diegoeche
diegoeche / worker.js
Created October 25, 2017 15:22
const axios = require('axios')
const sleep = require('sleep')
const base64 = require('base-64')
const appId = process.env["GEENY_APPLICATION_ID"]
const host = process.env["GEENY_APPLICATION_BROKER_URL"]
const brokerConfig = {
appId: appId,
messageTypeId: '54121087-14f1-4c2a-835f-117681618cc9', // incoming Develco messageType
@diegoeche
diegoeche / tmp.txt
Created October 25, 2017 15:19
const axios = require('axios')
const sleep = require('sleep')
const base64 = require('base-64')
const appId = process.env["GEENY_APPLICATION_ID"]
const host = process.env["GEENY_APPLICATION_BROKER_URL"]
const brokerConfig = {
appId: appId,
messageTypeId: '54121087-14f1-4c2a-835f-117681618cc9', // incoming Develco messageType
@diegoeche
diegoeche / game.cpp
Created January 26, 2017 14:27
static bool STATS = false;
static const int FRAME_PLOT_SIZE = 50;
static float frameTimes[FRAME_PLOT_SIZE];
void renderUIElements(float elapsed) {
if (STATS) {
std::ostringstream os;
os << "T: " << elapsed;
std::string str = os.str();
char * cstr = new char [str.length()+1];
@diegoeche
diegoeche / test.rb
Created October 28, 2016 15:04
require "digest/md5"
require "openssl"
require "securerandom"
require 'benchmark'
require "base64"
SIZE = 1000
def create_test
ret = []
SIZE.times do
@diegoeche
diegoeche / tmp.txt
Created March 3, 2015 14:26
-- Before caching RoF fitness
-- 00:00:00.1983681
RoF Fitness: 00:00:00.0025516
Fitness total: 00:00:00.0055062
Actions: 00:00:00.0664216
Playing total: 00:00:00.0255507
-- After caching RoF fitness
-- 00:00:00.2025582