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
Peter Raganitsch Multi-Language database applications using Oracle Apex It isn't straightforward to design a database application that has to provide text data in several languages. There are several... 03 June 2011 12 min read
Grant Fritchey SQL Server Backup and Restore for the Accidental DBA Not everyone who is tasked with the job of ensuring that databases are backed up, and easily restorable, consider themselves... 24 May 2011 15 min read
Bert Jan van der Steeg Database Management for SharePoint 2010 With each revision, SharePoint becomes more a SQL Server Database application, with everything that implies for planning and deployment. There... 10 May 2011 13 min read
Grant Fritchey Performing DBCC Checks Using SQL Virtual Restore Ever restored a corrupted database from the backup, only to find that the backups are corrupted too - All the... 07 April 2011 8 min read
Feodor Georgiev Database Documentation – Lands of Trolls: Why and How? When database documentation is mentioned in an IT Department, everybody nods wisely, yet everyone does their best to avoid doing... 07 April 2011 12 min read
Joe Celko Check your Digits The most persistent struggle in data processing has been to ensure clean data. There are many ways that data can... 07 April 2011 11 min read
Nick Harrison A Developers’ Guide to Refactoring Databases When Agile meets 'Big Design', the result can be frustration on both sides. Is it possible for database development to... 04 April 2011 15 min read
Troy Hunt The unnecessary evil of the shared development database One of the greatest pain-points in developing a database-driven application happens when the application is in source control,but the database... 23 March 2011 16 min read
Hugo Shebbeare The Polyglot of Databases: How Knowledge of MySQL and Oracle Can Give SQL Server DBAs an Advantage Although switching between different RDBMSs can be the cause of some culture shock for the Database Administrator, it can have... 14 March 2011 16 min read
Fabiano Amorim Lipoaspiration in your SQL Server Database Once, when disk space was at a premium, DBAs fought hard to keep the size of their database down. Now... 03 March 2011 13 min read
Grant Fritchey Change Management and Source Control So, given the many good reasons for using Version Control systems for managing the changes in database applications, how does... 03 March 2011 47 min read
