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

Grahaeme Ross

Understanding Cross-Database Transactions in SQL Server

Microsoft 'Always On' technology does not support distributed or cross-database transactions. Why not? Grahaeme Ross shows how to investigate cross-database...

11 April 2015 19 min read

Phil Factor

Schema-Based Access Control for SQL Server Databases

Access-control within the database is important for the security of data, but it should be simple to implement. It is...

09 April 2015 25 min read

Anju Garg

Oracle Multitenant : Super-fast Provisioning of Standby Databases

In this article, I will demonstrate how to quickly create a standby database for a non-multitenant container database (NCDB) by...

07 April 2015 8 min read

Robert Sheldon

How to Get SQL Server Data-Conversion Horribly Wrong

One of the most certain ways of going wrong with any relational database is to get data conversion wrong. Implicit...

02 April 2015 34 min read

Joshua Feierman

How DBAs Can Adopt the Craftsman Mindset

The job of a DBA requires a fusion of skill and knowledge. To acquire this requires a craftsman mindset. Craftsmen...

01 April 2015 16 min read

Jonathan Lewis

Execution Plans Part 14: SQL Monitoring

This is the last part of my series on Execution plans, and features an option which is only available if...

26 March 2015 14 min read

Alex Kuznetsov

Painless Refactoring of SQL Server Database Objects

Refactoring a database object can often cause unexpected behavior in the code that accesses that object. In this article, adapted...

26 March 2015 25 min read

Fabiano Amorim

Never Ignore a Sort Warning in SQL Server

It is always bad news if your SQL queries are having to use the SORT operator. It is worse news...

18 March 2015 9 min read

Roy Ernest

SQL Server Spatial Indexes

Spatial Data in SQL Server has special indexing because it has to perform specialised functions. It is able, for example,...

18 March 2015 20 min read

David Njoku

The Problem With Triggers

Feeling brave? Enjoy danger? Well, I dare you to walk into a room full of Oracle experts wearing an I...

16 March 2015 5 min read