OPS
Operationsbureau
Het gedeelde bureau: incidenten, configuratie en lijm tussen teams. Voor wie tussen titels zit.
1–24 / 1864
SQL Formatter / Beautifier
ActiefFormat SQL with indentation and consistent keyword casing in the browser.
Tool openenDev/Test Shutdown Schedule Savings Calculator
ActiefEstimate savings from shutting down non-production resources outside business hours.
Tool openenCloud Cost Estimator
ActiefRough monthly estimate for compute, storage, and network using editable unit rates.
Tool openenData Egress Cost Calculator
ActiefEstimate data transfer (egress) costs across common cloud pricing bands.
Tool openenSQL Query Explainer
ActiefExplain what a SQL query does in plain English. The result stays on this page.
Tool openenSQL JOIN Visualizer
ActiefVisualize INNER/LEFT/RIGHT/FULL joins with sample data. The result stays on this page.
Tool openenSQL Query Builder
ActiefBuild SELECT queries from tables and columns visually. The result stays on this page.
Tool openenWindow Function Builder
ActiefBuild ROW_NUMBER, RANK, LAG/LEAD, running totals. The result stays on this page.
Tool openenSQL Date Function Converter
ActiefEquivalent date functions across databases. The result stays on this page.
Tool openenFind Duplicates Query Generator
ActiefGenerate queries to find/delete duplicate rows. The result stays on this page.
Tool openenUpsert / MERGE Statement Generator
ActiefGenerate INSERT ON CONFLICT / MERGE / ON DUPLICATE KEY. The result stays on this page.
Tool openenIN List Generator
ActiefTurn a column of values into a SQL IN list. The result stays on this page.
Tool openenMySQL my.cnf Tuning Calculator
ActiefSuggests buffer pool and key settings from RAM and workload. The result stays on this page.
Tool openenPostgreSQL Config Tuner
ActiefSuggests shared_buffers, work_mem etc. from hardware specs. The result stays on this page.
Tool openenSQL Server Max Memory Calculator
ActiefRecommends max server memory setting for SQL Server. The result stays on this page.
Tool openenSQL Server MAXDOP Calculator
ActiefRecommend MAXDOP and cost threshold for parallelism. The result stays on this page.
Tool openenInnoDB Buffer Pool Calculator
ActiefInnoDB Buffer Pool Calculator. Size innodb_buffer_pool and instances. The result stays on this page.
Tool openenmysqldump / pg_dump Command Builder
ActiefBuilds backup and restore commands with options. The result stays on this page.
Tool openenDatabase Backup Strategy Planner
ActiefPlan full/differential/log backups by RPO/RTO. The result stays on this page.
Tool openenSQL Server Maintenance Plan Generator
ActiefGenerate backup/maintenance jobs (Ola Hallengren style). The result stays on this page.
Tool openenGRANT Statement Builder
ActiefBuild GRANT/REVOKE statements per engine. The result stays on this page.
Tool openenpg_hba.conf Generator
ActiefGenerate PostgreSQL client authentication rules. The result stays on this page.
Tool openenCSV to SQL INSERT Generator
ActiefConverts CSV data into INSERT statements. The result stays on this page.
Tool openenJSON to SQL INSERT Generator
ActiefConvert JSON arrays into INSERT statements. The result stays on this page.
Tool openenGidsen
Pillar guides for this desk. Published supporting pages are linked from the pillar they belong to.
SQL Query Tools
Schema Design & Modeling
Performance & Indexing
Configuration & Tuning
Backup & Recovery
Replication & High Availability
Database Security & Access
Data Import, Export & Conversion
Connections & Client Tools
Capacity, Sizing & Licensing
Monitoring & Diagnostics
Migration & Upgrades
NoSQL & Specialized Databases
Developer & ORM Utilities
AI, Vector & Analytics Databases
SQL Learning & Reference
Career & Certification
Database Engine Guides
- MySQL Administration Guide
- PostgreSQL Administration Guide
- SQL Server Administration Guide
- Oracle Database Administration Guide
- MariaDB Administration Guide
- IBM Db2 Administration Guide
- CockroachDB Administration Guide
- SQLite Administration Guide
- DuckDB Administration Guide
- ClickHouse Administration Guide
- MongoDB Administration Guide
- Redis Administration Guide
- Cassandra Administration Guide
- Elasticsearch Administration Guide
- Neo4j Administration Guide