Blog

I have been tasked with copying select databases from the production SQL server to the Data Warehouse (at least nightly). However, no matter how I try to copy the data over, I run into an issue. Below is our setup: Production Enviroment SQL 2014 Enterprise around 20 TB of data Weekly Full backups, Nightly DiffRead more

I am thinking about a DWH server layout and I’d like to ask you if you can spot any downsides to this layout. The basic idea is to have Staging Area & Data Warehouse DBs and the ETL Tool for the transformation from stg to dwh running on one single machine because of reduced hardwareRead more

I’m trying to find the right Magento table that holds stock or product warehouse or pick location. Thanks in advance.Read more

Caching technologies ( i.e. Memcached, Redis, etc. ) would work very well for applications that retrieve data which Changes rarely. For example, Caching technologies would be great an encyclopedia web application, news websites, etc., because the encyclopedia or news article rarely changes. a) However, would caching technologies help in speeding up work for oltp applicationsRead more