Doing IT right the first time
“Premature optimization is the root of all evil” – Knuth One of traditional challenges of Business Intelligence is that the data is Large. Large being the technical term for data
Becoming an AWS Solutions Architect
I just passed my AWS Solutions Architect exam. Here’s what I did to pass the exam… Read the rest on the Optimal BI blog.
Redshift Snapshot Sizes
If you’ve been a database administrator long enough to be good at creating named pipes, like I am, then you have a lot of preconceptions about databases. One of those
Continuous Extract Transform Load (ETL)
Dilbert infamously pointed out, that the internet itself runs in batches. Everything in computers, from TCP to operating systems to databases to the CPUs themselves natively work with batches. Streaming
High Performance, Batch Change Data Capture Processing with Window Functions
Amateur loads of version rows, slowly changing dimension (SCD) type 2, loop through the incoming data one record at a time, like the SCD transform in Microsoft’s SSIS. This works,
RSS - Posts