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. Please stay tuned for a new blog post that covers the capabilities of DMA. SQL Server 2016 has been released, and it is already making waves as a big step up from previous versions. Naturally, upgrading to SQL Server 2016 has an appeal that […]

Database Compare Suite update 4.3 — MySQL support and other features
06 May 2016

We’re excited to bring you yet another update of the Database Compare Suite tool which adds several major features such as MySQL database dialect support, ODBC support, settings comparison, along with other notable improvements. With this update, the user is now able to operate on six database dialects: SQL Azure, IBM DB2, Oracle, Sybase ASE, SQL Server, and now MySQL.

Introducing Row-Level Security in Azure SQL Databases
22 May 2015

Any organization wants to maintain control as much as possible over the data it possesses. Here at DB Best, Migrations from another Data Platform to SQL Server or Azure is part of the regular business that we do. Oracle and DB2 offer their take on RLS and now SQL Server has another feature that makes it easier for the transition. Row Level Security is currently in “Preview” on Azure SQL Databases and is scheduled to be part of the new […]