Databases Archives

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

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

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

SQL Server

Dennes Torres in SQL Server

Send SQL Server query results to Excel through email

Dennes Torres explains how to send SQL Server query results to Excel. It seems easy, but there is a catch!…

01 June 2015 3 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

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

T-SQL Programming

Dennes Torres in T-SQL Programming

SQL Server Batch Process Optimization: Auto-Growth, Locks, Log Flushes, and Index Fragmentation

Step-by-step performance tuning of a SQL Server batch process - identifying and fixing auto-growth events, lock contention, WRITELOG waits, index...

08 May 2015 33 min read

Phil Factor

Documenting a SQL Server Database: Extended Properties, YAML Headers, and Publishing Strategies

Comprehensive guide to documenting a SQL Server database: where to keep documentation, what standards exist (XML, JSON, YAML), how to...

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

Anju Garg

Oracle Multitenant: Convert single instance PDB to RAC by plugging it into a RAC CDB

Prior to oracle database 12c, the procedures for converting from single-instance databases to Real Application Clusters involved following steps: Configure...

22 April 2015 11 min read

Dwain Camps

Time Slots – An Essential Extension to Calendar Tables

After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges,...

22 April 2015 24 min read

David Njoku

In Defence of Triggers

Database triggers. If you have spent any length of time within the Oracle development circle you might have noticed something...

15 April 2015 5 min read

Adam Aspin

Mobile BI with SQL Server Reporting Services

For users to get the information they need from mobile reports, we frequently have to tailor the way we design...

15 April 2015 30 min read