Self-Learner - Badge - Database Administrators Stack Exchange

Self-Learner

Answer your own question with score of 3 or more.

Awarded 1184 times.

SQL script to count rows for all views in a database with SELECT-only access

Awarded Dec 7 at 5:08

Mel

1871 gold badge3 silver badges12 bronze badges

Does SQL Server re-create system databases if they are lost/missing?

Awarded Nov 21 at 17:37

EvilDr

8402 gold badges13 silver badges27 bronze badges

How do I correct InnoDB Multiple files found for the same tablespace ID?

Awarded Nov 17 at 8:31

Mark Lee

1311 silver badge4 bronze badges

Insert gives error code 1366 even though charset is utf8mb4

Awarded Nov 16 at 22:27

Vongo

1715 bronze badges

Inherit audit columns and triggers

Awarded Nov 6 at 13:05

Dave Jarvis

8331 gold badge10 silver badges25 bronze badges

"connection failed" error for pg_cron extension

Awarded Nov 6 at 10:52

Oto Shavadze

4951 gold badge7 silver badges14 bronze badges

postgres wal sender replication timeout during pg_basebackup

Awarded Nov 3 at 4:41

Peter B

1611 gold badge1 silver badge8 bronze badges

MySQL command denied for DELETE with JOIN

Awarded Oct 27 at 15:45

Beshoy Girgis

1531 silver badge7 bronze badges

Relay log read fail, relay or master log currupt ,How to repair?

Awarded Oct 13 at 11:50

dan

535 bronze badges

Forcing a sequential scan over the index scan

Awarded Oct 11 at 14:15

tail

2351 silver badge8 bronze badges

Why NOT partition?

Awarded Oct 4 at 16:48

chell

1951 silver badge11 bronze badges

MariaDB: Missing FILE_CHECKPOINT

Awarded Sep 29 at 18:42

Kal

411 silver badge4 bronze badges

ROWNUM equivalent in Centura SQLBase (aka Gupta)

Awarded Sep 22 at 11:11

w2013

616 bronze badges

Disabling Aria INSERT log in MariaDB

Awarded Sep 21 at 4:45

Googlebot

4,49124 gold badges66 silver badges94 bronze badges

Adding LEFT JOIN to a query has increased execution time 10 times

Awarded Sep 14 at 19:10

Alexander Farber

4052 gold badges7 silver badges19 bronze badges

MySQL - [Note] Got an error reading communication packets

Awarded Sep 7 at 10:46

ImranRazaKhan

1491 gold badge1 silver badge7 bronze badges

Using Kerberos Constrained Delegation with an ADSI Linked Server

Awarded Aug 22 at 7:57

DamonDCD

716 bronze badges

Error while creating continuous aggregate (materialized view) when source and new time columns have the same name (PSQL/TSDB)

Awarded Aug 17 at 15:16

Héctor

2874 silver badges14 bronze badges

Postgresql comment on specific role

Awarded Aug 8 at 2:21

jwc

515 bronze badges

Postgresql 14 on Windows 10: pg_ctl.exe returns is not a database cluster directory

Awarded Aug 7 at 16:57

nephewtom

1511 silver badge7 bronze badges

Too many TEXT fields leads to record too big

Awarded Jul 29 at 18:42

Rick James

77.1k5 gold badges45 silver badges111 bronze badges

Postgresql error syntax error at or near "END;"

Awarded Jul 10 at 20:04

martmalo

411 silver badge4 bronze badges

Optimize performance of nested GROUP BY

Awarded Jul 6 at 22:19

Hans Yu

515 bronze badges

Error updating sql server geography type in trigger

Awarded Jun 27 at 4:46

Spectre87

1617 bronze badges

How to create alias in SQL Server 2022

Awarded Jun 21 at 14:42

Tom Pažourek

4134 silver badges18 bronze badges

How to install PostgreSQL Anonymizer 0.8.1 on Amazon RDS?

Awarded Jun 20 at 20:35

Christiaan Westerbeek

3072 silver badges10 bronze badges

Why is a connection via an SSH tunnel presenting as 127.0.0.1 and not localhost?

Awarded Jun 14 at 9:51

jamieburchell

1515 bronze badges

Extract JSON object inside of an JSON array then search base on ID

Awarded Jun 8 at 10:05

スペースタイム

511 gold badge1 silver badge7 bronze badges

Partial unique constraint spanning multiple tables in postgres

Awarded Jun 8 at 7:41

lpd

2511 gold badge2 silver badges7 bronze badges

Postgresql multi-field index on jsonb data does full tablescan when field is not found

Awarded Jun 6 at 16:51

moodboom

1518 bronze badges

How to fix MySQL using large amount of memory

