#dba — Public Fediverse posts

REPLAY : en mai dernier, Pierrick intervenait aux #RPLL pour présenter CloudNativePG, l'opérateur Kubernetes pour PostgreSQL
=> https://dali.bo/202608_conf_rpll_cnpg

Merci au @plossra_a pour ce partage !

#PostgreSQL #sgbd #dba
#CNPG #CloudNativePG
#Kubernetes #K8S
#opensource
#conference

REPLAY : en mai dernier, Pierrick intervenait aux #RPLL pour présenter CloudNativePG, l'opérateur Kubernetes pour PostgreSQL
=> https://dali.bo/202608_conf_rpll_cnpg

Merci au @plossra_a pour ce partage !

#PostgreSQL #sgbd #dba
#CNPG #CloudNativePG
#Kubernetes #K8S
#opensource
#conference

Someone got tired of writing `CURRENT_TIMESTAMP - (random() * interval '365 days')` and filed a patch.

#Postgres 19: typed random() for date & timestamp types, plus pg_get_role_ddl(), pg_get_tablespace_ddl(), and pg_get_database_ddl(). DDL introspection without spelunking through system catalogs.

No theme. No marketing name. Just features that someone needed badly enough to write the code. That's the Cult of Functionality.

📖 https://www.pgedge.com/blog/looking-forward-to-postgres-19-the-cult-of-functionality

#PostgreSQL #OpenSource #DBA #Programming

Someone got tired of writing `CURRENT_TIMESTAMP - (random() * interval '365 days')` and filed a patch.

#Postgres 19: typed random() for date & timestamp types, plus pg_get_role_ddl(), pg_get_tablespace_ddl(), and pg_get_database_ddl(). DDL introspection without spelunking through system catalogs.

No theme. No marketing name. Just features that someone needed badly enough to write the code. That's the Cult of Functionality.

📖 https://www.pgedge.com/blog/looking-forward-to-postgres-19-the-cult-of-functionality

#PostgreSQL #OpenSource #DBA #Programming

Learn how to recover a MySQL database after "InnoDB registration as a STORAGE ENGINE failed" issue using native fixes and Stellar Repair for MySQL tool.

Full guide here: https://ostechnix.com/mysql-innodb-registration-storage-engine-failed-recovery/

#StellarRepairForMySQL #Mysql #MariaDB #Database #InnoDB #DatabaseRecovery #Linux #Windows #DBA

Learn how to recover a MySQL database after "InnoDB registration as a STORAGE ENGINE failed" issue using native fixes and Stellar Repair for MySQL tool.

Full guide here: https://ostechnix.com/mysql-innodb-registration-storage-engine-failed-recovery/

#StellarRepairForMySQL #Mysql #MariaDB #Database #InnoDB #DatabaseRecovery #Linux #Windows #DBA

Что мы находим при аудите PostgreSQL: 10 распространенных ошибок

Когда приходишь на аудит СУБД к разным компаниям, картина удивительно похожа: одни и те же проблемы, одни и те же причины. Меня зовут Андрей, я DBA в группе поддержки системного ПО Центра экспертизы по комплексному сервису К2Тех, сертифицированный эксперт Postgres Pro. В этой статье представлен ТОП-10 ошибок, с которыми мы встречаемся чаще всего. Я разберу, чем они опасны, почему возникают, и как их можно решить. Скорее всего, многие пункты покажутся вам до боли знакомыми:

https://habr.com/ru/companies/k2tech/articles/1064474/

#postgresql #postgresql_scaling #dba #администрирование_баз_данных #субд #резервное_копирование #логирование_postgresql #информационная_безопасность #мониторинг_postgresql #производительность

Sometimes the best way to learn how something works is to break it.

This week, Coroot CEO Nikolay Sivko tried to take down CloudNativePG replication. Turns out, it’s remarkably resilient: https://coroot.com/blog/fencing-a-cnpg-replica/

Even when the network was severed between a #Postgres replica and its primary, the replica continued to pull from a second WAL source: the S3 backup archive.

#dba #devops #observability #monitoring #cloud #tech #ai #kubernetes #docker #opensource #database #cloudnativepg

Sometimes the best way to learn how something works is to break it.

This week, Coroot CEO Nikolay Sivko tried to take down CloudNativePG replication. Turns out, it’s remarkably resilient: https://coroot.com/blog/fencing-a-cnpg-replica/

Even when the network was severed between a #Postgres replica and its primary, the replica continued to pull from a second WAL source: the S3 backup archive.

#dba #devops #observability #monitoring #cloud #tech #ai #kubernetes #docker #opensource #database #cloudnativepg

A database monitoring graph says replication lag is climbing. It doesn't say whether WAL isn't reaching the replica or is sitting there unapplied.

We built something different. Actionable diagnoses, not detective work at 2AM: https://docs.coroot.com/inspections/postgres/

Goodbye SSHing in to run df. Get it self-hosted and Apache 2.0 open source:https://github.com/coroot/coroot

#postgres #dba #devops #observability #monitoring #cloud #tech #ai #kubernetes #docker #opensource #database #percona #cloudnativepg

A database monitoring graph says replication lag is climbing. It doesn't say whether WAL isn't reaching the replica or is sitting there unapplied.

We built something different. Actionable diagnoses, not detective work at 2AM: https://docs.coroot.com/inspections/postgres/

Goodbye SSHing in to run df. Get it self-hosted and Apache 2.0 open source:https://github.com/coroot/coroot

#postgres #dba #devops #observability #monitoring #cloud #tech #ai #kubernetes #docker #opensource #database #percona #cloudnativepg

This evening I get to take off my DBA hat and do some ETL work. I enjoy doing that every now and then.

#SQLServer
#DBA

This evening I get to take off my DBA hat and do some ETL work. I enjoy doing that every now and then.

#SQLServer
#DBA

Coroot now detects when a Postgres Autovacuum incident takes place, then shows the specific cause for failure and exactly how to fix it.

So naturally we broke #Postgres on purpose: five times. https://coroot.com/blog/lets-break-autovacuum-in-postgres/

#dba #devops #observability #tech #ai #kubernetes #docker #opensource

Coroot now detects when a Postgres Autovacuum incident takes place, then shows the specific cause for failure and exactly how to fix it.

So naturally we broke #Postgres on purpose: five times. https://coroot.com/blog/lets-break-autovacuum-in-postgres/

#dba #devops #observability #tech #ai #kubernetes #docker #opensource

pgEdge is a Gold Sponsor at @pgconfeu (October 20-23, Valencia, Spain) & three of our team are presenting:

🔎 Andrei Lepikhov on pg_track_optimizer - planner estimation errors #PostgreSQL misses.
🛠️ Jimmy Angelakos on radar + radar-ui - agentless, zero-dependency diagnostic snapshots. No agent, no daemon.
🧯 Ibrar Ahmed on eight steps to disaster recovery - standard Postgres tooling only.

Full session list: 🎙️ https://www.postgresql.eu/events/pgconfeu2026/sessions/

#pgconfeu2026 #DBA #OpenSource #Database #postgresql #postgres

pgEdge is a Gold Sponsor at @pgconfeu (October 20-23, Valencia, Spain) & three of our team are presenting:

🔎 Andrei Lepikhov on pg_track_optimizer - planner estimation errors #PostgreSQL misses.
🛠️ Jimmy Angelakos on radar + radar-ui - agentless, zero-dependency diagnostic snapshots. No agent, no daemon.
🧯 Ibrar Ahmed on eight steps to disaster recovery - standard Postgres tooling only.

Full session list: 🎙️ https://www.postgresql.eu/events/pgconfeu2026/sessions/

#pgconfeu2026 #DBA #OpenSource #Database #postgresql #postgres

"Too many tables" is a real failure mode, not a style opinion.

Laurenz Albe traces a customer's OOM kills and failed autovacuum forks to tens of thousands of tables: each long-lived connection's catcache/relcache grows as it touches them. 20,000 tables reached 221 MB per backend in his test.

https://www.cybertec-postgresql.com/en/too-many-tables-are-bad/

https://pgexperts.com

#PostgreSQL #DBA #Performance

"Too many tables" is a real failure mode, not a style opinion.

Laurenz Albe traces a customer's OOM kills and failed autovacuum forks to tens of thousands of tables: each long-lived connection's catcache/relcache grows as it touches them. 20,000 tables reached 221 MB per backend in his test.

https://www.cybertec-postgresql.com/en/too-many-tables-are-bad/

