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
Peter Larsson The Road to Professional Database Development: Set-Based Thinking Under the pseudonym of 'SwePeso', Peter Larsson is famous on SQL forums for the amazing performance he can get from... 21 February 2012 7 min read
Jonathan Lewis Session SQL From time to time a request for a query to “show the current SQL” for each session appears on the... 17 February 2012 1 min read
Feodor Georgiev Exploring SSIS Architecture and Execution History Through Scripting When you are using SSIS, there soon comes a time when you are confronted with having to do a tricky... 16 February 2012 12 min read
Dimitri Gielis E-Business Suite and APEX There is a series of posts on my blog where I focussed on getting information out of E-Business Suite and use it... 15 February 2012 1 min read
Randolf Geist Dynamic Sampling (I), an Introduction – Part 2 If you follow me on my blog you might wonder if I let you get away without an actual test... 08 February 2012 8 min read
Steve Harville Migrating databases to new storage This was a last minute request to move five databases on two servers from an old failing storage system to... 06 February 2012 2 min read
Phil Factor Automated Script-generation with Powershell and SMO In the first of a series of articles on automating the process of building, modifying and copying SQL Server databases,... 03 February 2012 24 min read
Dave Green Using SQL Test Database Unit Testing with TeamCity Continuous Integration With database applications, the process of test and integration can be frustratingly slow because so much of it is based... 02 February 2012 22 min read
Robert Sheldon Converting String Data to XML and XML to String Data We all appreciate that, in general, XML documents or fragments are held in strings as text markup. In SQL Server,... 01 February 2012 18 min read
Randolf Geist Dynamic Sampling (I), an Introduction – Part 1 Welcome to my first post on AllThingsOracle.com! This is the initial part of a series highlighting different aspects of “Dynamic Sampling”.... 30 January 2012 7 min read
