Skip to content
Navigation menu
Search
Powered by
Search
Algolia
Log in
Create account
DEV Community
Close
#
dba
Follow
Hide
Posts
Left menu
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Common pitfalls and solutions for mysqldump/xtrabackup-based SSTs
Shiv Iyer
Shiv Iyer
Shiv Iyer
Follow
Feb 15
Common pitfalls and solutions for mysqldump/xtrabackup-based SSTs
#
mysql
#
galeracluster
#
dba
#
mysqltips
Comments
Add Comment
2 min read
Easier Upgrades and Image Management for Postgres in Kubernetes
Shiv Iyer
Shiv Iyer
Shiv Iyer
Follow
Feb 12
Easier Upgrades and Image Management for Postgres in Kubernetes
#
postgressql
#
dba
#
kubernetes
#
sql
Comments
Add Comment
3 min read
How to generate realistic test data in MySQL for QA environments
Gigantics
Gigantics
Gigantics
Follow
Feb 4
How to generate realistic test data in MySQL for QA environments
#
mysql
#
dba
#
devops
#
testing
1
 reaction
Comments
Add Comment
3 min read
What are the performance matrices used in MongoDB Query Performance Troubleshooting?
Shiv Iyer
Shiv Iyer
Shiv Iyer
Follow
Jan 24
What are the performance matrices used in MongoDB Query Performance Troubleshooting?
#
mongodb
#
nosql
#
dba
Comments
Add Comment
3 min read
How can I use the MongoDB explain plan to troubleshoot query performance
Shiv Iyer
Shiv Iyer
Shiv Iyer
Follow
Jan 24
How can I use the MongoDB explain plan to troubleshoot query performance
#
mongodb
#
nosql
#
dba
#
database
Comments
Add Comment
2 min read
How to implement an aggregation framework in MongoDB?
Shiv Iyer
Shiv Iyer
Shiv Iyer
Follow
Jan 24
How to implement an aggregation framework in MongoDB?
#
mongodb
#
nosql
#
dba
#
devops
Comments
Add Comment
3 min read
Choice of Table Column Types and Order When Migrating to PostgreSQL
Shiv Iyer
Shiv Iyer
Shiv Iyer
Follow
Feb 11
Choice of Table Column Types and Order When Migrating to PostgreSQL
#
postgressql
#
dba
#
sql
#
opensource
2
 reactions
Comments
Add Comment
2 min read
Reading PostgreSQL Query Plans Brought to a New Level
Saby_Explain
Saby_Explain
Saby_Explain
Follow
Dec 17 '24
Reading PostgreSQL Query Plans Brought to a New Level
#
postgres
#
postgressql
#
queryplan
#
dba
Comments
Add Comment
5 min read
How I Went From Being a DBA to DevOps Engineer
jmbharathram
jmbharathram
jmbharathram
Follow
Nov 8 '24
How I Went From Being a DBA to DevOps Engineer
#
devops
#
database
#
dba
Comments
Add Comment
1 min read
Remedy for Poor-Performing SQL Queries
Saby_Explain
Saby_Explain
Saby_Explain
Follow
Oct 22 '24
Remedy for Poor-Performing SQL Queries
#
postgres
#
postgressql
#
dba
#
explain
Comments
Add Comment
8 min read
Switching from DBA to DevOps career? 3 Mental Jujitsu moves to calm your survival brain
jmbharathram
jmbharathram
jmbharathram
Follow
Oct 9 '24
Switching from DBA to DevOps career? 3 Mental Jujitsu moves to calm your survival brain
#
dba
#
devops
#
careerdevelopment
1
 reaction
Comments
Add Comment
5 min read
Schrödinger’s Backups: A Lesson in Uncertainty
mayur
mayur
mayur
Follow
Oct 17 '24
Schrödinger’s Backups: A Lesson in Uncertainty
#
database
#
postgressql
#
postgres
#
dba
1
 reaction
Comments
Add Comment
5 min read
Type of Databases
akhil mittal
akhil mittal
akhil mittal
Follow
Sep 26 '24
Type of Databases
#
dba
#
systemdesign
#
performance
#
learning
1
 reaction
