Tech reviews

Here you will find a set of articles we have written in order to take a closer look at the different challenges and possibilities we see with current technologies, which hopefully will help you better understand how we approach these technology challenges.

Backend Integration strategy

Extract transform load (ETL) ETL has for long been the preferred way of doing batch data integrations. The reason for this is that the ETL method where the data is extracted from the source and transformed in memory before loaded into the target, is a genius way of processing data as long as the dataContinue reading “Backend Integration strategy“

Snowflake review

Snowflake has taken the cloud analytic storage and compute market by storm and for a good reason. The time to market, simplicity and cheap storage is all appealing when it comes to choosing your storage and compute engine for analytics. In this review we will dive a little deeper into the software and what itContinue reading “Snowflake review“


A data lake is nothing more than a file system used as a common data sharing platform. The idea is that the data should be easily available and have a short way from it source to the consumer end. Unlike a relational database, it does not matter what format the data is in or howContinue reading “Data Lake“

The Troublesome Heaps

Heap fragmentation is the degree of “out of order extents” and are given by avg_fragmentation_in_percent in sys.dm_db_index_physical_stats. This means that when SQL server allocate pages in bulks of 8 pages per bulk that is called extents. Each page gets a page number and is ordered in the IAM. When a row gets written to aContinue reading “The Troublesome Heaps“

Always truncate your staging environment in a database

Often when we are met by customers struggling with performance, we see staging environments that are existing more or less as an archive or a copy of the source. Its uncertain why a staging environment is so often handled this way, but it may be a misunderstanding originating from some non-technical reference books like “Kimball’sContinue reading “Always truncate your staging environment in a database“

Business Motivation Model (BMM)

The Business Motivation Model is a well-known model for most Enterprise Architects and are frequently used in multiple business around the world, often together with targeted business consulting or as a part more extensive frameworks like Togaf. Working with Business Motivation Model in multiple divisions and levels of the organization help you to align yourContinue reading “Business Motivation Model (BMM)“

%d bloggere liker dette: