The case for "Understanding our business" training
Today we have a guest editorial reminding us that business knowledge is important, and we could all use some training.
2025-11-19
134 reads
David Poole
- Interests: Badminton, Cycling and Music. Keen piano player.
Why Standards are Important
There is something in the tech mindset that simultaneously loves and loathes a standard. Having standards is important, what those standards are is less so.
2025-01-22
2,338 reads
An introduction to Terraform
As a Data Engineer I found myself having to learn rather more about cloud infrastructure than I had expected.
2024-12-02
3,640 reads
NOSQL and RDBMSs
NOSQL and RDBMS are evolving and absorbing ideas from each other. Is this necessarily a good thing? Perhaps we should think again
2024-06-14 (first published: 2015-08-27)
868 reads
JQ - Tool for Querying JSON documents using the CLI
Learn how you can query JSON data from a CLI to check it before importing the data into a database.
2024-02-16
8,210 reads
Managing Change
Time has brought clarity for changes which could and should have been provided by its instigators. We compare a change where clarity was sought to those that were chaotic and the approaches that were taken at their two poles.
2023-08-16
1,483 reads
Using pre-commit to prevent simple mistakes
Git hooks are a useful way of triggering code quality scripts. The pre-commit tool provides us with a way of doing this and tapping into the huge library of scripts already in existence to ensure our code complies with general linting and formatting good practice.
2023-01-13
6,443 reads
Design your systems and processes for auditability
I have worked in more than one regulated industry, and since the banking crisis of 2008, I have witnessed a sea change in the approach to regulation. The UK Financial Services Authority (FSA) was seen to be a toothless tiger. The UK government replaced the FSA with two separate bodies, each with its own more […]
2021-10-25
1,582 reads
PostGres and SQL Server - Divided by a common language
A few lessons from a SQL Server DBA that is working on PostgreSQL. David Poole tells us where the similarities in the platforms can cause problems.
2021-07-30
4,073 reads
Documentation. The Under Recognised Skill
Documentation may not be something we aspire to do, but it is a valuable skill.
2021-04-30
426 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers