Windows 8 Preview
Windows 8 was presented at the BUILD conference and a preview was available for download. You can find the iso (with or without tools) here : . I couldn’t get it to work in VMWare but it works well in VirtualBox. There are several new things : – Integration with Windows Live (you can put [...]
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
Install ibm_db on Ubuntu
Ok so this one was a bit tricky. I needed to access remote DB2 databases using Python. I found ibm_db (page here) and followed the instructions. First you need to set up DB2 drivers : you can get it here (Data Server Driver Package, NOT the ODBC) or here here (I used this one). You [...]
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 [...]
Install Oracle on CentOS 6
I followed the quick installation guide Oracle provides so that’s more like an even quicker installation guide. To start, we need to install the necessary packages : [root@oracletest database]# yum install binutils compat-libstdc++* elfutils* gcc gcc-c++ glibc* compat-glibc* ksh libaio* libstdc++* make sysstat unixODBC unixODBC-devel We now need to create the users and groups : [...]
Install CentOS 6 using the remote Net Install
Instead of downloading the 4.x go for the DVD iso, you could download the Net Install (about 216mo) and let it retrieves what it needs to install. You can download the iso there http://www.centos.org/modules/tinycontent/index.php?id=30 in the 6 or 6.0 directory. Once you load it on your server or VM, you will have to choose the [...]
Cleaning Postgres WAL archive directory
A little script allowing to clean old WAL files for PostgreSQL
Load various excel files into MySQL
I recently had to write a python script that was unzipping a an archive containing several excel files and then load the data of a specific sheet into a MySQL 5 database. Doing it with only SQL was not an option since it required some manual actions (saving the sheet as csv, which resulted in [...]
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 [...]
RMAN
RMAN (Recovery Manager) is the the backup and recovery tool recommended by Oracle. There are several ways to create RMAN jobs : EM interface, command-line and scripts.Before the technical stuff, we should learn the backup vocabulary.