Using AWS Schema Conversion Tool Extension Pack for OLTP databases
23 Mar 2017

Running your database migration projects, you may have already noticed that AWS Schema Conversion Tool (SCT) automatically generates an additional schema called extension pack. This schema emulates the system functions and specific features of the source database in your target DB instance. In the following video, we demonstrate how to apply this extension pack to the OLTP database. And in our future blog posts we will talk about working with extension pack for data warehouses. Make sure to check out our […]

Moving workloads to the cloud: MongoDB Cluster Deployment Automation
21 Mar 2017

An international healthcare company felt the urge to migrate core components of their application initially to Azure Infrastructure-as-a-Service (IaaS) with a long-term goal of transferring the solution to Azure Platform-as-a-Service (PaaS). We came up with a solution that automates the ‘lift and shift’ migration of their existing Linux-based MongoDB Cluster (dozens of virtual machines) to Azure IaaS. We created the cloud automation script that allows not only to deploy  the customer’s system but also to upgrade and scale it in […]

Migrating Oracle database to SQL Server for a leading US healthcare company
Migrating Oracle database to SQL Server for a leading US healthcare company
17 Mar 2017

One of the leading US healthcare organizations needed to upgrade their health record system in an effort to drive down costs while enabling new capabilities. We proposed to migrate the Oracle database to SQL Server to build a scalable and secure architecture. We faced a number of Oracle to SQL Server migration challenges, including the huge volume of data along with very large tables aggregated in the original database. As a result, the customer got the modern, secure, platform while saving […]

Global Retailer Tunes up OLAP Performance Ten-fold
15 Dec 2016

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 […]

Faster reporting and flexibility using SSIS and SQL Server
DB Best Case Study: Faster reporting and flexibility using SSIS and SQL Server to offload Excel reports from SSAS cubes
03 Nov 2016

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 […]

Database Compare Suite 4.5 Released — Amazon Redshift and SQL Server 2000 support
12 Oct 2016

We are proud to announce the latest version of the Database Compare Suite tool, which now adds support for Amazon Redshift and SQL Server 2000. For customers looking to upgrade their SQL Server 2000 database servers, Database Compare Suite is the only tool on the market that supports comparing database schema and data changes with newer versions of SQL Server. This a great timesaver for your upgrade projects! Eight database dialects are now supported in Database Compare Suite. They include: […]

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 […]

Tracking down discontinued SQL syntax with SQL Sniffer and Replayer
24 Aug 2016

Do you still have SQL Server 2000 database servers running in your organization? Do you have SQL Server 2008 R2 or older database servers running with databases using compatibility level of 80 for SQL Server 2000 compatibility? Running the SQL Server profiler over an extended period of time looking for deprecated and discontinued syntax may not be an option either. At DB Best, we have developed a solution called SQL Sniffer that works at the network switch level to solve […]

12 sure steps to SQL Server upgrade success
12 sure steps to SQL Server upgrade success
02 Aug 2016

Application and database upgrade or modernization projects for SQL Server should not be taken lightly. You might want to take advantage of the latest versions of SQL Server 2016. You might need to take your aging SQL Server 2000 or 2005 solutions running on older hardware and operating systems and get them onto a supported version of SQL Server. In either case, having a programmatic approach to upgrading your applications and databases is critical to keeping your business running. At DB Best Technologies, we have a 12 step project approach that we use for upgrade projects that is based on our proven Migration Methodology. This blog post provides you will an overview of the DB Best 12 Step Upgrade Project steps to help you prepare for your upgrade.

Introduction to SQL Server 2016 Upgrade Advisor
18 Jul 2016

NOTE: Microsoft has since abandoned the SQL Server 2016 Upgrade Advisor and now calls the tool the Microsoft Data Migration Assistant (DMA). The concepts for using the tool are the same for using DMA as shown below. The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and […]