Skip to main content
Database Administrators

Excavator

 Excavator
Edit first post that was inactive for 6 months.
Awarded 1537 times.
How do you correlate SQL Database Audit spec's log column transaction_id with a LSN? from trans log or CDC capture table?
Awarded Oct 31 at 4:04
Best practices for committing a transaction in SQL Server where TRY CATCH is used
Awarded Oct 22 at 5:11
Proper technique for storing users event data
Awarded Oct 1 at 4:36
How to create a linked server to PostgreSQL database in MS SSMS?
Awarded Sep 27 at 5:17
pgAdmin: What is the Maintenance DB?
Awarded Sep 20 at 5:03
sqlite3 -Infinity value in Float field
Awarded Sep 7 at 5:08
Log Shipping "out of sync" but none of the jobs are failing
Awarded Aug 31 at 4:02
Postgresql: Trigger is not working at times
Awarded Aug 23 at 4:56
how to add a user to local sql server when one has only windows admin rights on the server
Awarded Aug 7 at 4:53
SQL Server cardinality hint
Awarded Aug 6 at 5:01
Error while restoring a Database from an SQL dump
Awarded Jul 31 at 4:10
Unnest array of arrays
Awarded Jul 24 at 4:12
Is there a way to access temporary tables of other sessions in postgres?
Awarded Jun 26 at 5:17
MySQL data warehouse calculate difference over years in percentage
Awarded Jun 17 at 4:45
Do you set an index on JOIN clauses or where clauses, or both?
Awarded Jun 13 at 4:27
How to find all entities owned by a login?
Awarded Jun 13 at 4:27
MySQL: Return JSON from a standard SQL Query
Awarded Jun 7 at 5:16
MySql InnoDB crash recovery - File ./ibdata1: 'open' returned OS error 71. Cannot continue operation
Awarded Jun 2 at 5:05
How do you use psql client to connect to a postgresql ipv6 host?
Awarded Apr 26 at 4:36
PostgreSQL Common Table Expressions vs a temporary table?
Awarded Apr 16 at 4:20
How to break SQL script execution
Awarded Apr 13 at 5:22
Copy table structure excluding nullability into local temporary table
Awarded Apr 8 at 5:47
Disable MySQL binary logging with log_bin variable
Awarded Mar 28 at 4:06
Maximum number of databases for single instance of PostgreSQL 9
Awarded Mar 22 at 4:02
Upgrading MySQL utf8mb3 to utf8mb4 - how to replicate documentation behaviour?
Awarded Mar 13 at 4:05
How do I validate all my constraints in postgresql?
Awarded Mar 11 at 7:19
pgAdmin: What is the Maintenance DB?
Awarded Feb 17 at 4:33
Should I use the PostgreSQL bit string?
Awarded Feb 13 at 4:12
Force drop db while others may be connected
Awarded Feb 11 at 4:55
Delete rows older than x days without locking table
Awarded Jan 17 at 4:02
SQL Server Internal Memory Pressure
Awarded Jan 7 at 4:17
How can I create readonly user for backups in PostgreSQL?
Awarded Dec 20, 2024 at 4:10
NOT NULL if value is true in another column
Awarded Dec 11, 2024 at 4:10
Row level security with a single DB user and connection pooling
Awarded Dec 6, 2024 at 5:30
Is there a cool way of performing CU updates for SQL Server on hundreds of machines?
Awarded Dec 3, 2024 at 4:34
Changing POSTGRES column datatype - should I drop indexes and then re-create?
Awarded Nov 21, 2024 at 4:32
SQL server update trigger to track updates on any column
Awarded Nov 8, 2024 at 4:21
Better way to restore to existing pg database
Awarded Nov 4, 2024 at 4:10
Unable to load user-specified certificate in event log although SSL certificate is installed
Awarded Nov 3, 2024 at 4:19
Display user-defined types and their details
Awarded Oct 31, 2024 at 5:37
SQLite where condition - compare two last rows
Awarded Sep 26, 2024 at 4:02
MySQL Index creation failing on table is full
Awarded Sep 25, 2024 at 7:01
MariaDB replication lagging up to a dozen times a day for no obvious reasons
Awarded Sep 14, 2024 at 6:36
Convert hexadecimal to varchar
Awarded Sep 4, 2024 at 4:12
Calculate the sum of minutes between statuses Clickhouse
Awarded Sep 4, 2024 at 4:12
Limiting the Number of Records Joined
Awarded Sep 1, 2024 at 4:27
Azure Data Studio - Intellisense does not detect tables, yet queries work. How do I fix this?
Awarded Aug 22, 2024 at 4:18
Importing a Foxpro Database
Awarded Aug 13, 2024 at 5:00
I need to run VACUUM FULL with no available disk space
Awarded Aug 9, 2024 at 4:20
SQL Server Database Engine cannot obtain a LOCK resource at this time
Awarded Aug 4, 2024 at 5:28
pgAdmin: What is the Maintenance DB?
Awarded Jul 30, 2024 at 6:10
Are these tools still valid?
Awarded Jul 26, 2024 at 11:15
Pattern matching with LIKE, SIMILAR TO or regular expressions
Awarded Jul 24, 2024 at 4:56
How do I store phone numbers in PostgreSQL?
Awarded Jul 15, 2024 at 4:57
Is it possible to set auto-increment-increment by 10 for only one table?
Awarded Jun 27, 2024 at 4:48
How to reset MariaDB into a "fresh install" state?
Awarded Jun 23, 2024 at 4:36
How to insert a Unicode character verbose into a varchar DB?
Awarded May 28, 2024 at 4:06
Error while deploying in replicaset in windows (MongoDB)
Awarded May 22, 2024 at 5:06
Error Authenticating Proxy Account when Executing SSIS job
Awarded May 21, 2024 at 4:49
Changing foreign key to ON DELETE CASCADE with least amount of impact
Awarded May 17, 2024 at 4:22
1
2 3 4 5
…
26