SQL Server licensing
Server consolidation and virtualization for optimizing SQL Server licensing expenses
28 Nov 2018

One of the leading US agricultural suppliers wanted to upgrade their SQL Server system in order to reduce their overall SQL Server licensing expenses. We performed a thorough financial and technical analysis of their existing OLTP and BI/OLAP database system, and provided a number of optimization suggestions. In addition, we delivered a modernization roadmap to give the customer an idea of potential future plans. Discover how we approached this project from the following video. Complex customer’s system Before our customer turned to us, they consolidated a number of their SQL Server instances. So, when we started the project, their system i...

Building Microsoft Access modernization roadmap
Developing Access modernization roadmap for highly outdated environment
05 Oct 2017

A major Health Department was running a data system that has been expanding over the years. Eventually, they ended up with a highly outdated and inefficient environment with thousands of Microsoft Access and SQL Server databases. Such an outdated system presents a number of risks such as performance, scalability, manageability, security issues and frequent database corruptions. This leads to revenue losses because of poor performance. Moreover, such environments are usually not cost-effective with increased operating expenses due to a great number of unnecessary licenses. So, our customer decided to modernize their system, and they turned to ...

Virtualization and consolidation of SQL Servers during a complex database system upgrade
31 Jul 2017

One of the largest US national energy suppliers wanted to upgrade their SQL Server system and deploy it on VMware. As a consulting partner, we offered a new architecture for their virtualized system. In addition, we found some server consolidation opportunities which would improve the overall system’s performance. As a result, we helped our customers deploy the newly created system in production. Moreover, we delivered a comprehensive list of best practices for evident and accessible management of their environment. Learn more about the technical details of this project from the following video: (more…)...

Building detailed modernization roadmap for outdated databases using DBMSys
How the detailed modernization roadmap helped reduce the number of servers in the data center by 96%
22 Jun 2017

A major American provider of global eCommerce solutions was looking for a way to upgrade their extensive data processing system. We provided them with visibility into their system and built cost-effective and highly optimized modernization roadmap using our DBMSys platform. Using our detailed instructions they can substantially cut the upgrade expenses and take advantage of their workloads migration to Azure along with benefits from virtualization and consolidation options. (more…)...

5 essentials to learn about your data platform with DBMSys
28 Sep 2016

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 data over time needed to make informed business choices on current and future plans for scalability, flexibility, and increased...