Aman Sharma An Introduction to 11.2 RAC Server Pools Oracle RAC is designed to cater for Oracle specific applications and also non-oracle applications. These applications, both Oracle and non-Oracle,... 18 April 2012 19 min read
Syed Jaffar Hussain Migrating Oracle Single Instance to RAC This video is a recording from the webinar broadcast by Red Gate on 29th March 2012. Oracle Database administrators have... 17 April 2012 1 min read
Buck Woody Big Data is Just a Fad The Term 'Big Data' is nothing more than a fad, and we'll soon be cringing with embarrassment at the thought... 13 April 2012 12 min read
Phil Factor The TSQL of CSV: Comma-Delimited of Errors Despite the neglect of the basic ODBC drivers over the years, they still afford a neat way of reading from,... 13 April 2012 20 min read
Randolf Geist Oracle Cost-Based Optimizer Basics This video and set of resources is a follow up to the webinar broadcast by Red Gate on 11 Apr... 10 April 2012 2 min read
Martin Giffy DSouza Building Apex Plugins 101 Martin Giffy D’Souza has created some of the most popular plug-ins available on the APEX plug-in community page. He has... 28 March 2012 1 min read
Dominic Delmolino ORA-01801: Date Format is too Long for Internal Buffer Oracle 10.2.0.1 (I know, version out-of-date) on Windows 2003: The other day one of my stored procedures error’ed out with:... 27 March 2012 1 min read
Robert Sheldon Implementing Foreach Looping Logic in SSIS With SSIS, it is possible to implement looping logic into SSIS's control flow in order to define a repeating workflow... 27 March 2012 13 min read
Martin Giffy DSouza How APEX Processes Various Conditions and Validations I was recently teaching an Intro to APEX course and the students had some questions about what to put in... 26 March 2012 1 min read
Jeremy Jarrell MongoDB Basics for .NET by Example MongoDB is one of the more intriguing 'NoSQL' databases to emerge from 'Cloud' computing. Sometimes, the best way of understanding... 26 March 2012 11 min read
Grant Fritchey How to Get Information About Your Backups When you need to restore but aren't 100% sure about the contents of your backup files, what do you do?... 23 March 2012 18 min read
Joe Celko Bin Packing Problems: The SQL The 'bin packing' problem isn't just a fascination for computer scientists, but comes up in a whole range of real-world... 22 March 2012 10 min read
David Njoku The 40 Most Common Oracle Errors I have been in this industry long enough to remember the bad old days, when every developer and DBA had... 12 March 2012 6 min read
Phil Factor Generating Data for Database Tests It is more and more essential for developers to work on development databases that have realistic data in both type... 08 March 2012 22 min read
Michelle Malcher Security in the Database is more than Just Granting Access Michelle Malcher (Oracle Ace Director and a representative on the Oracle Security Customer Advisor Council for the Independent Oracle User... 06 March 2012 1 min read
Syed Jaffar Hussain Upgrading to Oracle 11gR2 It has been a common practice and relatively a tough task for almost every individual Oracle DBA to decide whether... 05 March 2012 1 min read
Jerry Ireland Virtualization Overview Virtualization is a hot topic in the IT world. What is virtualization and why is it so popular? First... 02 March 2012 20 min read
Robert Sheldon Working with Variables in SQL Server Integration Services There are a number of ways that you can incorporated variables into your SSIS Scripts. Robert Sheldon demonstrates how.… 01 March 2012 12 min read
Luciano Moreira No Significant Fragmentation? Look Closer… If you are relying on using 'best-practice' percentage-based thresholds when you are creating an index maintenance plan for a SQL... 28 February 2012 9 min read
Patrick Barel Caching Part 2 Never trust a computer you can’t throw out of a window. Steve Wozniak Deterministic Function Caching A function is considered... 23 February 2012 1 min read
