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”
Monthly Archives: mars 2021
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)”
Norwegian 
English