Amazon QuickSight Introduction — Part 1
17 Oct 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, […]

Microsoft Data Migration Assistant
Introduction to the Data Migration Assistant v4.0 (formally known as SQL Server Upgrade Advisor)
11 Oct 2018

Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It allows you to not only move your schema and data, but also uncontained objects from your source server to your target server. Basic recommendations based features The DMA Azure SQL Database SKU advisor capability makes several recommendations based on the features […]

Azure SQL Database Managed Instances
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 […]

Azure SQL Database Hyperscale
Top 3 Azure SQL Database Hyperscale Benefits
02 Oct 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 […]

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

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

Developing a complex web-based 3D graphical editor
24 Sep 2018

Each and every industrial machine on the factory floor gets personalized care from a combination of people and software. Both human eyes and digital algorithms are continually looking at how machines are “feeling” by observing metrics collected from different parts of each machine. Each machine even has a personal ‘diary’ where you can both look back to see all the changes the device has undergone throughout it’s life, as well as the current health of the machine. Watch the video […]

Migrating Windows Solutions Utilizing SQL Server to 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 […]

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

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

Best practices for moving SQL Server to AWS: Amazon EC2 and RDS
26 Jul 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 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. Watch the following video to discover how we approached […]