Windows Server 2008
Windows Server 2008 — End of support
23 Jan 2020

January 14th, 2020. What does this date mean for your organization? More so than with SQL Server, falling out of support for Windows Server will have immediate consequences to the security of your systems because of the frequency and volume of vulnerabilities and their subsequent patches. Click on the diagram to open an interactive Power BI report. January 14th, 2020 was the end of support for Windows Server 2008 and 2008 R2. And if this January is anything like every […]

optimize SQL Server performance on AWS EC2
Capturing performance counters to optimize Microsoft SQL Server performance on AWS EC2 instances
22 Jan 2020

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 several key Windows performance counters. This blog post is the first in my new series called Power BI for the SQL Server DBA. I’m going to show how you can easily capture performance counters to optimize SQL Server performance and cost on AWS EC2 instances. I’m going to start with […]

startup_guide
How to approach the development of your startup application?
12 Dec 2019

Suspense is a big problem facing businesses when they want to launch a startup application. You may have read dozens of success stories and still be completely at a loss about what exactly you should do. Sooner or later, all entrepreneurs end up at a development company, telling their ideas to the managers of their future projects. However, a couple of days before that happens, they surf the internet and hold meetings to discuss how things will unfold. No doubt, building an application is far less challenging when you know what to expect and where the pitfalls are that you should avoid.

lost and found platform
Developing a worldwide lost and found platform
29 Nov 2019

PerdidoOnline, a Puerto Rico based startup came up with an idea to help the unfortunate among us who lose our belongings wherever we go. Our client wanted to develop a locator and tracking solution t that will substitute the lost and found offices all over the world and save the users from worrying about losing their property. Read more to learn how DB Best turned this idea into reality.

Oracle Forms modernization assessment
Using the Assessment Tool to estimate your Oracle Forms modernization project
27 Nov 2019

Our free Oracle Forms Converter — Assessment Tool performs a thorough analysis of the code of your Oracle Forms and provides you with a detailed assessment report. This report includes a ballpark estimate of the total amount of hours required to complete the modernization project. Read the blog post to see how you can use this product.

migration-from-sas-to-hadoop
Migrating an On-Premises SAS System to Microsoft Azure HDInsight
26 Nov 2019

A global retailer in the beauty industry contacted DB Best looking for the right modernization path for their SAS based BI solution. They were hitting the boundaries of SAS with their large data sets and wanted to look at alternative solutions using big data technologies like Apache Hadoop with Azure HDInsight to modernize the way they process their data. In addition, the wanted to control their SAS license costs. In this blog post, we’ll walk through how we helped our […]

Data Store
Creating and managing database snapshots using the DB Best Migration Platform
25 Nov 2019

The Data Store module of the DB Best Migration Platform allows for creating and managing the golden copy of your source data. You can add all your tables into the dataset or select only the specific tables. Read the blog post to learn more about the features of the Data Store module.

SQL Server statistics update
Improve SQL Server statistics update 1000 times faster than traditional approaches
22 Nov 2019

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 up to SQL Server 2016. However, after we analyzed their database system, we discovered a complex issue with updating SQL Server statistics.
We utilized industry best practices and internal expertise to correct issues. Read our blog post to learn how we approached this complex task.

testing code changes
How to test breaking changes and new features during the SQL Server upgrade
12 Nov 2019

Our fully automated Migration Platform confidently guides you through an upgrade project. Read the blog post and watch the related video to discover how you can use the DB Best Migration Platform to test breaking changes and new features during the SQL Server upgrade.

automating database migration
Automating database migration projects with DB Best Migration Platform
06 Nov 2019

DB Best released a multi-purpose Migration Platform, introducing full automation for all steps of a database upgrade or migration project. Read our blog post and watch the related video to discover how DB Best Migration Platform can automate your database migration and upgrade initiatives.