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 How to Get SQL Server Dates and Times Horribly Wrong One of the times that you need things to go right is when you are doing analysis and reporting. This... 28 May 2015 35 min read
Anju Garg Oracle Automatic Storage Management Filter Driver (Oracle ASMFD) Prior to Oracle Grid Infrastructure (GI) release 12.1.0.2, ASM Library (ASMLIB) was the only method to access storage devices by... 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
David Njoku Anatomy of a SELECT Statement – Part 1: The WITH Clause Come, young one. Come sit by the open fire; hold your cold hands to its warmth. Let me tell you... 11 May 2015 8 min read
Dennes Torres Optimizing Batch Process in SQL Server SQL Server batch processes are usually run from SQL Agent in background. They can take significant time and resources, especially... 08 May 2015 32 min read
Phil Factor Documenting your SQL Server Database One of the shocks that a developer can get when starting to program in T-SQL is that there is no... 06 May 2015 27 min read
Aman Sharma GoldenGate – An introduction In the last few years, GoldenGate has become the preferred choice for DBAs to handle the replication requirement of their... 30 April 2015 11 min read
Robert Sheldon How to Get SQL Server Security Horribly Wrong It is no good doing some or most of the aspects of SQL Server security right. You have to get... 29 April 2015 24 min read
Feodor Georgiev Making Data Analytics Simpler: SQL Server and R R and SQL Server are a match made in heaven. You don't need anything special to get started beyond the... 28 April 2015 13 min read
