Get capacity metrics for SQL Server and Oracle
Second round of the capacity metrics SQL Server Size of database : Size of all the tables > 10mo : Current users Current queries Oracle Size of the instance Size of the tablespaces Size of the schemas (only the one above 10MB) Size of the tables (only the one above 10MB) Current users and queries
Get capacity metrics for MySQL and PostgreSQL
Getting capacity metrics for these two dabatases is suprisingly easily. We will get the size of database(s), current users connected and current queries made (and also the size for each tablespace for PostgreSQL). MySQL Size of database : Size of all the tables : Current users and queries If you have the slow query (doc [...]
SQL Expert 101 3/X : DDL and DML
This article is the third of a series of articles aiming to prepare me (and you) to pass the 1Z0-047 Oracle Database SQL Expert. This part covers DDL (like creating table, adding constraints) and DML (insert/update/delete data). Maybe I should have done it in first but anyway let’s begin. Summary : Using DDL Statements to [...]
SQL Expert 101 2/X : Advanced Select
This article is the second of a series of articles aiming to prepare me (and you) to pass the 1Z0-047 Oracle Database SQL Expert. This part covers more advanced SELECT operation. Summary : Displaying Data from Multiple Tables Using Subqueries to Solve Queries Using the Set Operators
SQL Expert 101 1/X : Select
This article is the first of a series of articles aiming to prepare me (and you) to pass the 1Z0-047 Oracle Database SQL Expert.This part covers the basic SELECT operation and basic functions associated. Summary : Retrieving Data Using the SQL SELECT Statement Restricting and Sorting Data Using Single-Row Functions to Customize Output Reporting Aggregated [...]