Microsoft SQL Server provides a great experience using default installation parameters and cloud deployments with a variety of vendors. Over the years, we’ve worked with thousands of databases at customer sites around the world.

In many cases, these databases may not have the full attention of the DBA team, if a team even exists.

Here are some of the common challenges we see with Microsoft SQL Server deployments.




Database server licenses optimization

Database servers were provisioned for a larger than needed workload, resulting in higher than necessary licensing costs.

We’ve developed a Data Optimized Management solution that monitors your SQL Server workloads over a period of time. We use the data to determine how you can consolidate multiple databases onto a single SQL Server instance to dramatically lower your SQL Server licensing costs.

Leveraging best practices

Best practices in security, high availability, disaster recovery, auditing, infrastructure, and performance are often overlooked.

DB Best has a platform called DBMsys that collects server and database configuration and layout information. DBMsys then processes the data using our own algorithms to produce a map of best practices and reports. We will then propose solutions to the various issues discovered based on criticality. The same engine can be used to perform compliance checks for ISO or another standard.

Upgrading outdated SQL Server versions

Customers running unsupported versions of SQL Server run the risk of not conforming to data governance policies for their solutions. Don’t be faced with having to upgrade hundreds of databases without any idea where to start.

At DB Best, we have helped customers create an “upgrade factory” that allows them to move databases to newer versions of SQL Server while maintaining application capability and up time. Read our blog post to discover how the DB Best Migration Platform helps automate testing database code changes during the SQL Server upgrade.

In addition, we use our DBMsys platform to perform capacity planning and best practices configuration for the new environment.

Migrating from another database platform

Customers looking to migrate from other database platforms like Oracle and SAP ASE in order to save licensing costs and take advantage of the advanced features of SQL Server are not sure where to start.

DB Best is the original creator of the SQL Server Migration Assistant and has developed a unique 12 step migration methodology. This methodology ensures complete application capability and conformance with your organization’s service level agreements while also minimizing overall migration risks. We then developed the DB Best Migration Platform to assist in navigating through these 12 steps of our migration methodology. This product helps automate the migration of your databases to Microsoft SQL Server.

Running SQL Server 2017 on Linux

Customers running Linux have been stuck with open-source databases like MySQL and PostgreSQL for years and are looking for a platform that can grow for their on-premises, cloud, and hybrid solutions.

DB Best was an early adopter of SQL Server 2017 on Linux and is ready to help you integrate SQL Server for your DevOps needs like running SQL Server in Linux Docker Containers. Whether you use GetLab, Visual Studio Team Services, Jenkins, or BuildBot. DB Best can help you with adding SQL Server schema and data into your Continuous Integration (CI) and Continuous Deployment (CD) pipelines.

Learn more about Microsoft SQL Server
Contact us


We have a variety of entry-level offers to help you get the most out of Microsoft SQL Server running either on-premises bare metal, private cloud, Microsoft Azure, AWS EC2 or RDS, and Google Cloud Platform.

If you are looking to better understand your SQL Server modernization roadmap, we recommend a Future-State Architectural Design Engagement. In some cases, you might qualify for co-investment funding by Microsoft to get started with SQL Server 2017 and Microsoft Azure.


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 a cost-effective and highly optimized modernization roadmap using our DBMSys platform. Using our detailed instructions they were able to substantially cut the upgrade expenses and take advantage of their workload migration to Azure along with benefits from virtualization and consolidation options.

Customer Problem

Our customer has been supporting a number of data centers around the world for a long period of time. Without timely monitoring and updating such systems easily become outdated with a high percentage of servers running on no longer supported versions of database or operating systems. Moreover, the server hardware is rapidly aging over the years and the whole system becomes inefficient and overpriced. That’s why they needed to upgrade and consolidate their servers with an opportunity to migrate them to the cloud

The customer asked us to analyze the existing environment, based on the layout modernization roadmap we showed them how they can reduce the costs while enabling new capabilities.


The detailed modernization roadmap provided a path to determine which workloads should move to Microsoft Azure IAAS or PAAS solutions.

We recommended the upgrade tools and automation techniques that could facilitate the upgrade and migration process.

We then performed this job with a special focus on risks mitigation, increasing the efficiency, and cutting down the costs.

To learn more about this effort, check out our video.

Let's get together to talk about Microsoft SQL Server
Contact us today


The breadth of technology partners that support Microsoft SQL Server makes a great platform for our clients. Here are some of our technology partners that we work with to support deployments of Microsoft SQL Server with our customers.

amazon web service
GCP logo

Different flavors of SQL Server

SQL Server databases empower many various businesses. You may be running SQL Server for years with no real need to change the way how the things are going. But as the time marches on, you may want to consider running SQL Server on other platforms rather than Windows Server. For example, you can switch to the open-source Linux platform with your existing SQL Server workloads, or take advantage of the Azure cloud.

Contact us today to help you take advantage of Microsoft SQL Server
Contact us

Learn More

