Useful tips for everyday
What to do if your data usage is over your limit? If you regularly go over your plan’s data limit, consider changing your plan to…
How do I cast to int in PostgreSQL? If you need to treat empty columns as NULL s, try this: SELECT CAST(nullif(, ”) AS integer);…
Why would you allow duplicates in a query? The query output simply shows you whether the record belongs in the query. If a field with…
What is transparent disk encryption? Transparent Data Encryption (often abbreviated to TDE) is a technology employed by Microsoft, IBM and Oracle to encrypt database files.…
How to Set up alerts in oracle Enterprise Manager? From the username menu, in the top-right corner of the console, select Enterprise Manager Password &…
How do I increase my IOPS for RDS? Modifying SSD storage settings for Provisioned IOPS In the navigation pane, choose Databases. Choose the DB instance…
How does synchronous replication work in MySQL Cluster? Synchronous Replication – Data within each data node is synchronously replicated to another data node. Automatic Failover…
Is Unique index same as primary key? Primary key will not accept NULL values whereas Unique key can accept NULL values. A table can have…
What is a compound index MongoDB? Or in other words, compound indexes are those indexes where a single index field contains references to multiple fields.…
Why do we normalize rows? Row Normalization: An example could be where let us say a data contains lot of samples where each sample represented…