https://pgexperts.com

#PostgreSQL #DBA #Performance

Yeah, about that...

We're migrating to SQL Server 2025 soon (hopefully). There's a new feature I call the "Goodfellas" feature.

https://learn.microsoft.com/en-us/sql/relational-databases/performance/query-store-hints-best-practices?view=sql-server-ver17#block-future-execution-of-problematic-queries

#DBA
#SQLServer

Yeah, about that...

We're migrating to SQL Server 2025 soon (hopefully). There's a new feature I call the "Goodfellas" feature.

https://learn.microsoft.com/en-us/sql/relational-databases/performance/query-store-hints-best-practices?view=sql-server-ver17#block-future-execution-of-problematic-queries

#DBA
#SQLServer

Imagine you've worked with stoves for decades. You are the closest thing your organization has to a "stove expert". There are very few others in the org that have much stove experience.

Your job is to try to convince coworkers not to touch a hot stove. You frequently explain to them the pros & cons of touching a hot stove. You constantly show them the ramifications of touching a hot stove.

But certain folks insist on touching a hot stove anyway.

This is what it's like to be a #DBA.

Imagine you've worked with stoves for decades. You are the closest thing your organization has to a "stove expert". There are very few others in the org that have much stove experience.

Your job is to try to convince coworkers not to touch a hot stove. You frequently explain to them the pros & cons of touching a hot stove. You constantly show them the ramifications of touching a hot stove.

But certain folks insist on touching a hot stove anyway.

This is what it's like to be a #DBA.

One bad Cartesian join just crashed your production Oracle instance. Here's how to spot the query that's eating your entire TEMP tablespace before your SAN melts. #Oracle #Database #DBA

https://www.valtersit.com/guides/databases/oracle-db_when_bad_queries_explode_your_temp_tablespace/

Learn how to use #vscode effectively with your #sqlserver DBs with Carlos Robles at #techbash 2026.

Register by July 31st and save with code SUMMERSALE. Check out the schedule at https://techbash.com/schedule

#devconference #developers #dba #database #devcommunity

Learn how to use #vscode effectively with your #sqlserver DBs with Carlos Robles at #techbash 2026.

Register by July 31st and save with code SUMMERSALE. Check out the schedule at https://techbash.com/schedule

#devconference #developers #dba #database #devcommunity

Last day to register to Brent Ozar's 2026 Live Online Classes with a 50% discount.
And you can stack an extra 10% off on top of that.
Find out how to claim the exra discount: https://vladdba.com/2026/06/23/extra-10-off-brent-ozars-live-classes/
#SQLServer #DBA #BrentOzar #DatabasePerformance #TechTraining #sql #performance #mssql #sqldba

TECH : la performance des requêtes, c'est le dada d'Alain ! Pour vous aider à les améliorer, il en vous propose de découvrir le paramètre default_statistics_target => https://blog.dalibo.com/2026/07/10/statistics-target.html

#PostgreSQL #SQL
#SGBD #DBA
#opensource

TECH : la performance des requêtes, c'est le dada d'Alain ! Pour vous aider à les améliorer, il en vous propose de découvrir le paramètre default_statistics_target => https://blog.dalibo.com/2026/07/10/statistics-target.html

#PostgreSQL #SQL
#SGBD #DBA
#opensource

In aktuellen Minor-Releases von PostgreSQL 14, 15 und 16 kann unter bestimmten Voraussetzungen ein Replikations-Deadlock auftreten.

In unserem Blog erfahrt ihr, welche Systeme betroffen sind, welche Auswirkungen das Problem hat und welche Workarounds derzeit empfohlen werden.

👉 Jetzt mehr erfahren:
https://www.credativ.de/blog/postgresql/replikations-deadlock-fehler-in-aktuellen-postgres-versionen-14-16/?p=22839

#PostgreSQL #OpenSource #DBA #Replication #ITInfrastructure #credativ #PostgreSQL

In aktuellen Minor-Releases von PostgreSQL 14, 15 und 16 kann unter bestimmten Voraussetzungen ein Replikations-Deadlock auftreten.

In unserem Blog erfahrt ihr, welche Systeme betroffen sind, welche Auswirkungen das Problem hat und welche Workarounds derzeit empfohlen werden.

