TSPITR Using ACFS Snapshots

Starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster File System in cluster environment) supports database...

10 August 2015 16 min read

Robert Sheldon

The Evolution of SQL Server BI

It is sometimes hard to keep up with Microsoft's direction in Business Intelligence. Over the years, we've been presented with...

27 July 2015 14 min read

Anju Garg

Integrating ACFS Snapshots With RMAN

In my last article, I demonstrated that starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster...

14 July 2015 10 min read

Jonathan Lewis

Basics of the Cost Based Optimizer – Part 4

In the first three installments of this series I outlined the mechanisms used by Oracle to analyze a very simple...

09 July 2015 14 min read

Satishbabu Gunukula

Why Virtual Private Catalog?

Recovery Manager (RMAN) is the preferred tool to backup and recover the Oracle Database. You can use recovery catalog or...

08 July 2015 8 min read

David Njoku

Anatomy Of A SELECT Statement – Part 3: Recursive Subquery Factoring

We need a baritone voiceover man. You know how those huge TV shows – 24, Prison Break, Jane the Virgin...

07 July 2015 7 min read

Ravi Kumar

Upgrading A Database Using Recovery Manager (RMAN) Duplicate Command In Oracle 12c

Introduction For versions of Oracle 11g R2, Oracle Recovery Manager (RMAN) replicates a database to a different Oracle home and...

03 July 2015 12 min read

Anju Garg

12c: Database Backups Using ACFS Snapshots

Starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster File System in cluster environment ) supports...

29 June 2015 11 min read

Jonathan Lewis

Basics of the Cost Based Optimizer – Part 3

In the second installment of this series we looked at individual access paths for the tables in a simple join...

25 June 2015 14 min read

Robert Sheldon

How to Get NULLs Horribly Wrong in SQL Server

NULLs in SQL are a mixed blessing. The Three-Valued Logic of SQL has its uses but can cause difficulties to...

25 June 2015 36 min read

Jonathan Lewis

Basics of the Cost Based Optimizer – Part 2

In the first installment of this series I gave an informal description of how the optimizer would consider the possibilities...

17 June 2015 15 min read

David Njoku

Anatomy Of A SELECT Statement – Part 2: The Hierarchical Query Clause

My wife and I just welcomed our first child to the world. No, there’s no need to congratulate me; as...

16 June 2015 5 min read

Feodor Georgiev

Getting to know your customers better – cohort analysis and RFM segmentation in R

It often pays to use a tool like R, in conjunction with a relational database, to quickly perform a range...

12 June 2015 14 min read

Jonathan Lewis

Basics of the Cost Based Optimizer – Part 1

This series on Oracle’s Cost Based Optimizer is aimed at the less experienced DBAs and developers to help them understand...

10 June 2015 15 min read

Feodor Georgiev

Using R to Explore Data by Analysis – for SQL Professionals

What's the best way for a SQL programmer to learn about R? It's probably by trying out various experiments with...

02 June 2015 17 min read

Adam Aspin

SQLXML Bulk Loader Basics

SQLXML isn't exactly new technology, but like the even more venerable BCP, it remains the quickest and most reliable way...

02 June 2015 26 min read

Alex Kuznetsov

Reusing T-SQL Code

Database programmers are often caught in the paradox of wanting to implement business rules and complex functionality in one place...

28 May 2015 27 min read

Robert Sheldon

SQL Server Dates and Times: Ten Common Failures from DATETIME to DATEDIFF

Ten common failures developers make with SQL Server date and time handling: DATETIME vs DATETIME2 precision, string-format assumptions, regional date...

28 May 2015 35 min read

Anju Garg

Oracle ASMFD: Migrate from ASMLIB to ASM Filter Driver

Migrate Oracle ASM storage from ASMLIB to Oracle ASMFD (ASM Filter Driver) in Oracle 12.1.0.2+. Complete step-by-step: verify ASMLIB, label...

22 May 2015 17 min read

Dwain Camps

Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008

Percentiles give meaning to measurements by telling you the percentage of the population being measured who get higher or lower...

18 May 2015 27 min read

Register for Simple Talk

Databases

TSPITR Using ACFS Snapshots

The Evolution of SQL Server BI

Integrating ACFS Snapshots With RMAN

Basics of the Cost Based Optimizer – Part 4

Why Virtual Private Catalog?

Anatomy Of A SELECT Statement – Part 3: Recursive Subquery Factoring

Upgrading A Database Using Recovery Manager (RMAN) Duplicate Command In Oracle 12c

12c: Database Backups Using ACFS Snapshots

Basics of the Cost Based Optimizer – Part 3

How to Get NULLs Horribly Wrong in SQL Server

Basics of the Cost Based Optimizer – Part 2

Anatomy Of A SELECT Statement – Part 2: The Hierarchical Query Clause

Getting to know your customers better – cohort analysis and RFM segmentation in R

Basics of the Cost Based Optimizer – Part 1

Using R to Explore Data by Analysis – for SQL Professionals

SQLXML Bulk Loader Basics

Reusing T-SQL Code

SQL Server Dates and Times: Ten Common Failures from DATETIME to DATEDIFF

Oracle ASMFD: Migrate from ASMLIB to ASM Filter Driver

Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008