SQL Server 2017 AWS EC2
Are you getting the best value out of AWS EC2 running with SQL Server 2017?
25 Oct 2019

Last year, we published the blog post on Validating AWS EC2 SQL Server Deployments Using Benchmark Tools. Since then, AWS released enhancements like Optimizing CPU Option that allow you to choose a larger EC2 instance for your SQL Server 2017 instances for greater Memory and IOPS / vCPU to keep your licensed vCPU count down.
Read this bog post to discover how benchmarking your SQL Server workloads on AWS in a pre-production environment can help you pick the best candidate EC2 instance with an optimized storage configuration based on real data.

migrate oracle to amazon ec2
Save on Licensing Costs and Migrate Oracle to Amazon EC2
08 Jan 2019

How can a world-leading multimedia content producer migrate Oracle to Amazon EC2 with minimal downtime while also reducing licensing costs? In this blog post, we discuss how we saved our customer 28% in Oracle licensing costs, implemented a reliable HA/DR solution, and migrated their immense environment to the AWS cloud with near-zero downtime using Oracle Data Guard. To better understand the client’s existing infrastructure, requirements, and potential limitations, let’s explore the customer’s environment prior to our successful migration. The Situation […]

Business Intelligence Solution For Marketing Automation
Building a Business Intelligence Solution for Marketing Automation
20 Dec 2018

The key to an effective marketing campaign lies in the ability to make timely adjustments based on results. When one of our customers came to us saying that it took one month to analyze campaign results, they asked us to work with them to build a new business intelligence solution for marketing automation. Our customer, a public Fortune 1000 services company, provides residential and commercial services. With nearly a century of experience, eight well-known brands, and over 7,000 company-owned and franchise […]

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

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

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

Power BI dashboard
Out of the Ring: Building a One-Day Power BI Dashboard that crushed Sumo Logic
25 Jul 2018

One of our customers, a major software provider in construction, agriculture, and geospatial industries, has one of the leading solutions for building design and building information modeling (BIM). Just think about the complexity of designing a building and the complexities of designing, fabricating, and installing air ducts, plumbing, electrical wiring, etc. In order to improve the software for their customers, their software product that we’ll call “BIM-APP” tracks all the user interactions and any system errors to log files. The […]

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

Webinar 2.9 Followup (Episode 12 – Columnstore Indexes)
19 Dec 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.9 – Columnstore Indexes If you missed the session, or would like to watch the recorded session, the recording will be available soon. Don’t miss the next webinar on January 9th: Viewing Query Plans!   The registration link will be posted here when available, In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not […]