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)”