👉 Jetzt mehr erfahren:
https://www.credativ.de/blog/postgresql/replikations-deadlock-fehler-in-aktuellen-postgres-versionen-14-16/?p=22839

#PostgreSQL #OpenSource #DBA #Replication #ITInfrastructure #credativ #PostgreSQL

Blog alert!

This time on some experimenting with the JSON data type and index inside SQL Server.

#SQLServer
#AzureSql
#DBA

http://sqlreitse.com/2026/07/08/sql-server-2025-testing-the-json-index/

Blog alert!

This time on some experimenting with the JSON data type and index inside SQL Server.

#SQLServer
#AzureSql
#DBA

http://sqlreitse.com/2026/07/08/sql-server-2025-testing-the-json-index/

We're hiring a "Senior Architect, Data Warehouse & Database Administrator" at #WhiteheadInstitute in Cambridge, MA! If you thrive on designing data warehouse architecture and managing Oracle databases that power biomedical discoveries, this is your moment. Apply now!
#ITJobs #Hiring #Database #DBA

Senior Architect, Data Warehou...

🇨🇭 Zwei Tage voller PostgreSQL, Open Source und spannender Gespräche!

Wir waren beim Swiss PGDay 2026 in Rapperswil dabei – als Sponsor, mit eigenem Stand und einem Vortrag aus unserem Team.

👉 In unserem Rückblick teilen wir unsere Eindrücke vom Event:
https://www.credativ.de/blog/events/unser-besuch-beim-swiss-pgday-2026/

#SwissPGDay #PostgreSQL #OpenSource #Community #Database #DBA #TechEvents #credativ

#PRAKASH #KUMAR #PALLATHADKA
headlines-world.com?lang=en&q=PR...
#RACHEL #AVIV
headlines-world.com?lang=en&q=RA...
#AFTON #STATE #PARK
allgraph.ro/search.html?...
#DBA #AIRLINE
aepiot.ro/advanced-sea...
headlines-world.com

MultiSearch Tag Explorer

8 days left to take advantage of Brent Ozar's 2026 Live Online Classes 50% discount (ends July 10).
And you can stack an extra 10% off on top of that.
Find out how to claim the exra discount: https://vladdba.com/2026/06/23/extra-10-off-brent-ozars-live-classes/
#SQLServer #DBA #BrentOzar #mssql #mssqlserver #sql #DatabasePerformance #TechTraining

Today I'll be installing SQL Server 2008 R2 on a Windows Server 2012 virtual machine...all because we have a customer/vendor with a database backup from SQL 2000 that we need.

I wish I was kidding. 🤦‍♂️

#SQLServer
#DBA

Today I'll be installing SQL Server 2008 R2 on a Windows Server 2012 virtual machine...all because we have a customer/vendor with a database backup from SQL 2000 that we need.

I wish I was kidding. 🤦‍♂️

#SQLServer
#DBA

Ahsan Hadi's spent 20 years watching the same #Postgres problems hit at the worst time. He built pg-healthcheck for it: 180+ live checks against system catalog views.

The ask subcommand is the interesting part. Write naturally, it'll pick the right checks & run them. "How safe are we from TXID wraparound?" Ollama by default, no API key, air-gapped. Open source, #PostgreSQL License.

GitHub 🔗 https://hubs.la/Q04nfztl0

Full writeup 📖 https://hubs.la/Q04nd1rN0

#OpenSource #DBA #DevOps #Monitoring

Ahsan Hadi's spent 20 years watching the same #Postgres problems hit at the worst time. He built pg-healthcheck for it: 180+ live checks against system catalog views.

The ask subcommand is the interesting part. Write naturally, it'll pick the right checks & run them. "How safe are we from TXID wraparound?" Ollama by default, no API key, air-gapped. Open source, #PostgreSQL License.

GitHub 🔗 https://hubs.la/Q04nfztl0

Full writeup 📖 https://hubs.la/Q04nd1rN0

#OpenSource #DBA #DevOps #Monitoring

"Developers want to add a new column every day. VARCHARs"

"The integrity of our data is very important, not to me personally (I couldn't care less), but for our company to survive."

This clip got a good chuckle out of me 😅

#sql #mssql #sqlserver #dba
https://www.youtube.com/watch?v=5KyfW79Ld4g

