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.

How to move tables, indexes and partitions to a different tablespace in Oracle

How to move tables, indexes and partitions to a different tablespace in Oracle

I had a case where I needed to move objects to a new tablespace, quite a few objects. As there was a lot of objects (tables, indexes and partitions) I decided to automate the code creation from the database metadata. Moving Objects To A New Tablespace The first thing to understand is how to move…

Read More Read More