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,315 reads
David Poole
- Interests: Badminton, Cycling and Music. Keen piano player.
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,574 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
7,960 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,479 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,335 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,576 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,058 reads
Soft Skills: Controlling your career
Technical skills come and go while soft skills will serve you throughout your life. They will have the greatest influence over your career, job and role. For some people soft skills come naturally. As an Aspergers person (Aspie) I have to practice my soft skills at every opportunity. Pure techies need not lose hope. Soft […]
2021-04-23 (first published: 2019-09-19)
6,611 reads
Re-oiling the gears for the data dictionary or catalog
Documentation is never a favorite task for developers. This article describes how you can use database system catalogs to make generating column descriptions less labor-intensive and also jump start a data dictionary or catalog.
2020-01-14
3,782 reads
Vagrant and SQL Server 2017 on Linux
Vagrant provides a mechanism to build and configure a virtual Linux box running SQL Server 2017
2019-08-16 (first published: 2017-11-14)
5,424 reads
Blogs
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Data Conferences – Worth Every Dollar
By Kevin3NF
Some of the best career enhancers you can buy. Why I Go to...
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
Forums
SQL 2022 stuck on xp_delete_file
SQL 2022 hangs on xp_delete_file, it works for a while when sever is rebooted...
Getting the Object Code
Comments posted to this topic are about the item Getting the Object Code
Question of the Day
Getting the Object Code
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers