Skip to main content
Database Administrators

Teacher

 Teacher
Answer a question with score of 1 or more.
Awarded 15623 times.
Oracle JDBC TLS connection fails (handshake_failure) after OS upgrade
Awarded 2 days ago
Understanding of the %%lockres%% and %%physloc%% pseudo columns with index hint
Awarded 2 days ago
Insert- and Read-only table in Postgres
Awarded Jul 5 at 12:03
MASTER-MASTER replication failed on Production: Coordinator stopped because there were error(s) in the worker(s)
Awarded Jul 4 at 4:25
The store schema does not contain the Element class SqlXmlCompressionOption
Awarded Jul 4 at 2:05
Rollback on \include error in psql
Awarded Jul 4 at 0:46
SQL Server comparison in VS does.. nothing?
Awarded Jul 3 at 21:46
how best to have a record versioning or tracking in relational database?
Awarded Jul 3 at 5:42
Estimate projected database growth
Awarded Jun 30 at 22:12
How do we optimize a transaction-log VIEW in MySQL that will use a LIMIT when executed?
Awarded Jun 29 at 13:25
"Long asynchronous API Call" After Sql Server Update
Awarded Jun 28 at 21:11
Restore deleted filegroup from detached database
Awarded Jun 28 at 20:06
How do I get a list of all the partitioned tables in my database?
Awarded Jun 28 at 9:42
Create Sequence Permission for Postgres
Awarded Jun 27 at 18:11
Kill client connection to Cassandra instance
Awarded Jun 27 at 10:58
How to search whole MySQL database for a particular string
Awarded Jun 27 at 8:50
DBCC CHECKDB WITH EXTENDED_LOGICAL_CHECKS fails when run on Secondary replica
Awarded Jun 26 at 13:33
Sync Schema changes automatically with Logical Replication Postgresql
Awarded Jun 26 at 5:42
How to install sqlplus in macOS M1 Pro ( silicon chip)
Awarded Jun 22 at 18:55
Can't connect with UDL file to SQL Server 2016 but with SSMS it works without problems
Awarded Jun 22 at 3:09
How can I monitor query performance on my Azure read-replica database?
Awarded Jun 18 at 18:56
Replacing a dead 3.11 node fails with OOM
Awarded Jun 18 at 14:17
PostgreSQL crosstab query not using view owner permission when queried from other users
Awarded Jun 17 at 22:00
SQL Server 2022 Express: Missing protocols for instance in Network Configuration
Awarded Jun 17 at 12:10
Postgres jsonb vs composite type performance differences
Awarded Jun 16 at 17:25
MariaDB Crashes Every Time Restarted
Awarded Jun 15 at 13:33
Why is SQLPackage suddenly including every scalar function in my SSDT project for ALTER in my deployment?
Awarded Jun 15 at 6:02
SQL Server: Linked Server connections: Scripting
Awarded Jun 12 at 16:36
How do I change the Authentication Plugin for users mysql.sys, mysql.session, etc?
Awarded Jun 11 at 17:04
Checking REFERENCES permission is granted or not?
Awarded Jun 10 at 23:16
mysql error 1265 data truncated for column
Awarded Jun 9 at 1:33
MySQL data type for 128 bit integers
Awarded Jun 8 at 8:25
SQL Server: query with many fields returning null; query with many fields commented out returning expected data
Awarded Jun 8 at 6:57
Why is it not possible to switch SQL mode on MySQL 8 running on Mac?
Awarded Jun 7 at 6:19
Postgres query planner suddenly changing his mind
Awarded Jun 6 at 8:42
COMMIT_TABLE Waits Crashing System
Awarded Jun 6 at 0:21
What DSN file is MS Access using for ODBC Linked Tables?
Awarded Jun 2 at 14:50
unknown database backup file extension *.gbk
Awarded Jun 2 at 1:20
Cassandra DSE recommendation of 1TB load per node
Awarded May 31 at 13:17
Keyboard shortcut to execute statement at cursor in pgAdmin
Awarded May 30 at 9:12
How to use aes-encryption in PostgreSQL?
Awarded May 29 at 16:35
Why wouldn't VACUUM ANALYZE clear all dead tuples?
Awarded May 28 at 22:55
MySQL Plugin "mysql_old_password" not loaded
Awarded May 28 at 7:03
Enforce non-unique combination of columns, where combination is required
Awarded May 28 at 3:36
Remove spaces and replace characters with regexp_replace()
Awarded May 26 at 21:03
What is the default username and password to the oracle pre-built virtual machine?
Awarded May 25 at 18:57
Why does this query become drastically slower when wrapped in a TVF?
Awarded May 25 at 5:42
MySQL - How to check for a value in all columns
Awarded May 24 at 23:49
how to verify mysql backup file using BlackHole
Awarded May 24 at 21:55
Query with Indexes slower than without Indexes
Awarded May 24 at 17:41
How to list all constraints of a table in PostgreSQL?
Awarded May 22 at 18:26
how to match pg_repack binary and db version
Awarded May 21 at 17:57
Multiples full backup from MS SQL Server all day long
Awarded May 21 at 12:33
Database cannot be opened. It is in the middle of a restore
Awarded May 21 at 11:31
SQL 2017 log reuse issue
Awarded May 21 at 11:31
Postgres query stuck on wait_event "MessageQueueSend"
Awarded May 21 at 9:25
sp_BlitzFirst takes too long to complete
Awarded May 21 at 6:41
Non-yielding Scheduler Error in SQL Server 2019 on Docker with CDC Enabled
Awarded May 19 at 16:08
Identify the version of a collation from ICU in Postgres
Awarded May 17 at 15:10
Login lacks connect endpoint permission in SQL Server - Error 18456, State: 149
Awarded May 16 at 6:42
1
2 3 4 5
…
261