Alan Cruickshank - Desiging Overload

SQLFluff Performance in 2023

Most of the focus of getting to 2.0.0 was on accuracy and robustness, however much of the focus since has been on performance and speed. This post is a little peek behind the curtain of how we went about that, and what some of the biggest improvements have been.

sqlfluff

SQLFluff 1.0.0

Today we released SQLFluff 1.0.0, the first stable release of SQLFluff.

diy

Modding a Razer Chroma X

A dive into PCIe and taking a dremel to a Razer eGPU enclosure in search of stable Gigabit Ethernet.

data

Big data doesn't mean it's the right data.

The information you have is not the information you want. The information you want is not the information you have.

data

Analytics is Subjective

Analytics is often viewed as blending gut feel and objective measurement, but the reality of that feels very different.

data

Data Storytellers Podcast

In the last few months of 2021 I was lucky enough to talk to Laszlo Mucsi at the Data Storytellers.

data

Too much visibility?

There is a balance to be played in the role of any person who is responsible for metrics and measurement. How to approach the perennial question: "can you make me a dashboard/report so I can see X".

data

The fable of the number wizard

Once upon a time, there was a company of tailors... and so she drew up a position for a number wizard...

data

Coalesce 2021: this is just the beginning

This year I spoke at the Coalesce 2021 conference about a topic a bit broader than just SQL linting or data in small businesses. I'll likely expand a little on

diy

Lockdown Guitar Building

Stuck in another lockdown I embarked on building a guitar. Things came out pretty well.

sqlfluff

SQLFluff on the Python Podcast

In June, I had a great chat with the team at the Podcast.__init__ (aka the Python Podcast) about linting, SQL and open source projects. Keep Your Analytics Lint Free

sqlfluff

SQLFluff @ Coalesce 2020

The dbt project at tails.com has over 600 models and 66k lines of code. With multiple contributors to a project and varying SQL backgrounds, it's really difficult to maintain consistent readability and comprehension across a codebase like that by hand.

3dprinting

The Zen of Good Cable Management

I already feel less stressed.

3dprinting

Dry-Box for Sensitive Filament

PETG printing badly? Maybe you also need a dry box.

data

Growing Business Analytics on a Shoestring - Part 2

Following on from part 1, we go from getting serious into philosophy as we track our growing analytics function.

data

The Innovation Community Podcast

A few weeks ago I was lucky enough to feature on The Innovation Community Podcast [https://www.theinnovationcommunity.com/]hosted by Paul Capon. We took a rambling tour through life in small businesses and the importance of culture and leadership in data organisations.

data

Why is Data like Bread?

Many people are rediscovering bread, and many organisations are rediscovering data. Both are things that people are devoting considerable time and attention to right now to provide reassurance, grounding and direction in what is otherwise a bewildering time.

design

A logo for sqlfluff

For around a year I've been working on sqlfluff [https://github.com/alanmcruickshank/sqlfluff], a SQL linter to keep up with the growing place of analytics code as a store

diy

Reclaimed Shelves

The Croydon wood recycling centre is a great place, given everyone is locked down during the Covid19 pandemic, it's been a great time to make progress on some home improvement. This project involved... a lot of sanding.

data

DataIQ 100 2020

I was very humbled to be included in the DataIQ 100 for 2020. This is a repost of the bio included in that.

code

Continuous Deployment for Ghost Themes

My journey to upgrading Ghost and setting up continuous deployment for a custom Ghost theme using CircleCi.

code

SQL in 2019

SQL has been around for a long time, as a language for communicating with databases, as a communication protocol. More recently with the rise of data as a business function, or a domain in it's own right SQL has also become an invaluable tool for defining the structure of data.

data

Data from scratch, a blessing or a curse?

In this episode of the Hub and Spoken podcast, I have a chat with Jason Foster at Cynozure, discussing building data functions from scratch in a fast-paced business.

code

Enforcing DBT Dependencies in Snowflake

If you use dbt and Snowflake, we made a dbt package you can use to make sure that you keep your dependencies tidy and understandable.

cnc

CNC Mini Mill: Part 3 - Leadscrews, Leadscrews everywhere...

If one screw doesn't give you the stiffness you want, then why not add some more?

Subscribe to Desiging Overload