Migration de sqlserver vers postgresql
Un bon guide à suivreHow to Convert SQL Server to PostgreSQL – Complete Migration Guide.PDF
https://dbconvert.com/blog/sql-server-to-postgresql-migration-guide/
Expertise en SGBDR
-
-
[SQL SERVER] Practical guidance to make your tier-1 SQL Server roar - BRK3155
Yes we are in 2025 but this is sill under review !
-
EDB feedback
Article intéressant sur le 0 downtime des cartes mastercard.
-
[Cloud IBM PSQL] Role creation with HVAULT (static dba)
script : prepare_dba_static_role.sh
-
[PSQL] Autovacuum PostgreSQL on AZURE
Comment configurer l'autovacuum de manière agressive afin qu'il soit plus performant sur postgresql flexible server dans Azure ?
-
[PSQL] Que contient les fichiers wal
Un bon tuto à faire !
What’s Inside a WAL File
-
[PSQL] 5 biggest tables
SELECT relname AS "relation", pg_size_pretty ( pg_total_relation_size (C .oid) ) AS "total_size" FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C .relnamespace) WHERE nspname NOT IN ( 'pg_catalog', 'information_schema' ) AND C .relkind <> 'i' AND nspname !~ '^pg_toast' ORDER BY pg_total_relation_size (C .oid) DESC LIMIT 5;
-
[ISSUE]PostgreSQL: Permission denied for large object
PostgreSQL: Permission denied for large object
-
Marchand de bien vers SCI
Prendre une carte de marchand de bien. Acheter le bien avev un credit in fine et le revendre a ma sci avant 5 ans pour ne pas payer de TVA.
-
[POSTGRES] Easy to migrate
Little bash script