Data loading, with the help of AI

Data loading, with the help of AI

In today’s fast-paced development world, efficiency is paramount. AI can significantly accelerate the coding process, including the creation of scripts to interact with various data formats. This blog post will explore how to use AI assistance to generate Python code for loading a custom XML file.

Gmail Clean-up

Gmail Clean-up

Not so much Data & Database, but useful advice for managing a Gmail account once the storage gets a bit full (and Google suggests paying for storage).

Introducing: Dirty Master Data Management Application

Introducing: Dirty Master Data Management Application

This is a side project of mine, something to keep me out of mischief at home. My aim for this project is to be an example/template/starting point for using flask for a quick (and dirty) approach to a Master Data Management (MDM) application AKA a Data Warehouse Management Application (DWMA).

Dates In SQL Server

Dates In SQL Server

Some time ago what started as one article on dates and their value, turned into a mini-series (nearly as engaging as The Queens Gambit). I kept finding more to say about dates and examples to give. I’m now pulling them together with a little narrative.