Databases

SQL Server, PostgreSQL, MySQL, Oracle, MongoDB and more – find all database-related Simple Talk content here. Tutorials, guides, opinion, and more.

Image of author: Annette Allen

SSIS Basics: Using the Conditional Split

The Conditional Split can route data rows to different outputs depending on whatever criteria of the data that you wish....

28 January 2013 12 min read

Image of author: Seth Delconte

Precision Indexing: Basics of Selective XML Indexes in SQL Server 2012

Seldom has a SQL Server Service pack had such an effect on database development as when SQL Server 2012 SP1...

25 January 2013 14 min read

Compression in Oracle – Part 2: Read-Only Data

In part one of this series we saw that the mechanics of basic table compression came in to play only...

24 January 2013 13 min read

HAVING Cardinality

When performing aggregate GROUP BY operations an additional filter on the aggregates can be applied using the HAVING clause. Usually aggregates are one of...

21 January 2013 2 min read

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

Database Administration

Image of author: Gail Shaw

Gail Shaw in Database Administration

SQL Server Won’t Start: Causes, Errors, and Fixes

SQL Server won't start? This guide covers the most common causes: incorrect service account password, missing or corrupt master/model/TempDB database...

17 January 2013 30 min read

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

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

Image of author: Joe Celko

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

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

Image of author: Feodor Georgiev

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

Image of author: 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

Image of author: 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

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

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

Image of author: 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

Image of author: Kellyn Pot'Vin-Gorman

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

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

Image of author: 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