Robert Young Relational Databases and Solid State Memory: An Opportunity Squandered? The relational model was devised long before computer hardware was able to deliver an RDBMS that could deliver a fully... 17 January 2012 6 min read
David Njoku Introduction to Materialized Views: Query Rewrite In the fairy tale, The Shoemaker and The Elves, a poor cobbler works to the best of his ability; and... 10 January 2012 5 min read
Alex Kuznetsov Close Those Loopholes: Lessons learned from Unit Testing T-SQL Alex has done some pioneering work on the testing of stored procedures over four years, and has learned a great... 09 January 2012 23 min read
Gert Poel Using a database link with heterogeneous services in APEX Last weeks I ran into some issues with APEX, so let’s take some time to write something about them. The... 05 January 2012 1 min read
Fabiano Amorim Window Functions in SQL Server: Part 3: Questions of Performance A SQL expression may look elegant on the page but it is only valuable if its performance is good. Do... 04 January 2012 12 min read
Robert Sheldon Incorporating XML into your Database Objects XML data can become a full participant in a SQL Server Database, and can be used in views, functions, check... 04 January 2012 14 min read
Cary Millsap The Ramp I love stories about performance problems. Recently, my friend Debra Lilley sent me this one: I went to see a... 20 December 2011 2 min read
Martin Giffy DSouza Expert Oracle Application Express Plugins One of the most anticipated new features that was introduced in APEX 4.0 was the ability to create your own... 15 December 2011 2 min read
Sam Bendayan Constraints and the Test-Driven Database Bad data always seems to appear when, and where, one least expects it. Sam explains the great value of a... 14 December 2011 13 min read
Feodor Georgiev Administrating SQL Server Integration Services – Planning, Documenting and Troubleshooting SQL Server Integration Services is an essential component of SQL Server, and designed to perform a variety of routine and... 12 December 2011 15 min read
Jonathan Kehayias Great SQL Server Debates: Lock Pages in Memory There has been much debate over the need for the Lock Pages in Memory privilege, on 64-bit versions of SQL... 12 December 2011 19 min read
Jeff Smith Simple Bar Chart Reports with SQL Developer There are many good articles out there that go into detail for creating reports with Oracle SQL Developer. I was... 09 December 2011 2 min read
Patrick Barel Invoker Rights Part 1 Truth suffers from too much analysis. Frank Herbert In the Oracle database you have a choice of two models for... 08 December 2011 4 min read
Robert Sheldon The XML Methods in SQL Server The XML Data type has definite uses, but the way of interrogating, retrieving, and manipulating the values of properties and... 08 December 2011 22 min read
Grant Fritchey Backup Verification: Tips for Database Backup Testing A Backup system is merely part of a recovery system. If your backups can't be used to recover the database,... 06 December 2011 4 min read
Grant Fritchey Faster Restores: Best Practices to Increase Speed Backups are an everyday part of DBA life, whereas restores tend to happen on call at 3 a.m. In this... 02 December 2011 5 min read
Database Administration Grant Fritchey in Database Administration Grant Fritchey’s SQL Server Howlers We decided to ask various well-known SQL Server people to write about their favourite SQL Server Howlers. These are the... 30 November 2011 16 min read
Fabiano Amorim Window Functions in SQL Server: Part 2-The Frame Fabiano continues his introduction to SQL Server's implementation of the window functions by giving a history of what got implemented... 24 November 2011 13 min read
David Njoku How to make comments the most important ‘code’ you write 80% of all communication, it is often said, is nonverbal. The actual percentage is disputed – with experts quoting figures... 23 November 2011 9 min read
Greg Larsen SQL Server Database Growth and Autogrowth Settings It's easy to create a database nowadays with point-'n-click, but if you've left your database's autogrowth settings at their default,... 23 November 2011 19 min read
