Expanding AlwaysOn Availability Groups with Replication Subscribers

High Availability (HA) and Disaster Recovery (DR) can be provided for subscription databases from an AlwaysOn Avaliability Group, but the...

18 January 2013 8 min read

Gail Shaw

The SQL Server Instance That Will not Start

Everyone's SQL Server nightmare: The instance will not start. If such a problem strikes you, keep calm, follow Gail's advice,...

17 January 2013 29 min read

Jonathan Lewis

Compression in Oracle – Part 1: Basic Table Compression

In this short series on compression in Oracle, we will be looking at the various types of compression used by...

15 January 2013 12 min read

Warwick Rudd

Expanding AlwaysOn Availability Groups with Replication Publishers

SQL Server 2012 AlwaysOn Availability Groups provide a high-availability and disaster-recovery solution for you SQL Server 2012 environments. Replication has...

14 January 2013 9 min read

Joe Celko

UNIQUE Constraints in SQL

Here is an in-depth look at an underused constraint, UNIQUE, that can increase the performance of queries and protect data...

10 January 2013 22 min read

Patrick Barel

Custom Authentication in APEX

Trust is a great force multiplier. – Tom Ridge When you build a web application you have two choices for...

09 January 2013 6 min read

Feodor Georgiev

HDDs, SSDs and Database Considerations

In this article Feodor clears up a few myths about storage, explains the difference in how HDDs and SSDs work...

09 January 2013 11 min read

Grant Fritchey

Statistics in SQL Server

SQL Server's Query Optimiser relies on statistics for providing a decent query plan. If the statistics are wrong, outdated or...

08 January 2013 10 min read

Robert Sheldon

Handling Errors in SQL Server 2012

The error handling of SQL Server has always been somewhat mysterious. Now at last, the THROW statement has been included...

03 January 2013 10 min read

Steve Harville

Automating and delegating datapump imports with PL/SQL

We recently bought another company and we are in the process of integrating our systems with theirs. One requirement was...

20 December 2012 2 min read

Marco Gralike

Solving VMware network problems on Linux VMware guests

When you use VMware Server software to move or clone VMware Linux guest machines, you are asked by the VMware...

19 December 2012 1 min read

Fabiano Amorim

Hypothetical Indexes on SQL Server

Sometimes, you have to test out alternative indexing strategies, but the task of creating the candidate indexes would just take...

18 December 2012 8 min read

Kellyn Pot'Vin-Gorman

Enterprise Manager Command Line Interface for EM12c

This video is a follow up to the webinar broadcast by Red Gate on 12 December 2012. Please leave a...

14 December 2012 2 min read

Wissem El Khlifi

11g Sql Plan Management

I have recently published an article about SQL Plan Management and some of its capabilities in 11g version of the...

10 December 2012 1 min read

Jonathan Lewis

Statistics in Oracle and SQL Server

This video is a follow up to the webinar broadcast by Red Gate on 12 December 2012. Please leave a...

10 December 2012 2 min read

Grant Fritchey

SQL Server Backup Questions We Were Too Shy to Ask

During presentations about doing database backups and restores, there seem to be two types of questions that are commonly asked...

07 December 2012 20 min read

William Brewer

Disaster Recovery Planning for Data: The Cribsheet

Planning for disaster recovery and business continuity aren't amongst the most exciting IT activities. They are, however, essential and relevant...

07 December 2012 13 min read

Jan Leers

Code Instrumentation

Whenever we execute a procedure, it’s out of our hands. We expect it to do what it was designed to...

04 December 2012 5 min read