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

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 everything running at peak performance levels. Given the variability that can take place, we are extending AWS database migration service to include an option of vali...

Validating Azure SQL Server Deployments
Validating Azure SQL Server Deployments Using Benchmark Tools
08 Nov 2018

If you have been deploying SQL Server workloads to the Microsoft Azure platform using virtual machines, you may have noticed that not all virtual machines, solid-state drives, and network components are created equal. There might be issues in your deployment templates that could result in SQL Server not performing as well as expected. For example, in a presentation given by André Arko at StrangeLoop 2016, André claims that Netflix benchmarks AWS EC2 instances that they use for production and if it passes, they use it. If the EC2 instance doesn’t pass the benchmark, then they terminate the instance and spin up a replacement. According ...

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 Synapse Analytics, Microsoft separated the Compute processing from the Storage so that you can dial up the performance needed. In this blog post, we will introduce you to the top 3 Azure SQL Database Hyperscale benefits. 1. Big size One of the major Azure SQL Database Hyperscale benefi...

Amazon QuickSight Introduction
Amazon QuickSight Introduction — Part 1
07 Nov 2018

In this Amazon QuickSight introduction, we will show you how to build a dashboard and make basic data visualizations. Amazon QuickSight is a cloud-based data visualization tool provided as a service with pay-per-session pricing, We were curious to see what it would take to create a QuickSight visualization similar to the visualization created in our earlier blog post, “Embedding Power BI Reports in a WordPress Blog”. The visualizations show the TOP 5 registered female and male first names per state, as per SSA.GOV for 1910 – 2018. The entire dataset is available as a zip file. The zip file contains comma delimited files for each year si...