OPS
Secretária de operações
A secretária partilhada: incidentes, configuração e a cola entre equipas. Para quem se senta entre títulos.
1–24 / 1864
SQL Formatter / Beautifier
AtivoFormat SQL with indentation and consistent keyword casing in the browser.
Abrir ferramentaDev/Test Shutdown Schedule Savings Calculator
AtivoEstimate savings from shutting down non-production resources outside business hours.
Abrir ferramentaCloud Cost Estimator
AtivoRough monthly estimate for compute, storage, and network using editable unit rates.
Abrir ferramentaData Egress Cost Calculator
AtivoEstimate data transfer (egress) costs across common cloud pricing bands.
Abrir ferramentaSQL Query Explainer
AtivoExplain what a SQL query does in plain English. The result stays on this page.
Abrir ferramentaSQL JOIN Visualizer
AtivoVisualize INNER/LEFT/RIGHT/FULL joins with sample data. The result stays on this page.
Abrir ferramentaSQL Query Builder
AtivoBuild SELECT queries from tables and columns visually. The result stays on this page.
Abrir ferramentaWindow Function Builder
AtivoBuild ROW_NUMBER, RANK, LAG/LEAD, running totals. The result stays on this page.
Abrir ferramentaSQL Date Function Converter
AtivoEquivalent date functions across databases. The result stays on this page.
Abrir ferramentaFind Duplicates Query Generator
AtivoGenerate queries to find/delete duplicate rows. The result stays on this page.
Abrir ferramentaUpsert / MERGE Statement Generator
AtivoGenerate INSERT ON CONFLICT / MERGE / ON DUPLICATE KEY. The result stays on this page.
Abrir ferramentaIN List Generator
AtivoTurn a column of values into a SQL IN list. The result stays on this page.
Abrir ferramentaMySQL my.cnf Tuning Calculator
AtivoSuggests buffer pool and key settings from RAM and workload. The result stays on this page.
Abrir ferramentaPostgreSQL Config Tuner
AtivoSuggests shared_buffers, work_mem etc. from hardware specs. The result stays on this page.
Abrir ferramentaSQL Server Max Memory Calculator
AtivoRecommends max server memory setting for SQL Server. The result stays on this page.
Abrir ferramentaSQL Server MAXDOP Calculator
AtivoRecommend MAXDOP and cost threshold for parallelism. The result stays on this page.
Abrir ferramentaInnoDB Buffer Pool Calculator
AtivoInnoDB Buffer Pool Calculator. Size innodb_buffer_pool and instances. The result stays on this page.
Abrir ferramentamysqldump / pg_dump Command Builder
AtivoBuilds backup and restore commands with options. The result stays on this page.
Abrir ferramentaDatabase Backup Strategy Planner
AtivoPlan full/differential/log backups by RPO/RTO. The result stays on this page.
Abrir ferramentaSQL Server Maintenance Plan Generator
AtivoGenerate backup/maintenance jobs (Ola Hallengren style). The result stays on this page.
Abrir ferramentaGRANT Statement Builder
AtivoBuild GRANT/REVOKE statements per engine. The result stays on this page.
Abrir ferramentapg_hba.conf Generator
AtivoGenerate PostgreSQL client authentication rules. The result stays on this page.
Abrir ferramentaCSV to SQL INSERT Generator
AtivoConverts CSV data into INSERT statements. The result stays on this page.
Abrir ferramentaJSON to SQL INSERT Generator
AtivoConvert JSON arrays into INSERT statements. The result stays on this page.
Abrir ferramentaGuias
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