Blog posts

Challenges migrating SAS solutions to SQL Server - Missing Values versus NULL
28 January 2020 Bill Ramos

Managers for a well-known accounting and tax-preparation company contacted DB Best looking for an alternative solution to a big problem. They were long term customers of SAS but were n...

How the detailed modernization roadmap helped reduce the number of servers in the data center by 96%
22 June 2017 admin

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 ...

Global Retailer Tunes up OLAP Performance Ten-fold
15 December 2016 Bill Ramos

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, wa...

A better way of deleting historical data from a large highly concurrent SQL Server table meet GDPR compliance
11 February 2019 Azhar Taj

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 ...

Using Create or Alter Statement in Microsoft SQL Server
23 May 2019 Nick Samoylenko

Managing customer's SQL Server applications, we discovered a significant performance decrease related to query execution time. We figured out that the reason for that was the execution...

Use Caution When Mapping Oracle Data Types for Procedures and Function Parameters in SSMA
5 June 2019 Oksana Eremenko

When converting Oracle database code to Microsoft SQL Server, I often face the problem of correctly mapping Oracle data types to SQL Server data types. I regularly use SQL Server Migra...

Defining a naming convention in Oracle to SQL Server migrations
17 July 2019 Oksana Eremenko

When migrating Oracle databases to Microsoft SQL Server, you need to define a naming convention for the conversion of packaged procedures and functions. This step is as important as se...

How to remove the Management Data Warehouse from SQL Server running on a production instance
26 June 2019 Bill Ramos

One of our customers had their Management Data Warehouse (MDW) running on their production SQL Server 2012 and didn’t know what to do with it. Microsoft had introduced the MDW with S...

General approach to migrating Oracle applications with OCI interface to Microsoft SQL Server
12 June 2019 Nick Samoylenko

When migrating a customer’s Oracle databases to Microsoft SQL Server I often face the problem of updating relevant applications. A broad range of our customers use the Oracle Call In...

How Trace Flag 1254 Fixes SQL Server Error Message 3628 with Queries Using In-Memory Tables
9 June 2019 Bill Ramos

I recently ran into this issue with SQL Server 2019 CTP 2.5 where I was getting the error - Msg 3628, Level 16, State 1, Line 4 The Database Engine received a floating point exception ...

Improve SQL Server statistics update 1000 times faster than traditional approaches
22 November 2019 Jan Studenovsky

One of the customers contacted DB Best to help address performance issues with their SQL Server application. They started experiencing problems after upgrading from SQL Server 2008 R2 ...

Greater performance with lower cost with SQL Server on Linux Data Warehouse
26 August 2019 admin

What do you do when your data science team needs to perform read-only data warehouse queries against your mission-critical online transaction and batch processing database? One of our ...

How to convert a development server running SQL Server Standard or Enterprise edition to Developer edition
3 July 2019 Bill Ramos

I recently had a client using SQL Server 2012 Standard Edition on three of their development servers. However, SQL Server 2012 has a developer edition that is specifically designed for...

Migrate Sybase Java applications to SQL Server for content services provider
4 October 2018 Bill Ramos

A leading provider of content services for the legal industry looked to DB Best to help them modernize their aging Sybase ASE and IQ solutions that were built on top of an old IBM AIX ...

Virtualization and consolidation of SQL Servers during a complex database system upgrade
31 July 2017 Andrei Ivanov

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 vir...

Architecting highly available and scalable system when migrating to SQL Server on AWS
12 July 2017 admin

Our customer needed to reduce the licensing costs of their Oracle database. We came up with a comprehensive solution by migrating their database to SQL Server platform. We also remed...

Azure SQL Database Migration to Embrace Cloud Benefits
6 April 2017 admin

One of the leading medical software providers maintained their complex healthcare system with thousands of unique users. Developing over time, this system became overloaded and unsaf...

Advanced Engineering Application Modernization from Oracle to SQL Server
22 April 2019 Peter Skjøtt Larsen

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 ...

Automating database migration projects with DB Best Migration Platform
6 November 2019 Irena Balin

PASS Summit 2019, Seattle, WA — DB Best released a multi-purpose Migration Platform, introducing full automation for all steps of a database upgrade or migration project. DB Best cre...

How to test breaking changes and new features during the SQL Server upgrade
12 November 2019 Oksana Eremenko

Database upgrade is inevitable if you're running aging versions of your databases. Alongside with cool new features, the database upgrade usually brings some code changes. Regardless o...

Capturing performance counters to optimize Microsoft SQL Server performance on AWS EC2 instances
22 January 2020 Bill Ramos

Over the last few months of benchmarking SQL Server performance on AWS, I discovered a way to optimize SQL Server performance running on EC2 instances by paying close attention to seve...

Using Power BI to analyze Windows Perfmon data for SQL Server
27 January 2020 Bill Ramos

In this second blog post for my series, Power BI for the SQL Server DBA, I’m going to show how you can take Windows Perfmon (Performance Monitor) data for SQL Server and analyze it w...

