Database Services
Database backups are useful in disaster recovery scenarios and can help organizations comply with state-specific data retention laws. HIPAA does not have a ...
Fri, 25 Aug, 2017 at 6:53 AM
If you are migrating your database from another service or environment or restoring a database backup, the following steps describe how to load your databa...
Thu, 19 Jul, 2018 at 6:59 PM
By running PostgreSQL inside a Docker container, it is easier to isolate system dependencies, test new versions, and apply upgrades without affecting the ...
Thu, 18 Aug, 2016 at 11:25 PM
To perform this command your user must be part of the database administrator role.
Run command via psql:
psql -c "CREATE EXTENSION hstore&quo...
Wed, 17 Aug, 2016 at 11:12 PM
To identify queries requiring more than 2 seconds to run (change this value as needed), run the following command via psql: SELECT now() - query_start as &...
Thu, 11 Jan, 2018 at 8:45 AM
To enable logging of slow queries, do this with the mysql shell: set global slow_query_log = 1;
set global long_query_time = 0.05; // logs queries slower t...
Tue, 5 Jun, 2018 at 7:49 AM
To satisfy HIPAA requirements, protected health information (PHI) should be encrypted in transmission. The Healthcare Blocks MySQL Database Service is confi...
Thu, 11 May, 2017 at 11:44 PM
Your application server comes with the mongo shell pre-installed. Connecting with SSL: Per HIPAA requirements, you should use a TLS (SSL) connection when ...
Sat, 29 Apr, 2017 at 12:25 PM
Expensive queries can impact overall performance. By adding an index to a column being used in a query, it can significantly improve overall query times. He...
Mon, 21 May, 2018 at 3:09 PM
Setting up an SSH tunnel allows you to use applications and tools on your local development machine while being connected to the remote server hosting your ...
Thu, 8 Jun, 2017 at 11:10 AM