modernization from oracle to sql server
Advanced Engineering Application Modernization from Oracle to SQL Server

As moats create obstacles in the way of an invader, so do proprietary database features for developers. One of Oracle’s proprietary features is the Oracle Call Interface (OCI) which provides efficient communication between application code and the database. There are other ways to connect to Oracle, but once you have committed to OCI, you are “protected” from switching to another database. In this blog post, we break down an application modernization from Oracle to SQL Server for an advanced engineering-oriented […]

SQL Server Database GDPR Title
A better way of deleting historical data from a large highly concurrent SQL Server table meet GDPR compliance
11 Feb 2019

One of our customers, a global digital media company, came to us with an interesting problem. As part of their General Data Protection Regulation (GDPR) compliance program, our client identified two tables that contained hundreds of millions of rows of historical user login data. GDPR states that you can process personal data while there is a contractual obligation with your client. However, once you terminate the contractual obligation and you have no legitimate interest with the data, deleting historical data […]

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

Validating AWS EC2 SQL Server deployments using benchmark tools
16 Nov 2018

As cloud computing becomes more and more popular and demanded among our customers, quite often we at DB Best need to answer the simple question: “How can I get the best value for running my SQL Server workloads on AWS EC2 instances?”. Issues like mistakenly using older generation EC2 instances or not optimizing your EBS volumes can prove to be costly. Likewise, not all hardware supporting the AWS infrastructure is created equal, despite the fact that they try to keep […]

Azure SQL Database Hyperscale
Top 3 Azure SQL Database Hyperscale Benefits
08 Nov 2018

When customers feel the need for speed and size, Microsoft announced at Ignite a new service called Azure SQL Database Hyperscale. This service offering is now available public preview as of October 1, 2018. Think of this as cloud-based Oracle RAC for SQL Server or Amazon Aurora for SQL Server in terms of the ability to scale SQL Server up to 100 TB! Like Azure SQL Data Warehouse, Microsoft separated the Compute processing from the Storage so that you can […]

Top 5 reasons for migrating to Azure SQL Database Managed Instances now!
02 Oct 2018

Microsoft is doubling down on Azure SQL Database Managed Instances (DMI) this year. There are some amazing Microsoft offers to provide a Platform-as-a-Service for running SQL Server on Azure. More importantly, there is a much higher degree of capability with DMI than what is available with Azure SQL Database DTU and vCore service levels. In this blog post, you will discover the most important reasons for migrating to Azure SQL Database Managed Instances. Also, you will learn how DB Best experts […]

Windows IIS and SQL Server on AWS
Deploying Windows IIS and SQL Server on AWS with CloudFormation
16 Aug 2018

In order to modernize their existing applications, databases, and infrastructure, a major state-run university with nine campuses, approached DB Best with a desire to not only create their ideal database environment but to cut costs along the way. Throughout our intensive discovery stage, we determined that we could help our client cut costs by migrating their Windows Internet Information Services (IIS)  and SQL Server to the Amazon Cloud (AWS). Over the course of our partnership, DB Best not only shifted […]

An automated solution for Crystal Reports conversion from Oracle to SQL Server
13 Aug 2018

One of our customers decided to modernize their Oracle database to Microsoft SQL Server. However, the thousands of SAP Crystal Reports connected to their existing Oracle database presented a huge challenge to their migration effort. They reached out to DB Best to develop an automated way to convert all of the connection information from Oracle to SQL Server and, more importantly, develop an automated solution that can extract the Oracle PL/SQL statements in the reports, convert them to SQL Server […]

Top 3 reasons for running SQL Server on Linux
10 Apr 2018

With the release of SQL Server 2017, you now have the option to deploy the database engine and just about all of the related services on either Red Hat Enterprise Linux (RHEL) 7.3+, SUSE Linux Enterprise Server (SLES) v12 SP2, Ubuntu 16.04, or the latest Docker image that uses Docker Engine 1.8+ on Ubuntu 16.04 as of April 10, 2018. Microsoft recently published a very slick marketing white paper titled Top six reasons companies make the move that highlights various […]

Operational Data Management Helps Multimedia Content Provider Build a New System on AWS
Operational Data Management Helps Multimedia Content Provider Build a New System on AWS
25 Jan 2018

One of the world’s largest multimedia content providers was looking for a way to increase the level of user satisfaction by improving the performance of their enormously huge database system. They wanted to leverage operational best practices to increase resiliency/uptime, performance, and scalability at the lowest possible cost. DB Best provided the customer with the day-to-day operational data management services both on-premises and in the cloud, as well as configured the new architecture for their cloud-based system. Discover the benefits […]