abcloudz

Learn more about

SQL Server

Modernizing an enterprise marketing system

As businesses grow, their systems must evolve to keep pace. The company at the heart of this project had built its foundation on a legacy marketing system that managed contracts, inventory, and logistics across multiple locations. The company operates in the agricultural sector, processing and distributing a wide range of products across various markets. With […]
Oleksii Svitlychnyi

Migrating from Oracle to SQL Server for a food manufacturing company

ABCloudz recently helped The Morning Star Company, one of the world’s largest producers of tomato products, migrate their Oracle database to SQL Server. The Morning Star Company operates three processing facilities in California, handling nearly 10% of the global tomato production. Their IT infrastructure included both Oracle and SQL Server databases, but due to the […]
Oleksii Savchenko (DB Developer), Oleksii Svitlychnyi (Technical writer)

Optimizing Date and Time Conversion in Oracle to SQL Server Migration

Migrating databases from Oracle to SQL Server can be a daunting task, especially when dealing with date and time data. While tools like the SQL Server Migration Assistant (SSMA) offer automated solutions, relying solely on these tools might not always yield the best performance. In this blog, we share examples of how to optimize conversion […]
Oleksii Savchenko

Operational Data Management for a Global Biotech Leader

Our client, a global biotech company with a presence in over 80 countries and a workforce of 4,000 employees, depends on a complex IT environment that includes both on-premises and cloud-based components. This infrastructure supports everything from research and development to manufacturing and corporate operations, with SQL Server playing a pivotal role across various environments. […]
Sergii Zymbytskyi, Oleksii Svitlychnyi

EDW to Azure Databricks Migration

ABCloudz recently completed a significant project migrating an Enterprise Data Warehouse (EDW) from an on-premises SQL Server 2014 to Azure Databricks for a leading global retailer operating 3,000 offline stores across 40 countries. This migration was essential for addressing physical server limitations and outdated technology that hindered data processing and storage capabilities. Embracing Big Data […]
Sergey Shtypuliak (DB Engineer), Oleksii Svitlychnyi (Technical writer)

Deploying Multi-Tenant SaaS Application on AWS

Discover the scalable multi-tenant backend architecture and robust CI/CD process at the heart of the client-server solution we developed for our major pharmaceutical customer. Initially crafted to assist asthma patients with medication adherence, this app also enables doctors to monitor treatment progress remotely. The market success of this solution led our customer to strategically scale […]
Konstantin Maevskiy

Sophisticated migration of an IT infrastructure from on-premise data center to the AWS cloud

ConcertAI, one of the leading providers of medical research software, faced a common scenario for a mature healthcare data center. Over the years, its infrastructure had become highly sophisticated but inconsistent. Some of the servers were running outdated, end-of-life operating systems and urgently needed upgrading. The client decided to implement a cloud-based solution for infrastructure […]
Alex Smirnov, Roman Muzyka

Get maximum of SQL Server: comparing Azure SQL Database and SQL Server on virtual machines

SQL Server is a veteran in the data management market and Microsoft’s most popular relational database management system. It boasts several benefits, including fast query processing, excellent security and data restoration, easy integration with other database systems, portability, and a variety of tools and plugins to enhance database management efficiency. Moreover, migrating SQL Server to […]
Sergii Zymbytskyi

Feng Shui, VMWare, and SQL Server – Finding Balance

Feng Shui is the practice of arranging pieces in living spaces to create balance with the natural world. VMWare vSphere virtualization has grown since its introduction in 1998, to being the top virtualization technology in use by companies today, holding 23% of the market. Microsoft’s SQL Server product, first released in 1988, has increased its […]
Thomas Roehr

License inventory for a large SQL Server database infrastructure

Here’s a new entry to our series of posts on how the ABCloudz team has helped a large pharmaceutical company manage its sophisticated data infrastructure. The customer’s business is rapidly growing, which leads to a significant expansion of their data infrastructure. This infrastructure has exceeded 140 SQL Servers united by complex connections and ETL scripts. […]
Zymbytskyi Serhii

Microsoft silver competency in two areas

ABCloudz announces that we have achieved a silver competency in Application Integration as a Microsoft partner. This proves the company’s capability to effectively integrate and configure systems that run on Windows servers, Microsoft SQL, and Microsoft .NET. Being a Microsoft partner, our company has access to exclusive training coupled with the latest software solutions. This […]
Andrii Koval

How to cover monitoring gaps for a large SQL Server data infrastructure

Our client is a large pharmaceutical company with a sophisticated data infrastructure. Along with the company’s rapid growth, its data infrastructure started growing as well. At one point, their data infrastructure exceeded 140 SQL Servers united by multiple scripts and connections. This growth made its maintenance more challenging and time-consuming. The customer created a professional […]
Zimbitskiy Serhii

Market review: SQL Server Monitoring Tools

It’s no secret that a modern world runs on data. This essential asset is stored in databases or data stores. And keeping such databases or data stores healthy is vital in the digital era we live in. It is also no secret that database issues can take down entire systems and cost businesses many thousands […]
Sergii Zymbytskyi, Roman Muzyka

Quick and easy automatic approach to database conversion

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 […]
Andrey Khudyakov, Roman Muzyka

An overview of the remote migration from Oracle to SQL Server with SSIS

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 […]
Andrey Khudyakov, Roman Muzyka

Hi there! How can I help you?