General Database Posts
For those of use who like to learn and experiment, sample data is a must.
In this post, I’m linking to and summarising some sample data sets which are shared with licenses allowing people to use and reuse them with a lot of freedom.
I was asked by a friend to work some magic with PostgreSQL hosted in GCP. He had inherited a system with some gaps in documentation and most importantly admin passwords.
If you only want to run something quickly, you probably want an online platform that provides a convenient environment for writing, executing, and sharing SQL queries. Here I compare some for use with Oracle SQL & PL/SQL
An approach for creating a dbt demo project which can be shared and run easily by any developer. From an empty directory, to dbt run in under 5 minutes.
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).
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.
View each tablespace in oracle and the amount of allocated disk space used.
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…
I found a scenario where I wanted to identify groups of consecutive dates over a larger date range.
Most of us are familiar with the LIKE command in SQL Server (and other DBMS environments), but few venture beyond simple text matching and the ‘%’ wildcard. It’s ability to use some regular expression (a.k.a. regex or regexp) syntax is a surprise to many. For this article, I’m assuming that readers have already used the…