Performance Jonathan Kehayias in Performance A Performance Troubleshooting Methodology for SQL Server When healing a sick SQL Server, you must forget the idea that there could ever be a simple correspondence between... 28 September 2011 33 min read
Patrick Barel Bulk Processing in Oracle Part 2 The process of learning requires not only hearing and applying but also forgetting and then remembering again. – John Gray... 27 September 2011 4 min read
Learn SQL Server Robert Young in Learn SQL Server Going Beyond the Relational Model with Data SQL is a powerful tool for querying data, and for aggregating it. However, you can't easily use it to draw... 27 September 2011 28 min read
Joe Celko Mimicking Network Databases in SQL Unlike the hierarchical database model, which created a tree structure in which to store data, the network model formed a... 26 September 2011 11 min read
Gert Poel Oracle Forms Survey Posted by Gert Poel on the the iAdvise blog: I want to call all Oracle Forms developers and administrators to... 23 September 2011 1 min read
Chet Justice ORACLENERD T-Shirts Recently I was asked to create some merchandise that fell outside of my norm. Specifically, I was asked to create... 20 September 2011 2 min read
Alex Nuijten How Long is this String? A quick puzzle from Alex Nuijten’s blog: How long is the folowing string?: to_char (10, ‘0999’) Have a think, and... 15 September 2011 1 min read
Jim Tilson Writing Better Dynamic SQL Dynamic SQL is a powerful tool. In its proper place it can achieve quite a bit of work in a... 14 September 2011 7 min read
Geoff Hudik Red Gate Schema Compare for Oracle Review From Geoff Hudik’s blog. As part of my recent role in application release management, I have had to compare and... 13 September 2011 2 min read
BI Robert Sheldon in BI Debugging Data Flow in SQL Server Integration Services You can save a lot of time by using the SSIS Troubleshooting tools. These enable you to work with reduced... 13 September 2011 13 min read
Tools Grant Fritchey in Tools SQL# (SQLsharp): A Review Only the brave, and foolhardy, write production CLR routines if you can get the functionality already-written and tested. Whether you're... 13 September 2011 19 min read
Database Administration Brad McGehee in Database Administration Database Properties Health Check Within an instance of SQL Server, the database settings can have a direct effect on the database's behavior, performance and... 13 September 2011 35 min read
David Njoku Introduction to Regular Expressions in Oracle Regular expressions – RegEx or RegExp to their friends – were fashionably late in coming to the Oracle party. The... 06 September 2011 5 min read
Patrick Barel Collections in Oracle Part 2 “The process of learning requires not only hearing and applying but also forgetting and then remembering again.” John Gray. This... 02 September 2011 6 min read
Database Administration Fabiano Amorim in Database Administration Statistics on Ascending Columns It comes as rather a shock to find out that one of the commonest circumstances in an OLTP database, an... 01 September 2011 10 min read
Alex Nuijten Business Rule: Only One per Day, but Keep the Time The business rule states: Only one entry is allowed per ID and per day and the time should be recorded.... 30 August 2011 1 min read
Cary Millsap Mastering Oracle Trace Data A one-day course taught by Cary Millsap London, UK, 8 Sept 2011 Oracle trace data is an extraordinarily rich information... 19 August 2011 1 min read
Patrick Barel Collections in Oracle Part 1 “The beginning of knowledge is the discovery of something we do not understand.” Frank Herbert. Collections are single-dimensioned lists of... 19 August 2011 5 min read
Chris Hritzuk Can PL/SQL be Faster than SQL? PL/SQL and SQL both are incredibly powerful languages that allow us to do some pretty amazing things with data. If... 19 August 2011 11 min read
David Njoku Autonomous Transactions in Oracle Autonomous transactions are a bit like that dark part of the forest, beyond the rickety bridge, where the shadows are... 18 August 2011 6 min read
