Question : For regulatory and fraud requirements, we need to record every change to most of the tables in the […]
Tag: scripting
Advice on scripting a “whitewashed” and downsized development db from main db
Question : Currently we (an active opensource project) have a large PostgreSQL production database which contains all the site records. […]
Script to check CPU, memory, server type
Question : Can someone please help me with the script to get CPU, total physical memory, server type(i.e. physical/VM), maxdop […]
Script to Output Tables to CSV Showing Heading Only Once [duplicate]
Question : This question already has answers here: How can I unload Oracle database tables into a csv files? (4 […]
Does SQL Server / T-SQL support line-continuation to break up long strings?
Question : I sometimes have a SQL script that has one or more super-long (sometimes even stupid-long) strings. Typically these […]
ORACLE_HOME / ORACLE_SID variable – why do we need to export them ?
Question : I am not sure if this is a bash / shell question or oracle question. I am on […]
script all triggers in a database
Question : I have a few databases involved in replication as subscribers and they have triggers and are used by […]
How to manipulate bytea data when using backup script as a template
Question : I have a project with a web app that has many configurable options, with the configurations stored in […]
Use sp_Blitz to gather information on all servers in a centralized server/database
Question : I am using sp_Blitz, and want to use it to execute the checks on all of my SQL […]
script to find all bigint that can be converted to int fields in postgresql performance
Question : I want to compact a postgresql 11 db and my idea is to convert lots of bigint to […]