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

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 validating AWS E...

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

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

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

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

Amazon QuickSight Introduction — Part 1
07 Nov 2018 Jen Etzler

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

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

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 can help you get there within a short period of time. Azure SQL Database Managed Instances is a new deployment model of Azure SQL Database. It provid...

DataOn SQL Server 2017 solutions
Reducing operating costs by upgrading SQL Server 2008 workloads using DataON SQL Server 2017 solutions
24 Sep 2018 Bill Ramos

What are your options when the end of support for SQL Server 2008 R2 occurs in July 2019, and moving to the cloud is not an immediate option? In a joint benchmarking project between DataON, Western Digital, and DB Best Technologies, we demonstrated how you can reduce your operating costs for upgrading SQL Server 2008 workloads using DataON SQL Server 2017 solutions. DataON S2D-5224w server - 2U 24-bay 2.5" All-NVMe Hyper-Converged Cluster Appliance DataON SQL Server 2017 solutions feature Windows Server Hyper-Converged Infrastructure (HCI) solutions using Storage Spaces Direct. While this sounds a bit scary and expensive, we showed how you ...

Migrating Windows Solutions Utilizing SQL Server to AWS
Best Practices for Migrating Windows Solutions Utilizing SQL Server to AWS
16 Aug 2018 Bill Ramos

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 them to the Amazon Cloud (AWS). Over the course of our partnership, DB Best not only shifted them to the cloud, but built, tested, and deployed the next-generation of their database infrastructure. Oh, and we did it all a year sooner than planned. How? Read on to find out. Where we applied ou...

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

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 Transact-SQL, and insert the tested T-SQL commands back into the original report. In this blog post, we cover how we were able to pull this off for ...

Is making a mobile messenger app for a One Direction star ‘Too Much To Ask?’
02 Aug 2018 Andrey Ivanov

Quick question, what do you get when you mix a strong jawline, baby blue eyes, a sweet sultry singing voice, and our experience and expertise in mobile application development? Answer, Niallmojis. Niall Horan, the Irish pop star originally from the famous band ‘One Direction’ leveraged our mobile development experience to create an exclusive set of personalized stickers and animated avatars of Niall’s face all packed into a mobile custom keyboard application. Drawing from our experience in developing the world's first sound-based messenger, our developers were primed and ready to create a unique and free-flowing messenger experience. ...

Best practices for moving SQL Server to AWS: Amazon EC2 and RDS
26 Jul 2018 admin

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 enormous database system. They wanted to leverage operational best practices to increase resiliency/uptime, performance, and scalability at the lowest possible cost. Their overall goal was to move all of their applications out of their datacenter and over to Amazon Web Services through a lift-and-shift process. This blog post documents the best practices for moving SQL Server to AWS, specifically the Amazon EC2 and RDS environments which we developed as part of this project. How we mi...