info@lasmart.biz

CPU load optimisation

may 31, 2024 CPU load optimisation In our practice there was a case when incorrectly set parameter resulted in 8% increase of request waiting time, while correct setting increased OLTP requests performance by 10%. In this article we will consider the max worker threads parameter. Parameter definition This parameter is responsible for the size of […]

The importance of a properly drafted ToR

may 15, 2024 The importance of a properly drafted ToR The Terms of Reference (ToR) is a key document that determines the success of any project. Regardless of the scope and specifics of the project being developed, a properly drafted TOR plays a crucial role in achieving the desired result. In this article, we will […]

Algorithm for calculating the required computational resources for data processing in Kylin

april 21, 2024 Algorithm for calculating the required computational resources for data processing in Kylin Apache Kylin is a distributed repository of precomputed and aggregated data for complex analyses, that is, operational analytical processing (OLAP) cubes. The data pre-aggregation process is performed after initiating a request to build a cube segment that generates a Spark […]

Optimizing SQL Server Disk Space Queries

march 28, 2024 Optimizing SQL Server Disk Space Queries Introduction Managing disk space is key for keeping SQL Server up and running smoothly. How fast and stable your database is can really depend on how many times it’s hitting the disk and how much free space you’ve got in your storage. In this piece, we’re […]

Parallelism settings for query optimization in SQL Server

march 13, 2024 Parallelism settings for query optimization in SQL Server Introduction In our practice, users often need to process a large amount of data. At the same time, the time for data processing is most often limited. SQL Server has a large number of options that affect the parameters of query execution. In this […]

Working with eMondrian

february 28, 2024 Working with eMondrian Introduction eMondrian is a free and open source OLAP server based on the Mondrian project. The OLAP server represents the database as a multidimensional space with dimensions, which allows you to hide the complexity of the underlying tables and their relationships, and allows you to interactively analyse data from […]

7 Open Source and 2 low-code solutions for BI-analytics visualization

february 10, 2024 7 Open Source and 2 low-code solutions for BI-analytics visualization In this article, we decided to share our knowledge about building analytical dashboards using 9 different no-code solutions: we will give a brief description, tell you about the advantages and disadvantages of each solution.  The first part will cover such open-source solutions […]

Code versioning and releases for MSSQL

january 30, 2024 Code versioning and releases for MSSQL Git version control systems are essential for large-scale development projects — they provide a toolkit for tracking and managing changes to program code created by multiple developers in parallel. One such tool is Bitbucket, a code versioning tool from Atlassian. To organize SQL code versioning, Microsoft […]

Comparison of data visualization tools

january 15, 2024 Comparison of data visualization tools Nowadays, the choice of visualization tools is very relevant. A visualization tool is a technology that interprets data from a source into visual content (tables, graphs, dashboards), helping to create analytical and informative summaries of events or projects. Every analytical or monitoring system cannot do without a […]