Andrei Ivanov

Technical Wordsmith

15
Years of experience
72
Blog posts
Always
Happy readers
Using Mobile Applications for Augmented Reality Art Buying
23 Aug 2017

One of our clients was looking to create a new business model of selling digital art using an augmented reality art mobile app solution. They identified that the biggest roadblock to selling digital art was that a customer often returned the art piece because it didn’t look right in their home or place of business. We developed the Art for Places and Spaces AFPAS application which allows customers to explore how a certain piece of artwork looks in the intended room before buying it. Watch the following video to learn more technical details augmented reality art buying works. (more…)...

Performing a comprehensive SQL Server Database Health Check
Getting the most out of a comprehensive database health check for SQL Server
22 Aug 2017

One of our public sector customers was using a distributed SQL Server 2016 database system and was considering an upgrade to unite the servers in one data center, or even a move to the cloud. We helped them by using our DBMSys service to perform the overall database health check. As part of the database health check, we found several high priority issues which required immediate actions. In addition, we provided the customer with detailed information on their existing database system, as well as the set of best practices and suggestions on how to upgrade it. Watch the following video to learn more about the technical approach we used. (more&...

Virtualization and consolidation of SQL Servers during a complex database system upgrade
31 Jul 2017

One of the largest US national energy suppliers wanted to upgrade their SQL Server system and deploy it on VMware. As a consulting partner, we offered a new architecture for their virtualized system. In addition, we found some server consolidation opportunities which would improve the overall system’s performance. As a result, we helped our customers deploy the newly created system in production. Moreover, we delivered a comprehensive list of best practices for evident and accessible management of their environment. Learn more about the technical details of this project from the following video: (more…)...

Database Compare Suite update 4.10 brings Sybase IQ support
26 Jul 2017

We are happy to announce the latest release of DB Best’s in-house tool Database Compare Suite. The new version marked 4.10 brings support for yet another data warehouse platform — Sybase IQ. Watch Database Compare Suite in action in the following video and learn more about other improvements of the latest update from our blog post. (more…)...

video streaming app
Leveraging Amazon Web Services to build a set of video streaming applications
30 Jun 2017

One of our regular customers wanted to add video streaming functions to their existing web and mobile applications. As the developers of their original applications, we proposed to re-architect the application and move it to the Amazon cloud. The customer agreed, and we delivered a cost-effective solution for in-house video streaming, based on Amazon Web Services. Watch the following video to learn more about our technical approach to the upgrade and development of this application. (more…)...

Using data extraction filters for smart database migration with AWS Schema Conversion Tool
29 Jun 2017

Amazon introduced the data extraction agents in the previous release of AWS Schema Conversion Tool (SCT). They allowed for migrating all the data from your on-premises data warehouse platforms to Amazon Redshift. Wait, what if you don’t need to move all those terabytes of data, and just want to settle for the data generated in the past couple of years? Starting from the version 1.0.603, SCT allows filtering the data before uploading it to Redshift. In addition, the latest SCT version brings support to rather outdated Teradata 13 and Oracle Data Warehouse 10 schemas. In the following video, we will demonstrate how you can use the data extrac...

An ultimate approach to converting hierarchical queries from Oracle to SQL Server
Helping our customer to convert Oracle schemas with hierarchical queries to SQL Server
20 Jun 2017

One of the world’s largest information technology companies decided to migrate their Oracle database to SQL Server. They leveraged SQL Server Migration Assistant (SSMA) for Oracle to automate the major part of their migration effort. However, their source database code included over 400 hierarchical queries that SSMA could not convert. Neither could the customer’s technical staff. So, they turned to DB Best asking for assistance in converting a number of Oracle database schemas. We helped our customer to solve this complicated task by converting the required database schemas within the short period of time. Watch the following video to l...

AWS Schema Conversion Tool
Oracle to PostgreSQL migration with AWS SCT: How to convert INSERT ALL statement
19 Jun 2017

In Oracle you may use the conditional insert clauses, for example, an INSERT ALL statement to add multiple rows with a single command. You can insert rows into one table or even multiple tables using just one SQL statement in Oracle. However, PostgreSQL doesn’t support such statements that attempt to inserting multiple rows. So, when you try to convert the source Oracle code that includes the INSERT ALL statement to PostgreSQL in the AWS Schema Conversion Tool, it will generate the following action item: «9996 — Severity critical — Transformer error occurred». Let’s discover how you can address this issue. (more…)...

Oracle to Azure SQL Database shift may save up to $1 million
16 Jun 2017

‘Low-performing and costly’ — these were major characteristics of the Oracle system of one of our customers, a leading US automotive corporations. In this regard, it was quite natural for them to consider migrating to another database platform. We suggested changing their Oracle Database to Azure SQL Database and moving their applications to Azure services. However, the customer may well anticipate this Oracle to Azure migration solution. Why? Because according to the calculations made by our experts, they can save upwards of 1 million dollars just on licenses in the coming 5 years! The video below depicts the migration process in detai...

Oracle to PostgreSQL database migration and unification project
Using PostgreSQL in cloud alongside with Oracle to enhance the database system performance
15 Jun 2017

One of the leading independent software vendors in educational domain needed to expand their original Oracle database system. They wanted to add a new PostgreSQL database running on AWS RDS to their original system and upgrade the connected Java application to support both database platforms. We came up with a proof of concept and converted one of the largest customer’s database schemas to PostgreSQL, demonstrating how the upgraded system might work. To do so, we updated the application by adding the unified SQL code and changing its architecture to support 2 database platforms. As a result, the newly created system could meet the customer...