Talks on Managing Data and Applications Anywhere
When a company grows, it’s no surprise that their database stored data grows as well. This is the case for all companies, and our customer, a global retailer in the beauty industry, was no exception. While working on this project, we managed to increase the average speed of query execution by 30x, saved up to 190 GB of memory and freed up 28 GB of disk storage space. Prior to these great results, there was a hard optimization process performed […]
This continues our video blog series on the AWS Schema Conversion Tool (SCT). In the previous blog post we’ve talked about the general approach of data warehouses migration to Amazon Redshift, and in this article, we are going to dig deeper into the DW migration specific features. Before starting the migration of Greenplum, Netezza, Oracle or Teradata data warehouse to Amazon Redshift, you will want to understand the capabilities and limitations of Redshift. This video will give you a better […]
This post continues our video blog series on the AWS Schema Conversion Tool (SCT). In our previous blog posts, we talked about using AWS SCT for transactional database migration projects. The AWS Schema Conversion Tool also supports migrating data warehouse (DW) workloads to Amazon Redshift. AWS Schema Conversion Tool uses a different approach to DW migration projects compared to the transactional database migration workflow. With transactional databases, you typically have stored procedures, triggers and other database objects which deal with […]
DB Best uses a 12-step migration process to make sure all bases are covered as part of a typical migration project. Data migration is a critical part of a database migration projects and tools like SSMA can help in the process. In the following video, we will show you how to migrate data using the SSMA tool, as well as highlight errors that may occur during database migration. Need help getting started? Check out our Jumpstart for SSMA offer!
AWS re:Invent 2016 is just days away, and DB Best is excited to be there November 29 – December 2. We’ll be at booth #236. Come see us! To help start the conversation, here is a list of our recent AWS Schema Conversion Tool blog posts: Migrating an Oracle to MySQL Database using the AWS Schema Conversion Tool AWS Schema Conversion Tool: Offline Mode AWS Schema Conversion Tool: Connecting to Oracle Source Database Selecting target database type for migration using […]
This continues our video blog series on the AWS Schema Conversion Tool (SCT). After connecting to the source database and troubleshooting the database migration issues it’s time to apply converted code to the target database. The AWS Schema Conversion Tool provides two ways of applying changes to the target database. The first option allows you to generate the SQL-script. You can modify this script if needed and then execute it using your favorite database tool. The second option allows to modify the target […]
Upgrading SQL Server can be a complicated and nuanced operation, it can’t be simply performed with a few mouse clicks. In many ways, upgrading SQL Servers follows a similar process to more general database migration projects. Because of the similarities, we can apply our 12-step database migration methodology to great effect. From analyzing the existing database architecture to consolidating resources for operational cost reduction, DB Best has the tools and know-how to ensure your SQL Server platforms are up to […]
People enjoy the money-saving rewards of discount offers. On top of that, people enjoy the fun of playing games. With Reward Hunter from the DB Best app development team, mobile phone users can get the best of both worlds. At DB Best, we’ve combined these two activities into one augmented reality mobile application that can engage users and help you grow your business. This fun new application, called Reward Hunter, comes in an “out of the box” version for use on either iOS or Android mobile phones. Reward Hunter can […]
DB Best recently completed a complex development project for one of the largest banks in the Middle East. Faced with non-customizable and slow-to-generate reporting, the customer contacted DB Best to develop a new and improved solution. The customer’s original system was built on two SQL Server Analysis Services systems, each containing large amounts of various aggregated data types with Excel workbooks directly accessing the two SSAS cubes. Not only did this system take a considerable amount of time to generate […]
This continues our video blog series about new features on the new capabilities of SQL Server Migration Assistant 7.0. SQL Server 2016 In-Memory OLTP significantly improves OLTP database application performance and allows running large queries against the same tables using clustered and non-clustered columnstore indexes. This technology was introduced in SQL Server 2014 and now SSMA 7.0 supports migrating Oracle Database In-Memory tables to In-Memory OLTP with SQL Server 2016. Background on SQL Server In-Memory OLTP and Oracle Database In-Memory […]