Awarded May 29 at 21:31

404 Not Found

1395 bronze badges

INSERT rows in two tables preserving connection to a third table

Awarded May 16 at 17:05

Pierluca

631 silver badge8 bronze badges

Recreating Database from IBD files (no FRM)

Awarded May 10 at 15:35

csaborio

311 silver badge4 bronze badges

Can't find any tables after psql dump import from pgexercises.com

Awarded May 6 at 23:06

Cornelius Roemer

1417 bronze badges

Collation version mismatch

Awarded May 3 at 2:50

Miqueias Kevison

4011 gold badge1 silver badge8 bronze badges

Which specific SQL Server feature installs the Microsoft.SqlServer.ManagedDTS.dll?

Awarded Apr 25 at 21:07

Michael Riley - AKA Gunny

9452 gold badges7 silver badges19 bronze badges

Total size of multiple Bit(1) fields in PostgreSQL

Awarded Apr 21 at 10:35

JounceCracklePop

1931 silver badge6 bronze badges

PostgreSQL uses huge amount of memory

Awarded Apr 21 at 10:35

Rafael Chielle

414 bronze badges

PostgreSQL copy text type column to text[] array type column

Awarded Apr 18 at 12:15

John

7051 gold badge10 silver badges22 bronze badges

Maximum length or special character restrictions for PostgreSQL 13 user password?

Awarded Apr 6 at 5:52

cjones

3531 gold badge5 silver badges12 bronze badges

faster ALTER COLUMN

Awarded Apr 3 at 10:16

Gabriele D'Onufrio

2672 silver badges14 bronze badges

What permissions are needed to prevent ERROR: permission denied for pg_tablespace_size('pg_global') in RDS?

Awarded Mar 27 at 14:26

Philip Couling

1618 bronze badges

Why not use two columns instead of collation for case insensitive data?

Awarded Mar 22 at 8:11

IvanD

2912 silver badges9 bronze badges

Best General Purpose Character Set and Collation for MySQL

Awarded Mar 16 at 4:04

GTS Joe

2332 silver badges8 bronze badges

HAProxy + Patroni - Configure reads from a master when no slaves available

Awarded Mar 5 at 14:50

DMin

1635 bronze badges

What does this margin symbol in the SSMS text editor mean?

Awarded Mar 2 at 0:43

Daniel Hume

1616 bronze badges

Oracle - Can't login with "/ as sysdba", but can with "sys as sysdba"

Awarded Feb 28 at 11:40

Kytech

611 silver badge6 bronze badges

Extension "plpythonu" is not supported by Amazon RDS

Awarded Feb 19 at 0:40

SQLSERVERDAWG

1111 gold badge2 silver badges9 bronze badges

String parsing: Extracting the filename from a URL

Awarded Feb 17 at 12:36

Deepan Kaviarasu

958 bronze badges

Unable to join secondary replica to the availability group by SQL Server error 47106

Awarded Feb 6 at 19:02

Aqib

611 gold badge1 silver badge6 bronze badges

Subscription Initialization throws Error "The option "INLINE=ON" is not valid for this function" which is incorrect

Awarded Feb 4 at 6:36

Ollie

7384 silver badges13 bronze badges

AWS Postgres RDS "storage-full" and not responding. How to bring back online?

Awarded Feb 1 at 22:05

jack2684

1831 silver badge8 bronze badges

Database keeps crashing every few hours

Awarded Jan 23 at 13:15

lyeaf

1678 bronze badges

ERROR 1045 (28000) & access denied for user 'root'@'localhost'

Awarded Jan 18 at 6:02

mgae2m

1611 gold badge1 silver badge5 bronze badges

MySQL RDS - Unable to Kill Hung Queries

Awarded Jan 11 at 20:42

Nick Heidke

1631 silver badge8 bronze badges

Invalid object name 'ApexSQL.ApexSQL_SourceControl.Objects'

Awarded Jan 10 at 22:02

Ben Watson

1017 bronze badges

How to Join two tables with Count , GROUP BY & Join in SQL server?

Awarded Dec 31, 2022 at 8:52

zkhan122

691 gold badge1 silver badge6 bronze badges

sqlpackage.exe ignoring BlockOnPossibleDataLoss?

Awarded Dec 22, 2022 at 14:51

nojetlag

2,8779 gold badges33 silver badges41 bronze badges

PostgreSQL logical replication using pglogical

Awarded Dec 12, 2022 at 23:55

Mika

3313 silver badges12 bronze badges

Upgrade a large mongodb database from 3.6 to 6

Awarded Dec 6, 2022 at 9:51

fso4242

615 bronze badges

2 3 4 5

…

20 Next