sales@dataedo.com +1 704-387-5078 My account
Bart Gawrych - Dataedo Team

Bart Gawrych

Database developer

Categories
Query Toolbox
PostgreSQL > Session: Find last query executed by specific session in PostgreSQL database
MariaDB > Jobs/events: List events on MariaDB server
MySQL > Jobs/events: List events on MySQL server
2019-01-29
Query Toolbox
MariaDB > Unique keys: List unique keys and indexes in MariaDB database
MySQL > Unique keys: List unique keys and indexes in MySQL database
MySQL > Data types: Find all JSON data columns in MySQL database
MySQL > Data types: Find all enum columns in MySQL database
MariaDB > Data types: Find all enum columns in MySQL database
MariaDB > Data types: Find all numeric columns in MariaDB database
MySQL > Data types: Find all numeric columns in MySQL database
MySQL > Data types: Find all date and time columns in MySQL database
MariaDB > Data types: Find all date and time columns in MariaDB database
MariaDB > Data types: Find all string (character) columns in MariaDB database
MySQL > Data types: Find all string (character) columns in MySQL database
MariaDB > Indexes: List unique indexes in MariaDB database
MySQL > Indexes: List unique indexes in MySQL database
MySQL > Data size: List idexes by their size in MySQL database
MariaDB > Data size: List idexes by their size in MariaDB database
2019-01-28
Query Toolbox
MariaDB > Tables: List InnoDB tables in MySQL database
MySQL > Tables: List InnoDB tables in MySQL database
MySQL > Tables: List MyISAM tables in MySQL database
MariaDB > Tables: List MyISAM tables in MariaDB database
MySQL > Data size: List tables by the size of data and indexes in MySQL database
MariaDB > Data size: List tables by the size of their indexes in MariaDB database
MySQL > Data size: List tables by the size of their indexes in MySQL database
MariaDB > Data size: List 10 largest tables in MariaDB database
MySQL > Data size: List 10 largest tables in MySQL database
2019-01-25
Query Toolbox
MariaDB > Default values: List table default values in MariaDB database
MySQL > Default values: List table default values in MySQL database
MariaDB > Default values: List all default values in MariaDB database
MySQL > Default values: List all default values in MySQL database
2019-01-24
Query Toolbox
MariaDB > Default values: Summary of default values in MariaDB database
MySQL > Default values: Summary of default values in MySQL database
MySQL > Indexes: List table indexes in MySQL database
MariaDB > Indexes: List table indexes in MariaDB database
MariaDB > Indexes: List all indexes in MariaDB database
MySQL > Indexes: List all indexes in MySQL database
MariaDB > Triggers: List triggers by table name in MariaDB database
MySQL > Number of rows: Number of tables by the number of rows in MySQL database
MySQL > Session: Terminate (kill) a specific session on MySQL server
MariaDB > Constraints: Find required (non nullable) columns in MariaDB database
MariaDB > Constraints: Check if is column nullable in MariaDB database
MariaDB > Triggers: List triggers in MariaDB database
2019-01-21
Query Toolbox
MariaDB > Primary keys: List all primary keys (PKs) and their columns in MariaDB database
MariaDB > Views: List views columns in MariaDB database
MariaDB > Views: List views in MariaDB database
MariaDB > Tables: Find recently created tables in MariaDB database
MySQL > Tables: Find recently created tables in MySQL database
MariaDB > Databases and schemas: List user created databases (schemas) in MariaDB
MariaDB > Security and users: List users in MariaDB database
MySQL > Security and users: List users in MySQL database
MariaDB > Foreign keys: List table columns with their foreign keys in MariaDB database
MySQL > Foreign keys: List table columns with their foreign keys in MySQL database
MariaDB > Foreign keys: List foreign keys with columns in MariaDB database
MySQL > Foreign keys: List foreign keys with columns in MySQL database
MariaDB > Foreign keys: List foreign keys in MariaDB database
MySQL > Foreign keys: List foreign keys in MySQL database
2019-01-18
Query Toolbox
MySQL > Triggers: List triggers by table name in MySQL database
MySQL > Triggers: List triggers in MySQL database
MySQL > Constraints: Find required (non nullable) columns in MySQL database
MariaDB > Primary keys: How many tables don't have primary keys (with percentage) in MariaDB database
Snowflake > Data usage: Find unused tables in Snowflake
IBM Db2 > Data usage: Find tables not accessed for past n months in Db2 database
IBM Db2 > Data usage: Find the time when table was last accessed in Db2 database
MySQL > Constraints: Check if is column nullable in MySQL database
MySQL > Primary keys: How many tables don't have primary keys (with percentage) in MySQL database
MySQL > Views: List tables used by a view in MySQL database
MySQL > Views: List views columns in MySQL database
MySQL > Views: List views in MySQL database
2019-01-17
Query Toolbox
Teradata > Searching database: Find databases containing a particular table on Teradata server
MySQL > Primary keys: Find tables without primary keys (PKs) in MySQL database
MariaDB > Primary keys: Find tables without primary keys (PKs) in MariaDB database
MariaDB > Primary keys: List tables with their primary keys (PKs) in MariaDB database
MySQL > Primary keys: List tables with their primary keys (PKs) in MySQL database
MySQL > Databases and schemas: List user created databases (schemas) in MySQL
MySQL > Columns: List all columns in specific table in MySQL database
Teradata > Tables: Find recently created tables in Teradata database
2019-01-15
Query Toolbox
MySQL > Session: Find last query executed by specific session on MySQL server
IBM Db2 > Data size: List tables by their size in Db2 database
2019-01-14
Query Toolbox
Snowflake > Session: Abort (kill) specific session on a server
Snowflake > Session: Find queries executed in specific warehouse in Snowflake
Snowflake > Session: Find queries executed in specific time range in Snowflake
Snowflake > Session: Find last query executed by specific user in Snowflake
Snowflake > Session: Find last query executed by specific session in Snowflake
2019-01-03
Query Toolbox
MariaDB > Primary keys: List all primary keys (PKs) in MariaDB database
2019-01-02
Query Toolbox
Teradata > Views: List views in Teradata database
PostgreSQL > Session: List sessions / active connections in PostgreSQL database
Amazon Redshift > Default values: List table default values in Redshift
Amazon Redshift > Schema naming: Find most popular column names in Redshift
2018-12-21