Featured blog posts

SQL server:opening errorlog:Failed to retrieve data for this request

SQL server:opening errorlog:Failed to retrieve data for this request

Oct 25, 2011 12:00:00 AM 2 min read
Exporting the mysql.slow_log table into slow query log format

Exporting the mysql.slow_log table into slow query log format

Oct 20, 2011 12:00:00 AM 1 min read
Secrets of Oracle's Automatic Degree of Parallelism

Secrets of Oracle's Automatic Degree of Parallelism

Oct 19, 2011 12:00:00 AM 5 min read
New replication features in MySQL 5.6

New replication features in MySQL 5.6

Oct 14, 2011 12:00:00 AM 12 min read
Indexing text columns with GIST or GIN to optimize LIKE, ILIKE using pg_trgm in Postgres 9.1 (Part 1)

Indexing text columns with GIST or GIN to optimize LIKE, ILIKE using pg_trgm in Postgres 9.1 (Part 1)

Oct 12, 2011 12:00:00 AM 4 min read
Dear DBA_SCHEDULER_RUNNING_JOBS, where have you been?!

Dear DBA_SCHEDULER_RUNNING_JOBS, where have you been?!

Oct 12, 2011 12:00:00 AM 3 min read
Why are your indexes larger than your actual data?

Why are your indexes larger than your actual data?

Oct 11, 2011 12:00:00 AM 6 min read
Change Views DEFINER without ALTER VIEW : how to fix thousands of views!

Change Views DEFINER without ALTER VIEW : how to fix thousands of views!

Oct 5, 2011 12:00:00 AM 2 min read
Change Views DEFINER Without ALTER VIEW: How to Fix Thousands of Views

Change Views DEFINER Without ALTER VIEW: How to Fix Thousands of Views

Oct 5, 2011 12:00:00 AM 2 min read