Question : I have a number of questions about logging / backup strategies when using MySQL with Docker specifically and […]
Can’t create/write to file ‘/var/log/mariadb/mariadb.log’
Question : I’m troubleshooting a MySQL no-start on CentOS 7 VM. It is a bit unusual to see this since […]
Suppress specific SQL Server log warnings and messages
Question : I want to minimize the output of certain warnings and messages in the SQL Server 2012 logs, such […]
not exists’ seems to be slowing insert
Question : I am trying to run a script that will batch insert over 20 million records into a table […]
Logging Stored Procedure Parameter Values
Question : I’ve worked in an SQL Server environment before where logging was made part of our stored procedures to […]
How do I get postgres to log the stored procedures it is running?
Question : I’m not asking how to log what the stored procedure does, I simply want a list of all […]
What is the performance cost of enabling “log_lock_waits” on Postgres?
Question : I am trying to understand what is the performance cost of enabling log_lock_waits on Postgres. As per this […]
Why does SQL Server Trace Flag 715 behave differently from the TABLOCK query hint?
Question : It’s my understanding, based on numerous sources (including this one: https://techcommunity.microsoft.com/t5/sql-server/migrating-sap-workloads-to-sql-server-just-got-2-5x-faster/ba-p/384910) that SQL Server Trace Flag 715 should […]
How to find out WHERE a PG error/warning/log happened?
Question : I have PostgreSQL CSV-log its “errors” according to this structure: https://www.postgresql.org/docs/12/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG It doesn’t include the file path to […]
How to disable the logging of parameter values in PostgreSQL
Question : Is there a way to disable the logging of the parameter values used in a query, while still […]