MySQL collation allows you to store different characters in databases. Here’s how to change collation of all tables in MySQL.
MySQL Change Collation of All Tables
Author: Sreeram Sreenivasan
Top Database Blogs to Follow
Database blogs provide useful resources, tips and tutorials. Here are the top databases to follow for web developers, database administrators and tech founders.
How To Select Records from Last 24 Hours using PostgreSQL
Sometimes you may need to get rows from last 1 day or last 24 hours. Here’s how to select records from last 24 hours using PostgreSQL.
Top MySQL Workbench Alternatives
How to Increase Max Connections in PostgreSQL
PostgreSQL supports maximum 100 concurrent connections. Here’s how to increase max connections in PostgreSQL.
How To Enable MySQL Query Cache
MySQL Query Cache helps speed up SQL query performance. Here are the steps to enable MySQL Query Cache for better database performance.
PostgreSQL Performance Tuning Tips
How To Enable MySQL Slow Query Log in MySQL
MySQL allows you to log slow queries to log file. Here’s how to enable slow query log in MySQL. Easily locate long running queries in database.
Top 5 PostgreSQL Query Monitoring Tools
PostgreSQL Query monitoring tools are useful for PostgreSQL performance monitoring. Here are the top 5 PostgreSQL Query monitoring tools to monitor PostgreSQL queries.
Top 5 MySQL Monitoring Tools
MySQL monitoring software & tools allow you to monitor database performance & health. Here are the top 5 MySQL Monitoring tools that you can use.