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
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
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
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
Richard Morris Jeff Moden: DBA of the Day Jeff Moden's election to the Exceptional DBA of the Year award for 2011 was a popular one. Although all the... 24 November 2011 17 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
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
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
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
Jaap Wesselius Recover a Mailbox Server in A Database Availability Group (DAG) When one mailbox server in a Database Availability Group (DAG) is accidentally deleted, then it is supposedly easy to fix... 10 October 2011 4 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
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
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
Joe Celko Mimicking Magnetic Tape in SQL The sequential nature of early data storage devices such as punched card and magnetic tape once forced programmers to devise... 17 August 2011 10 min read
Grant Fritchey Preventing Problems in SQL Server It is never a good idea to let your users be the ones to tell you of database server outages.... 15 August 2011 9 min read
Patrick Barel Working with Table Functions in PL/SQL Table functions are functions that produce a collection or rows (either a nested table or a varray) that can be... 20 July 2011 2 min read
Laerte Junior PowerShell Eventing and SQL Server Restores When you're managing a large number of servers, it makes no sense to run maintenance tasks one at a time,... 05 July 2011 13 min read
Alex Kuznetsov Yet Another SQL Strategy for Versioned Data There is a popular design for a database that requires a built-in audit-trail of amendments and additions, where data is... 22 June 2011 11 min read
David Njoku Readying your Oracle Database for Your First Apex Application APEX can be a great way to create an application rapidly on an Oracle Database. Although it is generally straightforward,... 14 June 2011 9 min read
Joe Celko A Tale of Identifiers Identifiers aren't locators, and they aren't pointers or links either. They are a logical concept in a relational database, and,... 09 June 2011 14 min read