Comments
Add Comment
2 min read
Concept of Backup and Recovery
Duc Dang
Duc Dang
Duc Dang
Follow
Aug 20 '24
Concept of Backup and Recovery
#
database
#
sqlserver
#
dba
#
databaseadministrator
Comments
Add Comment
2 min read
Fundamentals of Transact-SQL (T-SQL) Queries
Duc Dang
Duc Dang
Duc Dang
Follow
Aug 18 '24
Fundamentals of Transact-SQL (T-SQL) Queries
#
database
#
sql
#
dba
#
administrator
Comments
Add Comment
2 min read
Essential Database Concepts Explained
Duc Dang
Duc Dang
Duc Dang
Follow
Aug 17 '24
Essential Database Concepts Explained
#
database
#
dba
#
sql
#
administrator
Comments
Add Comment
2 min read
Advanced Transact-SQL (T-SQL) Queries
Duc Dang
Duc Dang
Duc Dang
Follow
Aug 21 '24
Advanced Transact-SQL (T-SQL) Queries
#
database
#
sqlserver
#
dba
#
databaseadministrator
2
 reactions
Comments
Add Comment
3 min read
Understanding Data Normalization and Database Design Principles
Duc Dang
Duc Dang
Duc Dang
Follow
Aug 19 '24
Understanding Data Normalization and Database Design Principles
#
database
#
dba
#
sql
#
databaseadministrator
1
 reaction
Comments
Add Comment
2 min read
Understanding the Role of a SQL Server Database Administrator
Duc Dang
Duc Dang
Duc Dang
Follow
Aug 2 '24
Understanding the Role of a SQL Server Database Administrator
#
database
#
databaseadministrator
#
sql
#
dba
4
 reactions
Comments
2
 comments
2 min read
How does Wave Analytics handle data from external databases in PostgreSQL?
Shiv Iyer
Shiv Iyer
Shiv Iyer
Follow
May 6 '24
How does Wave Analytics handle data from external databases in PostgreSQL?
#
postgres
#
sql
#
dba
Comments
Add Comment
3 min read
Optimizing ClickHouse Performance: Strategies for Identifying and Reducing Over-fetching in SELECT Queries
Shiv Iyer
Shiv Iyer
Shiv Iyer
Follow
Apr 29 '24
Optimizing ClickHouse Performance: Strategies for Identifying and Reducing Over-fetching in SELECT Queries
#
clickhouse
#
sql
#
dba
#
olap
2
 reactions
Comments
Add Comment
3 min read
Optimizing ClickHouse Performance: Strategies for Identifying and Reducing Over-fetching in SELECT Queries
Shiv Iyer
Shiv Iyer
Shiv Iyer
Follow
Apr 29 '24
Optimizing ClickHouse Performance: Strategies for Identifying and Reducing Over-fetching in SELECT Queries
#
clickhouse
#
sql
#
dba
#
olap
Comments
Add Comment
3 min read
Tips and Tricks for Troubleshooting ClickHouse Wait Events
Shiv Iyer
Shiv Iyer
Shiv Iyer
Follow
Apr 28 '24
Tips and Tricks for Troubleshooting ClickHouse Wait Events
#
clickhouse
#
sql
#
sqltips
#
dba
1
 reaction
Comments
Add Comment
2 min read
Configuring Statement Timeout in PostgreSQL for Optimal Performance Management
Shiv Iyer
Shiv Iyer
Shiv Iyer
Follow
Apr 28 '24
Configuring Statement Timeout in PostgreSQL for Optimal Performance Management
#
postgres
#
sql
#
dbatips
#
dba
21
 reactions
Comments
Add Comment
2 min read
Optimizing PostgreSQL Performance: Navigating the Use of Bind Variables in Version 16
Shiv Iyer
Shiv Iyer
Shiv Iyer
Follow
Apr 21 '24
Optimizing PostgreSQL Performance: Navigating the Use of Bind Variables in Version 16
#
postgres
#
sql
#
dba
#
mysql
3
 reactions
Comments
Add Comment
3 min read
loading...
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account