“When MySQL has a good day, I wait for Ops to fix the monitoring.” 😆
https://www.youtube.com/watch?v=5KyfW79Ld4g #DBA #Database

“When MySQL has a good day, I wait for Ops to fix the monitoring.” 😆
https://www.youtube.com/watch?v=5KyfW79Ld4g #DBA #Database

I will just leave this here for my amusement.
https://youtu.be/5KyfW79Ld4g

#DataBase #DBA #Technology

I will just leave this here for my amusement.
https://youtu.be/5KyfW79Ld4g

#DataBase #DBA #Technology

It's the #DBA's turn to get a Kai Lentit video. And it is *full* of gold.

https://youtu.be/5KyfW79Ld4g

It's the #DBA's turn to get a Kai Lentit video. And it is *full* of gold.

https://youtu.be/5KyfW79Ld4g

PostgreSQL 19's beta ships "grease mode." The client deliberately sends optional protocol parameters that a correct server must acknowledge and decline, and it aborts the connection if your server, pooler, or proxy mishandles them.

It is beta-only and reverts before GA. The beta is the one window where these bugs surface, so point a real client stack at Beta 1, not just psql.

https://wiki.postgresql.org/wiki/Grease

https://pgexperts.com

#PostgreSQL #Postgres #DBA

PostgreSQL 19's beta ships "grease mode." The client deliberately sends optional protocol parameters that a correct server must acknowledge and decline, and it aborts the connection if your server, pooler, or proxy mishandles them.

It is beta-only and reverts before GA. The beta is the one window where these bugs surface, so point a real client stack at Beta 1, not just psql.

https://wiki.postgresql.org/wiki/Grease

https://pgexperts.com

#PostgreSQL #Postgres #DBA

#SQLJobCommander (SJC) has been approved for the #Microsoft store here:

https://apps.microsoft.com/detail/9n2vfrz1c29m?hl=en-US&gl=CA

SJC is a SQL Server® Agent job management tool that delivers familiar SSMS functionality while adding unique capabilities for enhanced job manipulation and control.

This availability makes me happy as a single hobbyist developer, since I could not justify spending hundreds of $$ on a yearly code signing certificate. Being in the store, Microsoft signs the application so that Smart App Control is not triggered or requiring it to be disabled on a client system.

Boosts welcome and appreciated.

I already have plans for the next version.

#sqlserver #database #DBA

#SQLJobCommander (SJC) has been approved for the #Microsoft store here:

https://apps.microsoft.com/detail/9n2vfrz1c29m?hl=en-US&gl=CA

SJC is a SQL Server® Agent job management tool that delivers familiar SSMS functionality while adding unique capabilities for enhanced job manipulation and control.

This availability makes me happy as a single hobbyist developer, since I could not justify spending hundreds of $$ on a yearly code signing certificate. Being in the store, Microsoft signs the application so that Smart App Control is not triggered or requiring it to be disabled on a client system.

Boosts welcome and appreciated.

I already have plans for the next version.

#sqlserver #database #DBA

RELEASE : voici un nouvel outil basé sur #pgBackRest, pour sauvegarder les instances #PostgreSQL déployés avec #CloudNativePG !

Deux de ses développeurs vous en parlent => https://blog.dalibo.com/2026/06/25/plugin-pgbackrest.html

🇬🇧 => *Here is the announcement of our experimental CloudNativePG plugin to backup PostgreSQL instances with pgBackRest!*

#SGBD #CNPG #DBA
#kubernetes
#opensource

NEW POST:
✍ Fast in SSMS, Slow in the App

🔎 Your SQL Server query is fast when you run it in SSMS. It's slow in your application. But why?

👤 Dave Mason

https://www.davemason.me/2026/06/28/fast-in-ssms-slow-in-the-app

#SQLServer
#DBA
#SQL
#Database
#TSQL

NEW POST:
✍ Fast in SSMS, Slow in the App

🔎 Your SQL Server query is fast when you run it in SSMS. It's slow in your application. But why?

👤 Dave Mason

https://www.davemason.me/2026/06/28/fast-in-ssms-slow-in-the-app

#SQLServer
#DBA
#SQL
#Database
#TSQL

Today was one of those days that made me consider looking for a new job. 🙁

I hope your day was better than mine.

#SQLServer
#DBA