OPS
Betriebs-Schreibtisch
Der gemeinsame Schreibtisch: Störungen, Konfiguration, Verbindung zwischen Teams. Für die, die zwischen Titeln sitzen.
1–24 / 1864
SQL Formatter / Beautifier
AktivFormat SQL with indentation and consistent keyword casing in the browser.
Werkzeug öffnenDev/Test Shutdown Schedule Savings Calculator
AktivEstimate savings from shutting down non-production resources outside business hours.
Werkzeug öffnenCloud Cost Estimator
AktivRough monthly estimate for compute, storage, and network using editable unit rates.
Werkzeug öffnenData Egress Cost Calculator
AktivEstimate data transfer (egress) costs across common cloud pricing bands.
Werkzeug öffnenSQL Query Explainer
AktivExplain what a SQL query does in plain English. The result stays on this page.
Werkzeug öffnenSQL JOIN Visualizer
AktivVisualize INNER/LEFT/RIGHT/FULL joins with sample data. The result stays on this page.
Werkzeug öffnenSQL Query Builder
AktivBuild SELECT queries from tables and columns visually. The result stays on this page.
Werkzeug öffnenWindow Function Builder
AktivBuild ROW_NUMBER, RANK, LAG/LEAD, running totals. The result stays on this page.
Werkzeug öffnenSQL Date Function Converter
AktivEquivalent date functions across databases. The result stays on this page.
Werkzeug öffnenFind Duplicates Query Generator
AktivGenerate queries to find/delete duplicate rows. The result stays on this page.
Werkzeug öffnenUpsert / MERGE Statement Generator
AktivGenerate INSERT ON CONFLICT / MERGE / ON DUPLICATE KEY. The result stays on this page.
Werkzeug öffnenIN List Generator
AktivTurn a column of values into a SQL IN list. The result stays on this page.
Werkzeug öffnenMySQL my.cnf Tuning Calculator
AktivSuggests buffer pool and key settings from RAM and workload. The result stays on this page.
Werkzeug öffnenPostgreSQL Config Tuner
AktivSuggests shared_buffers, work_mem etc. from hardware specs. The result stays on this page.
Werkzeug öffnenSQL Server Max Memory Calculator
AktivRecommends max server memory setting for SQL Server. The result stays on this page.
Werkzeug öffnenSQL Server MAXDOP Calculator
AktivRecommend MAXDOP and cost threshold for parallelism. The result stays on this page.
Werkzeug öffnenInnoDB Buffer Pool Calculator
AktivInnoDB Buffer Pool Calculator. Size innodb_buffer_pool and instances. The result stays on this page.
Werkzeug öffnenmysqldump / pg_dump Command Builder
AktivBuilds backup and restore commands with options. The result stays on this page.
Werkzeug öffnenDatabase Backup Strategy Planner
AktivPlan full/differential/log backups by RPO/RTO. The result stays on this page.
Werkzeug öffnenSQL Server Maintenance Plan Generator
AktivGenerate backup/maintenance jobs (Ola Hallengren style). The result stays on this page.
Werkzeug öffnenGRANT Statement Builder
AktivBuild GRANT/REVOKE statements per engine. The result stays on this page.
Werkzeug öffnenpg_hba.conf Generator
AktivGenerate PostgreSQL client authentication rules. The result stays on this page.
Werkzeug öffnenCSV to SQL INSERT Generator
AktivConverts CSV data into INSERT statements. The result stays on this page.
Werkzeug öffnenJSON to SQL INSERT Generator
AktivConvert JSON arrays into INSERT statements. The result stays on this page.
Werkzeug öffnenLeitfäden
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