Database Administrators

Promoter

 Promoter
First bounty you offer on your own question.
Awarded 813 times.
MYSQL workbench like gui tool for oracle 10 g or more
Awarded Sep 21 at 0:28
Slow query in a created view. How can I fix it?
Awarded Sep 15 at 8:55
Different Percona XtraDB nodes use different indexes for the same query
Awarded Sep 4 at 7:07
View with which role a PostgreSQL setting was changed
Awarded Aug 24 at 23:56
How to design a database that needs to merge similar data from different sources?
Awarded Aug 21 at 2:43
postgresql - recovery_target_action not working with recovery_target_time
Awarded Aug 20 at 23:51
How are blind writes recoverable in a transaction schedule?
Awarded Aug 13 at 17:26
SQLite Upsert - syntax error
Awarded Jul 22 at 0:28
Is there a benefit to using a surrogate key for a many-to-many table?
Awarded Jul 16 at 12:48
(post deleted or otherwise unavailable)
Awarded Jul 6 at 21:50
Identifying the reason of the CPU pressure
Awarded Jun 23 at 19:20
MSSQL Server 2022 on Linux: sys.* tables very slow for non-db_owner users
Awarded May 31 at 6:26
Handling server upgrades through packaging system (apt) when running group replication
Awarded May 24 at 12:10
How is the current sequence number in the control file used during recovery?
Awarded May 11 at 21:08
Interaction between ReadConcern and ReadPreference in mongodb
Awarded May 7 at 23:46
Resultset from jsonb array
Awarded May 1 at 17:48
MySQLTuner vs cPanel SQL recommendations are different / contradictory
Awarded Mar 26 at 8:57
Converting from latin1 to utf8mb4 of ENUM and SET with accented characters on mysql
Awarded Mar 13 at 14:56
Operational Error on MySQL AWS RDS Instance
Awarded Mar 6 at 2:35
(post deleted or otherwise unavailable)
Awarded Feb 6 at 20:04
What are my options to get asynchronous messaging with queues inside PostgreSQL?
Awarded Feb 4 at 3:42
What difference between columnar and wide column databases?
Awarded Jan 27 at 23:47
galara unable to sync
Awarded Jan 23 at 13:50
How to improve performance of this Scalar Function for search with ranking by word
Awarded Jan 16 at 13:50
MySQL replication not synced
Awarded Jan 14 at 13:11
(post deleted or otherwise unavailable)
Awarded Jan 9 at 8:10
postgres ts_headline function is not returning matches it should during full text search
Awarded Jan 7 at 2:15
How to interpret "transactions per second"?
Awarded Dec 29, 2022 at 9:07
Structuring a relational database to run an automatic process
Awarded Dec 23, 2022 at 9:10
pgAgent unwanted delay between jobs start time
Awarded Dec 21, 2022 at 17:15
Right way to set up a secondary citus worker
Awarded Dec 13, 2022 at 22:01
mongodb - composite shard key involving identifier and date
Awarded Nov 8, 2022 at 16:27
More efficient calculations of stock splits
Awarded Nov 7, 2022 at 20:57
How and when is the transaction logs truncated in MSSQL in AWS RDS?
Awarded Nov 7, 2022 at 3:02
Deduplicate while updating self-references in the table, and foreign references in another (PostgreSQL)
Awarded Oct 29, 2022 at 14:56
Can I do a WHERE clause to filter a json_agg column in the outer query?
Awarded Oct 24, 2022 at 0:15
Error with pg_trgm indexes while upgrading postgres on RDS
Awarded Oct 3, 2022 at 8:18
Compare two table and update with endDate
Awarded Sep 10, 2022 at 14:56
MongoDB Won't Start Due to Core Dump
Awarded Sep 8, 2022 at 15:06
Retrieve execution plan via XML data from sp_WhoIsActive in adhoc process
Awarded Aug 24, 2022 at 11:57
How to have uniqueness constraints for structures across multiple tables?
Awarded Aug 4, 2022 at 17:28
Bulk operation prerequisites for non-sysadmins
Awarded Jul 24, 2022 at 13:11
Is there any way to optimize this query (generated by Drupal)?
Awarded Jul 24, 2022 at 1:35
In Azure, what's the best setup for creating a development db with a production db? Replication, mirroring, copying, copy then sync, etc?
Awarded Jul 16, 2022 at 21:06
Is there a way to use time series databases effectively without absolute timestamps?
Awarded Jul 5, 2022 at 11:52
Design database for history data
Awarded Jun 14, 2022 at 12:47
Cannot connect to SQL Server, cannot start SQLEXPRESS service
Awarded Jun 10, 2022 at 7:43
Does pgAdmin4 allow session recovery?
Awarded Jun 8, 2022 at 11:19
(post deleted or otherwise unavailable)
Awarded May 7, 2022 at 13:15
(post deleted or otherwise unavailable)
Awarded May 5, 2022 at 16:02
help with improve query
Awarded May 2, 2022 at 19:27
Display and sort data from 2 tables
Awarded Apr 25, 2022 at 22:45
Efficient unique Inner Join
Awarded Apr 15, 2022 at 6:57
How to migrate the permissions of logins - for example - grant/remove/deny permissions on system objects and server instance?
Awarded Apr 7, 2022 at 5:08
How to modify the Replication Subscription Job/script to make it point an IP Address and a Port number?
Awarded Apr 2, 2022 at 15:51
How can one authenticate with AzAD while using Read-SqlTableData to read AzSQL tables
Awarded Apr 2, 2022 at 15:05
Query result precedence if filter columns have values
Awarded Mar 31, 2022 at 1:35
(post deleted or otherwise unavailable)
Awarded Mar 20, 2022 at 9:49
(post deleted or otherwise unavailable)
Awarded Mar 18, 2022 at 9:56
Backfilling data using generate time series
Awarded Feb 20, 2022 at 15:25
1
2 3 4 5
…
14

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.