Blog

What do you do when you’re one of the global leaders in the beauty industry and your growing data environment is getting out of control? You set up a call with DB Best and start to speak with one of our dedicated Project Managers. We began with just a single developer working with this customer but very soon it grew to include an additional 13. After 5 years, what started as a data environment analysis has grown to a full […]

The key to an effective marketing campaign lies in the ability to make timely adjustments based on results. When one of our customers came to us saying that it took one month to analyze campaign results, they asked us to work with them to build a new business intelligence solution for marketing automation. Our customer, a public Fortune 1000 services company, provides residential and commercial services. With nearly a century of experience, eight well-known brands, and over 7,000 company-owned and franchise […]

One of our customers, a major software provider in construction, agriculture, and geospatial industries, has one of the leading solutions for building design and building information modeling (BIM). Just think about the complexity of designing a building and the complexities of designing, fabricating, and installing air ducts, plumbing, electrical wiring, etc. In order to improve the software for their customers, their software product that we’ll call “BIM-APP” tracks all the user interactions and any system errors to log files. The […]

Our customer has been supporting Oracle based online transaction processing (OLTP) system. They decided to take advantage of the modern data analysis capabilities of SQL Server’s data warehouse features including columnstore for greater value over an Oracle based data warehouse solution. We came up with a comprehensive solution on extracting and transforming their source data and loading it into the target database. As a result, our customer benefited from obtaining a highly standardized and easily manageable solution within a short […]

One of the largest North American agricultural enterprises has been envisioning and designing a new cloud-based Business Intelligence and Data Warehousing architecture. They were using a fragmented system, based on Oracle database, while the reports were presented as a mix of SQL Server Reporting Services (SSRS) and Excel dashboards. We came up with a solution that allowed to consolidate all reports with Power BI dashboards. In addition, we proposed to migrate the original database to Azure Synapse Analytics (previously Azure […]

Back in March of 2015, DB Best published a blog post on how to embed Power BI Power View interactive reports into your blogs and websites. Much has changed in Power BI since then and Microsoft has made it possible to easily embed reports into your blog articles. There are now two basic options for embedding reports. Power BI Embedded is a service on Azure for publishing Power BI visuals and uses authentication to make sure users can see the […]

When a company grows, it’s no surprise that their database stored data grows as well. This is the case for all companies, and our customer, a global retailer in the beauty industry, was no exception. While working on this project, we managed to increase the average speed of query execution by 30x, saved up to 190 GB of memory and freed up 28 GB of disk storage space. Prior to these great results, there was a hard optimization process performed […]

DB Best recently completed a complex development project for one of the largest banks in the Middle East. Faced with non-customizable and slow-to-generate reporting, the customer contacted DB Best to develop a new and improved solution. The customer’s original system was built on two SQL Server Analysis Services systems, each containing large amounts of various aggregated data types with Excel workbooks directly accessing the two SSAS cubes. Not only did this system take a considerable amount of time to generate […]

DBMSys is a lightweight tool designed by DB Best specifically around collecting data from multiple environments to help develop a business case for a modernization to upgrade path. The Microsoft MAP Toolkit is good for scanning systems and providing a snapshot of some system metrics, but doesn’t provide data over time to understand peak workload requirements and storage capacity needs. DBMSys turns monitoring on its head. Not only does DBMSys help with monitoring your environment for capacity needs, it provides […]

The Internet of Things (IoT) is constantly expanding, and the data being transmitted through it grows immensely along with the network. This is why previous and regular methods of data management can’t cope with the growing needs.