The Exploration of Programming Languages – Standards of a Coder

Having been involved in IT for 30 years I have often been left bemused by the standards used by some programmers and sometimes imposed by programming languages. I started on Cobol. There were strict naming standards for file division, working storage and linkage section variables so you knew what you …

30 Years In IT…You’d get Less for Murder!

A few weeks ago marked 30 years since yours truly started out as a graduate IT trainee at Royal Insurance (now RSA) in 1988. Back then, there were no PCs, just dumb terminals; no mobile phones, just landlines; no email, no internet. But the biggest shock of all: other people …

PostgresConf 2018 Musings

Yours truly attended the Postgres Conf in Jersey City last week with my esteemed colleague Richard Jackson. It was quite a blast, to say the least…apart from not getting home until late Saturday afternoon. Ho hum. PostgresConf 2018, Jersey City, USA PostgreSQL Re-Cap PostgreSQL, or Postgres for short, is an open source …

An Introduction to Primary Indexes and Distribution Keys

It’s All About Data Distribution. As experts in Massively Parallel Processing (MPP), here at VLDB Solutions we talk regularly about ‘Primary Indexes’ (PI) or ‘Distribution Keys’ (DK). They are integral to the architecture of both Teradata and Greenplum respectively, and the correct identification and employment of them is ‘key’ to …

Microsoft Azure SQL Data Warehouse

SQL Data Warehouse The promise of “An elastic data warehouse-as-a-service with enterprise-class features” really got my interest when it came up on a LinkedIn post recently. How could it not, really!?!?!  What Does SQL Data Warehouse Offer? Let’s take each of the seven bullet points in turn… 1) “Petabyte Scale …

Data Warehouse Application Migration

Data Warehouse Application Migration The last 12 months or so has seen a lot of ‘Big Data’ POCs being initiated in our world. The most frequent objective from both the customer side and the Hadoop vendors that we talk to seems to be ‘data warehouse application migration’ or ‘offloading’. So …