Louis Davidson

What Counts For a DBA: Simplicity

Too many computer processes do an apparently simple task in a bizarrely complex way. They remind me of a strip...

01 October 2012 5 min read

Wissem El Khlifi

Data Guard Physical Standby Database Best Practices – Part II

In this second part we will setup the standby database and enable Fast Start Fail Over.…

27 September 2012 9 min read

Michael Williamson

Modularity through HTTP

As programmers, we strive for modularity in the code we write. We hope that splitting the problem up makes it...

27 September 2012 4 min read

Joe Celko

Book Review: SQL and Relational Theory by C. J. Date

SQL and Relational Theory, by Chris Date, isn't likely to be a book that SQL's greatest defender, Joe Celko, would...

26 September 2012 10 min read

Brad McGehee

Book Review: SQL Server Hardware by Glenn Berry

Brad finds Glenn Berry's 'SQL Server Hardware' book to be a valuable reference, not so much for the actual hardware...

25 September 2012 9 min read

Seth Delconte

Getting Started With XML Indexes

XML Indexes make a huge difference to the speed of XML queries, as Seth Delconte explains; and demonstrates by running...

25 September 2012 17 min read

Alex Davies

My book is released – Async in C# 5

I’m pleased to announce that my book “Async in C# 5” has been published by O’Reilly! http://oreil.ly/QQBjO3 If you want...

20 September 2012 1 min read

Satishbabu Gunukula

Convert Single Instance to RAC – Part 1: Duplicate DB using RMAN

This article is for users of Oracle Database version 10g+ who want to convert their Oracle single instance database to...

20 September 2012 11 min read

Steve Harville

Migrating a 2TB database to a new operating system with different endianness

I recently moved a 2TB database from Linux, Oracle 11.1 to AIX, Oracle 11.2 using impdp with network_link and parallel...

19 September 2012 1 min read

Ming Lee

Amazon Web Services and managing our EBS volumes effectively

With Amazon Web Services, you might find that a large Amazon Machine Image (AMI) as with over 1 TB, taken...

19 September 2012 8 min read

Glenn Berry

Provisioning a New SQL Server Instance – Part Three

Once you've installed and configured SQL Server 2012, there are some tasks that should be done to ensure that maintenance,...

18 September 2012 12 min read

Laerte Junior

The PoSh DBA: Solutions using PowerShell and SQL Server

PowerShell is worth using when it is the quickest way to providing a solution. For the DBA, it is much...

18 September 2012 15 min read

Grant Fritchey

Getting a Database into Source Control

For any number of reasons, from simple auditing, to change tracking, to automated deployment, to integration with application development processes,...

17 September 2012 4 min read

Joe Celko

Matrix Math in SQL

Relational Databases have tables as data structures, not arrays. This makes it tricky and slow to do matrix operations, but...

17 September 2012 10 min read

Richard Morris

Bertrand Meyer: Geek of the Week

Bertrand Meyer, the author of 'Object-oriented Software Construction', renowned teacher, and designer of the Eiffel programming language, believes in simple...

17 September 2012 13 min read