More from our Blog

One of the world’s largest distributors of non-food consumable products wanted to rationalize their data platform and business intelligence strategy. Their current IBM DB2 database system lacked a repository to host historical audit-related data, so they could hardly retrieve data from past years. Then we came up with an Azure cloud database solution that could […]

HIPAA (Health Insurance Portability and Accountability Act) is one of the most important United States federal statutes which has a great impact on the development of medical software. This act stands for the safety of the protected health information (PHI) and defines security standards that each digitized medical business should follow. HIPAA sets numerous requirements […]

One of the largest educational organizations in the United States had been running their data handling system in the Oracle environment. They wanted to reduce maintenance costs due to the expensive Oracle licensing model, which includes an additional fee for the partitioning feature. The ABCloudz team provided a solution for migrating the customer’s database to […]

One of our clients, a large financial software company, wanted to migrate their billing solution from Oracle to SQL Server. They needed to initiate this project because the migration was required by one of their strategic partners. The customer decided to implement SQL Server Integration Services (SSIS) for this migration. Additionally, they needed to do […]

One of our clients, prominent information technology company, needed to migrate its Oracle database to SQL Server so they called ABCloudz. They knew they wanted to automate the major part of the migration with SQL Server Migration Assistant (SSMA) but there were some challenges associated with this process. First, the company’s source database code contained […]

The migration of Oracle databases to Microsoft SQL Server brings many challenges. One of the most significant is associated with mapping Oracle schema to SQL Server. At the architecture level, the wrong approach will result in significant effort in the future. For example, you may even need to rewrite your app’s entire code from scratch. […]

When a global retailer in the beauty industry needed a new and cost-effective data processing solution, they knew the search would require a high level of expertise. That is why they decided to seek advice from ABCloudz. The company had a massive amount of data and utilized SAS software for data processing, both powerful but […]

Proprietary database features often create significant obstacles for developers. To demonstrate as an example, we will take a look at one of Oracle’s most valuable proprietary features – Oracle Call Interface (OCI). It ensures efficient communication between the database and the application code. Surely, you may use other options for connecting to Oracle. However, once […]

Defining a naming convention for the conversion of packaged procedures and functions is a very important step during migration of Oracle database to Microsoft SQL Server. Experienced architects usually point out that this step is as significant as setting schema and data type mapping. Naming convention should be defined at the beginning of the migration […]

One of our clients contacted ABCloudz to request help with their SQL Server app’s performance issues. They upgraded from SQL Server 2008 R2 to SQL Server 2019 and began experiencing problems shortly after. We analyzed their database system and discovered a complex issue with updating SQL Server statistics. These stats are used by the Query […]