Featured blog posts

Locating most current record using ROW_NUMBER() vs. Index Full Scan (Min/Max)

Locating most current record using ROW_NUMBER() vs. Index Full Scan (Min/Max)

Dec 1, 2017 12:00:00 AM 5 min read
Sending email from Oracle with utl_smtp via Amazon Simple Email Service (SES)

Sending email from Oracle with utl_smtp via Amazon Simple Email Service (SES)

Sep 21, 2017 12:00:00 AM 10 min read
Investigating IO performance on Amazon EC2

Investigating IO performance on Amazon EC2

Dec 30, 2016 12:00:00 AM 7 min read
Investigating IO performance on Amazon RDS for Oracle

Investigating IO performance on Amazon RDS for Oracle

Dec 13, 2016 12:00:00 AM 9 min read
Add space to tablespace - corrective action in OEM 13c

Add space to tablespace - corrective action in OEM 13c

Oct 18, 2016 12:00:00 AM 1 min read
Data encryption at rest in Oracle MySQL 5.7

Data encryption at rest in Oracle MySQL 5.7

Apr 20, 2016 12:00:00 AM 5 min read
Enabling large pages on Oracle Database 11g running on IBM AIX

Enabling large pages on Oracle Database 11g running on IBM AIX

Apr 4, 2016 12:00:00 AM 3 min read
Network multicast support on Azure

Network multicast support on Azure

Feb 4, 2016 12:00:00 AM 6 min read
Implementing fuzzy search in SQL server - part 2: Levenshtein distance

Implementing fuzzy search in SQL server - part 2: Levenshtein distance

Nov 23, 2015 12:00:00 AM 2 min read
Permissions in Redshift administration

Permissions in Redshift administration

Jun 4, 2015 12:00:00 AM 3 min read
Disable Lock Escalation in SQL Server

Disable Lock Escalation in SQL Server

Apr 10, 2015 12:00:00 AM 1 min read
Availability Group - Delay with Listener Connectivity After Failover

Availability Group - Delay with Listener Connectivity After Failover

Jun 11, 2014 12:00:00 AM 4 min read
Options for Tracing Oracle dbms_stats

Options for Tracing Oracle dbms_stats

Oct 22, 2013 12:00:00 AM 9 min read