Feodor Georgiev Administrating SQL Server Reporting Services – Planning, Documenting and Troubleshooting DBAs are usually charged with the administration of Reporting Services, but are often short on guidance on how to go... 22 November 2011 17 min read
Jeff Smith SQL Developer Data Modeler Quick Tip: Use SubViews Modeling is cute when you’re in a class and the sample application is for a rotisserie league for fantasy football,... 16 November 2011 2 min read
Tim Hall Oracle Database 11g Release 2 RAC On Linux Using VMware Server 2 This article on ORACLE-BASE describes the installation of Oracle Database 11g release 2 (11.2 64-bit) RAC on Linux (Oracle Enterprise... 14 November 2011 4 min read
Jim Tilson Which of these things is not like the other? Have you ever played the game where you try to identify the differences between two side-by-side seemingly-identical pictures? Sometimes answering... 11 November 2011 7 min read
Jeremiah Peschka SQL Server Functions: The Basics SQL Server's functions are a valuable addition to TSQL when used wisely. Jeremiah provides a complete and comprehensive guide to... 10 November 2011 41 min read
Alex Nuijten Upgrade to APEX 4.1: Invalid Login Credentials Always a good idea to upgrade on a Friday.. not… 08 November 2011 1 min read
William Brewer Database Source Control – The Cribsheet As part of our long-running Cribsheet series, we asked William to come up with a brief summary of what was... 08 November 2011 25 min read
Robert Sheldon Working with the XML Data Type in SQL Server The XML data type, introduced in SQL Server 2005, is a powerful construct. When used wisely, it can provide useful... 07 November 2011 16 min read
Patrick Barel Dynamic Show/Hide in APEX Understanding is required before success is possible [Dune] old Orange Catholic Bible When you want to hide and display certain... 31 October 2011 4 min read
Database Administration Grant Fritchey in Database Administration 7 Preventable Backup Errors The loss of a company's data is often enough to put the company out of business; and yet backup errors... 31 October 2011 16 min read
Joe Celko Voting Paradoxes: a SQL Stumper Voting systems can become very complex, and some of them are easy to manipulate by tactical voting. Joe takes a... 28 October 2011 9 min read
Learn SQL Server Fabiano Amorim in Learn SQL Server Window Functions in SQL Server When SQL Server introduced Window Functions in SQL Server 2005, it was done in a rather tentative way, with only... 27 October 2011 12 min read
Tools Grant Fritchey in Tools SSMS Tools Pack 2.0 If you work with SSMS, you'll know how frustrating it can be when tasks you perform every day aren't part... 26 October 2011 12 min read
Learn SQL Server Roy Ernest in Learn SQL Server Resource Governor If you suffer from runaway queries, if you have several database applications with unpredictable fluctuation in workload, or if you... 26 October 2011 23 min read
David Njoku Introduction to Scheduled Jobs Psst, wanna see something cool? I bet I can read your future. Your tomorrow is going to be almost exactly... 17 October 2011 7 min read
Tim Hall Cloud Control 12c R1 Installation on Oracle Linux 5.7 & 6.1 Enterprise Manager Cloud Control is the new name for what was previously know as Enterprise Manager Grid Control. Depending on... 12 October 2011 1 min read
Grant Fritchey Auditing DDL Changes in SQL Server databases Even where Source Control isn't being used by developers, it is still possible to automate the process of tracking the... 12 October 2011 17 min read
Gert Poel What’s Your Choice for Oracle Forms? Forms was a great tool and stood for fast and easy development. You could create nice data entry applications in... 11 October 2011 6 min read
Robert Sheldon Implementing Checkpoints in an SSIS Package Like any other application, an SSIS package can fail. Once the problem has been resolved, you'll usually restart the package,... 10 October 2011 12 min read
David Njoku Introduction to Virtual Private Databases You know the story. A group of blind men come across an elephant and each one feels a part... 04 October 2011 6 min read