Using PowerShell Invoke-Sqlcmd with Variable parameter
26 February 2020 Bill Ramos

I recently needed to use PowerShell to call a T-SQL script using Invoke-Sqlcmd with the -Variable parameter. In my case, I wanted to specify the locations for backup files and where to...


Please check out the related datasheets to help you get the most out of SQL Server database technologies.

SQL Server Database Upgrade Datasheet
3 September 2019 Bill Ramos

Are you running your SQL Server 2008/R2 for ten years now? Even if you are still happy with its performance, there are some important things for you to consider. SQL Server 2008 has be...

SQL Server 2017 on Linux Datasheet
20 July 2018 Bill Ramos

Customers running Linux have been stuck with open-source databases like MySQL and PostgreSQL for years and are looking for a platform that can grow with their on-premises, cloud, and h...

Making the move to Azure SQL Database Managed Instances Datasheet
3 September 2019 Bill Ramos

Are you tired of the increasing database platform costs and looking for a lower cost solution? Do you like the idea of Platform-as-a-Service (PaaS) for your database solutions? Are you...

SQL Server Optimization on AWS Datasheet
21 April 2020 Bill Ramos

If your business runs SQL Server on AWS, we have an offer to trim off your services bill! Over the last few years, DB Best has analyzed thousands of SQL Server deployments on AWS. Star...

Data Management Services for Microsoft Azure
8 November 2016 Bill Ramos

DB Best Technologies is internationally known for comprehensive Data Management Services, database development and migration, and the creation of highly successful web and mobile syste...

Oracle to SQL Migration
21 September 2016 Bill Ramos

Leveraging Microsoft SQL Server, DB Best can help Oracle customers achieve the performance, scale, and security that their mission-critical applications require while keeping costs und...

Sybase to SQL Server Migration Datasheet
23 September 2016 Bill Ramos

The number one reason businesses want to migrate from Sybase to SQL Server is reducing Total Cost of Ownership. The DB Best team developed a unique methodology for migrating Sybase app...

High Availability and Disaster Recovery Implementation in Microsoft Azure
9 April 2019 Bill Ramos

Many businesses are anxious if their data center can really handle a natural disaster. Thus, their operational teams spend hours on configuring HA/DR operations. Consequently, they spe...

Migration Platform Datasheet
5 November 2019 Bill Ramos

Are you developing migrating or testing your data-driven applications? Then you may need a comprehensive multi-purpose tool for all related operations. Read our Migration Platform data...

Case Studies

Migrating critical apps from Sybase ASE to SQL Server
30 August 2016 Bill Ramos

Our client, a global leader in security technology, had two mission-critical yet aging PowerBuilder applications running against Sybase ASE that were out of compliance given the lack o...

Developing an app to help doctors and asthmatics
22 August 2016 Bill Ramos

A respiratory healthcare provider needed apps for doctors and their asthmatic patients to help ensure and track proper and timely use of asthma medication. Having worked with us on a p...

White papers

eBook: Enhancing SQL Server database performance by 3x acceleration of query executions
26 July 2018 Bill Ramos

A leading provider of business management solutions currently hosts many of their workloads using SQL Server databases on Azure. They faced a number of SQL Server database performanc...

eBook: SQL Server Upgrade Checklist
10 January 2019 Bill Ramos

Microsoft ends the extended support of SQL Server 2008 and 2008 R2 on July 2019. With the deadline rapidly approaching, upgrading your legacy SQL Server workloads as soon as possibl...

eBook: DB Best upgrades a leading telecom company’s SQL Server 2000 and 2005 databases
27 July 2018 Bill Ramos

Upgrading SQL Server can be a complicated and nuanced operation, it can’t be simply performed with a few mouse clicks. In many ways, upgrading SQL Servers follows a similar process t...

eBook: Faster, Cheaper, Better: Upgrade SQL Server 2008 NOW
27 July 2018 Bill Ramos

We get it: You’ve been running your SQL Server 2008 for ten years now, and its performance has made you very happy. It’s been as steady as a rock and helped guide your business to ...

eBook: Getting the most out of a comprehensive SQL Server database health check
27 July 2018 Bill Ramos

One of our public sector customers was using a distributed SQL Server 2016 database system and was considering an upgrade to unite the servers in one data center, or even a move to the...

Guide to migrating from Oracle to SQL Server and Azure SQL Database
8 October 2015 Bill Ramos

This white paper explores challenges that arise when you migrate from an Oracle 7.3 database or later to SQL Server 2014. It describes the implementation differences of database objec...

Guide to migrating from Sybase ASE to SQL Server 2014 and Azure SQL Database using SSMA
15 November 2015 Bill Ramos

Summary: This white paper covers known issues for migrating Sybase Adaptive Server Enterprise database to SQL Server 2014. Instructions for handling the differences between the two pla...

Let us help you with your project!
Contact us for a FREE quote today.
Request a quote