Tag
#integrations
4 patterns, 4 snippets, 5 tools and 2 experiments.
- Experiment Rate Limiting Algorithms Compared: Token Bucket, Leaky Bucket and Sliding Window Four rate limiters enforce the same limit on the same traffic, side by side in 3D. See why fixed windows let bursts through, how the two buckets differ, and how retries make it worse.
- Experiment Retries, Backoff and Circuit Breakers, Visualised in Three.js An interactive Three.js simulation of an integration pipeline. Watch messages retry, back off, trip a circuit breaker and land in a needs-attention queue during an API outage.
- Snippet SQL Server: Convert Between XML and JSON Turn XML into JSON with nodes() and FOR JSON, and JSON into XML with OPENJSON and FOR XML PATH, keeping nested rows nested.
- Snippet SQL Server: Query Large XML Documents Without Timeouts Why shredding a big XML file with nodes() can take minutes, and the fixes that bring it back to seconds: no parent axis, full paths, text(), shredding once.
- Snippet SQL Server: Turn XML Into Rows with nodes() Shred an XML document into rows and typed columns with nodes() and value(), including child rows, attributes and namespaces.
- Tool XML to JSON Converter Convert XML to JSON and JSON back to XML, with attributes, repeated elements and namespaces handled the same way in both directions.
- Tool XML to nodes() Query Generator Paste a sample XML document and get a SQL Server nodes()/value() query, with column types inferred from the data and child rows shredded with CROSS APPLY.
- Pattern Designing Integration Jobs That Are Safe to Rerun How to make jobs produce the same result whether they run once, twice, or restart halfway through.
- Tool JSON to OPENJSON Generator Paste a sample JSON payload and get a SQL Server OPENJSON query with column types inferred from the data.
- Tool Retry Backoff Schedule Calculator See when each retry happens for an exponential backoff policy, and how long a call can take before it gives up.
- Pattern Retry, Back Off, Give Up: Handling Unreliable External APIs A system-level policy for which failures to retry, how long to keep trying, and what happens when retries run out.
- Pattern Stopping Duplicates at the Source Instead of Cleaning Them Up Where duplicate records come from, and how to design imports, constraints, and matching so they cannot be created.
- Tool Timestamp Converter for Integrations Convert between Unix timestamps, ISO 8601, .NET ticks, Microsoft JSON dates, HTTP dates, and SQL Server literals.
- Snippet TypeScript: Retry fetch with Exponential Backoff and Jitter A small typed fetch wrapper that retries timeouts, rate limits and server errors without hammering the API.
- Pattern Designing Integration Pipelines That Fail Safely A practical approach to building integration pipelines that prevent bad data from reaching downstream systems.