Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.

Sign up to join this community

Anybody can ask a question

Anybody can answer

The best answers are voted up and rise to the top

Explore our Questions

Ask Question

more tags

Active Hot Week Month

0

votes

0

answers

2

views

Payment for hours not worked.(Hint: compare hours in the transactions file to the time file,

ms-access

asked 1 min ago Abril Carmona 1

1

vote

1

answer

964

views

Is there a way to enforce uniqueness of arbitrary key-value pairs in a JSONB object column

postgresql

modified 31 mins ago Community♦ 1

0

votes

1

answer

14

views

Do Log Backups depend on Differential Backups?

sql-server backup transaction-log

answered 1 hour ago Kin Shah 59.5k

1

vote

2

answers

2k

views

Repair/Recover data from MySQL database

mysql innodb mariadb restore recovery

modified 1 hour ago Community♦ 1

0

votes

2

answers

383

views

Cascading REVOKE not working in MYSQL

mysql permissions security

answered 2 hours ago iwis 101

0

votes

0

answers

16

views

Roll up aggregate until column change

postgresql

modified 2 hours ago user1649248 1

3

votes

1

answer

2k

views

MongoDB crashes with out-of-memory or is being killed by oom-killer

mongodb sharding crash mongodb-3.6 google-cloud-platform

modified 2 hours ago Community♦ 1

0

votes

1

answer

484

views

Best way to create a daily snapshotted read-only db in RDS?

postgresql replication amazon-rds aws snapshot

modified 3 hours ago Community♦ 1

0

votes

0

answers

7

views

Local PostgreSQL database replication with (not always online) database

postgresql replication

asked 3 hours ago imaprogrammer 1

0

votes

1

answer

36

views

Does PostgreSQL handle case-insensitive database as good as others?

mysql postgresql performance database-design collation

modified 4 hours ago Hamid Mayeli 105

0

votes

1

answer

2k

views

phpMyAdmin trigger error

innodb trigger phpmyadmin syntax

modified 4 hours ago Community♦ 1

0

votes

1

answer

31

views

MySQL - GROUP BY with JOIN query

mysql join query mysql-8.0

modified 5 hours ago nbk 4,556

-1

votes

1

answer

24

views

Select all rows of all user logins, where user had logged in from more than 3 ip address within the past month

sql-server query

modified 5 hours ago Gary S 5

2

votes

1

answer

29

views

CHECK Constraint to enforce upper case letter and pattern match

sql-server database-design check-constraints

modified 5 hours ago Dan Guzman 20.1k

Browse more Questions

Database Administrators Stack Exchange works best with JavaScript enabled