Featured blog posts

Disabling Oracle triggers on a per-session basis

Disabling Oracle triggers on a per-session basis

Mar 26, 2012 12:00:00 AM 1 min read
T-SQL:Generate statements to add TEMPDB datafiles

T-SQL:Generate statements to add TEMPDB datafiles

Mar 20, 2012 12:00:00 AM 6 min read
Getting GoldenGate Heartbeats Working with SUPPRESSTRIGGERS

Getting GoldenGate Heartbeats Working with SUPPRESSTRIGGERS

Mar 9, 2012 12:00:00 AM 4 min read
Moving MSDB to a New Location

Moving MSDB to a New Location

Mar 7, 2012 12:00:00 AM 1 min read
Why Would I Upgrade to SQL Server 2012?

Why Would I Upgrade to SQL Server 2012?

Mar 2, 2012 12:00:00 AM 4 min read
Download free eBook for SQL Server 2012

Download free eBook for SQL Server 2012

Mar 1, 2012 12:00:00 AM 1 min read
SQL 2008 Patch Setup Fails if Patch Source is on a Shared Disk

SQL 2008 Patch Setup Fails if Patch Source is on a Shared Disk

Feb 13, 2012 12:00:00 AM 4 min read
T-SQL: Retrieve all users and associated roles for ALL databases

T-SQL: Retrieve all users and associated roles for ALL databases

Jan 24, 2012 12:00:00 AM 2 min read
Master/Slave Replication In Limited Bandwidth Scenarios

Master/Slave Replication In Limited Bandwidth Scenarios

Jan 23, 2012 12:00:00 AM 3 min read
Oracle Database or Hadoop?

Oracle Database or Hadoop?

Jan 16, 2012 12:00:00 AM 2 min read
Comparing Hadoop Appliances

Comparing Hadoop Appliances

Jan 10, 2012 12:00:00 AM 9 min read
R12.2 online patching – What are the hidden costs?

R12.2 online patching – What are the hidden costs?

Jan 9, 2012 12:00:00 AM 5 min read
Introducing the Quarterly Database Patch for Exadata

Introducing the Quarterly Database Patch for Exadata

Jan 5, 2012 12:00:00 AM 1 min read
Oracle Instance Memory Usage

Oracle Instance Memory Usage

Dec 29, 2011 12:00:00 AM 6 min read
Once again about innodb-concurrency-tickets

Once again about innodb-concurrency-tickets

Dec 13, 2011 12:00:00 AM 5 min read
Troubleshooting SSPI handshake error

Troubleshooting SSPI handshake error

Dec 5, 2011 12:00:00 AM 2 min read
Hashing Algorithm in MySQL PASSWORD()

Hashing Algorithm in MySQL PASSWORD()

Dec 4, 2011 12:00:00 AM 1 min read
SQL Server 2012 Denali: Discussion On Usage Scenario for “Extended Events” (Part-1)

SQL Server 2012 Denali: Discussion On Usage Scenario for “Extended Events” (Part-1)

Dec 2, 2011 12:00:00 AM 10 min read
Exadata Patching Overview

Exadata Patching Overview

Dec 2, 2011 12:00:00 AM 4 min read
Exadata Memory Expansion Kit

Exadata Memory Expansion Kit

Dec 2, 2011 12:00:00 AM 1 min read
#1 Issue you Should be Careful with AWR/STATSPACK Reported Numbers

#1 Issue you Should be Careful with AWR/STATSPACK Reported Numbers

Dec 1, 2011 12:00:00 AM 3 min read
De-Confusing SSD (for Oracle Databases)

De-Confusing SSD (for Oracle Databases)

Nov 22, 2011 12:00:00 AM 7 min read
Rails and Database Session Variables

Rails and Database Session Variables

Nov 21, 2011 12:00:00 AM 1 min read
Linux Patching and Oracle: Detect RPM conflicts before they happen

Linux Patching and Oracle: Detect RPM conflicts before they happen

Nov 15, 2011 12:00:00 AM 9 min read
SQL server: Create missing indexes with unmessing names

SQL server: Create missing indexes with unmessing names

Nov 14, 2011 12:00:00 AM 3 min read
RMAN duplicate in details

RMAN duplicate in details

Nov 7, 2011 12:00:00 AM 7 min read
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