Paul Johnson

Founder at @vldbsolutions.

[Paul Johnson @vldbio]

@lpoolcouncil @LpoolCityRegion I fixed it for you:

“Road closed on Sunday. Do one. Go The Asda instead.”

You’re welcome 🤣

[Paul Johnson @vldbio]

@cloudberrydb @egwada @Greenplum Looking forward to it 🤓

[Paul Johnson @vldbio]

The latest @vldbsolutions blog article covers ‘SQL query splitting’.

Want to know when to use work tables, CTEs or temp tables in your SQL?

Read on 👇👇👇

https://t.co/qSz3KUyImA

#SQL #CTE #WorkTables #KISS #KeepItSimple

[Paul Johnson @vldbio]

Latest ⁦@vldbsolutions⁩ blog post covers ⁦@Greenplum⁩ provisioning using Terraform on AWS & access to data stored in S3.

Enjoy!

#oss #postgres #greenplum #terraform #aws #cloud #s3 https://t.co/O7tY90hEXq

[Paul Johnson @vldbio]

@laurenbalik Can’t wait for SQL & bash to IPO…

[Paul Johnson @vldbio]

Here’s a short video of the world famous Mersey ferry from my commute to the ⁦@vldbsolutions⁩ office in Liverpool this morning.

Enjoy!!! https://t.co/NumYoG1IXW

[Paul Johnson @vldbio]

@TheFarm_Peter Ah! When’s your one!?!?!?!

[Paul Johnson @vldbio]

Latest @vldbsolutions blog post talks about implementing referential integrity (RI) specifically for the MPP-based Data Warehouse use case.

#ri #dri #mpp #analytics #referentialintegrity #dataquality

https://t.co/CRGA7yLtqQ

[Paul Johnson @vldbio]

Terraform Services - Expertly Manage Your Cloud Infrastructure | Data Consulting | VLDB https://t.co/2OhynIot5H

[Paul Johnson @vldbio]

@laurenbalik https://t.co/OxbgUcVD31

[Paul Johnson @vldbio]

@thedataretic @FrankDenneman What he said 👆

[VLDB Solutions @vldbsolutions]

Table Storage options in Greenplum https://t.co/XENFuxZNkI - Check out our new video on Greenplum Table Storage Options! Part of a new series of top data tech tips from VLDB. #greenplum #data #tech #tips

[Paul Johnson @vldbio]

Teradata hardware support is available for several non-EOL models. Teradata system owners can freeze the DBMS version and just pay for 3rd party hardware support. No more enforced DBMS upgrades or costly support & maintenance. #teradata #hardware #support

[Paul Johnson @vldbio]

@GDPRTiger @FCDWhittaker @grumbledook @Schools_ABC @defenddigitalme @libertyhq That’s a million miles better than the DfE template all schools seem to use.

Acid test : give a random teacher their own school privacy notice and see if they can accurately describe where (controllers/processors) their MIS data ends up, why (necessity) and lawful basis.

[Paul Johnson @vldbio]

@GDPRTiger @FCDWhittaker @grumbledook @Schools_ABC @defenddigitalme @libertyhq Agreed. More fundamentally each & every instance of collection, storage and processing of PII needs a separate lawful basis. I’ve yet to see a single privacy notice that a parent/pupil could understand that paints a full, clear picture with each lawful basis laid out.

[Paul Johnson @vldbio]

You lucky folks can now buy Professional Services from @vldbsolutions directly from the AWS Marketplace https://t.co/lWCLYqV703 #aws #awsmarketplace #amazon #datawarehouse #BusinessIntelligence #DataScience #dataengineering #managedservice

[Paul Johnson @vldbio]

@vldbsolutions now offers Managed Services for analytics platforms such as Teradata, Redshift, Snowflake and Greenplum via the AWS Marketplace. Enjoy!

#teradata #snowflake #greenplum #redshift #aws #awsmarketplace #professionalservices

https://t.co/EwJqcR0mb2

[Paul Johnson @vldbio]

@PrivacyMatters @LloydsBank @LBGplc @ICOnews having established that LBG has no contact email address, and that the contact phone number is in fact a staff switchboard, how can I find the contact details for the @LBGplc (*not* @LloydsBank) Data Protection Officer (DPO)?

[Paul Johnson @vldbio]

@PrivacyMatters Having spent 8 years of my career at @LloydsBank I’m finding it impossible to identify the DPO for @LBGplc. The email link on the LBG web site is broken & the enquiries number is a staff switchboard which is no use. Challenge on 🤓 #Lloyds #LloydsBankingGroup #dataprotection

[Paul Johnson @vldbio]

@LloydsBank Ok, the contact number you refer to isn’t a general enquiries number. It’s a staff switchboard. I called it on Friday. It seems that @LBGplc doesn’t want to be contacted 😰