Latest posts

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 market share to where it also holds the largest market share of industry use at almost 17%. All too often, when working with a client […]

Thomas Roehr
Proactive support for a data-loaded SharePoint system

We continue our series of blog posts dedicated to the support and database development services we provided to a large pharmaceutical company. In this post, we will focus on the SharePoint support services we provided to the client. The customer was operating a number of SharePoint solutions in Office 365. They developed a large intranet infrastructure that provided their team members with important content, such as a company digest, files with work-related information, data on events, and more. However, the […]

Julio Luque
Building a complex IoT solution for healthcare: a process perspective, Part2

We continue our series of posts on the development of complex IoT solutions. According to MarketsAndMarkets, healthcare IoT market is on the rise and it is expected to reach USD 94.2 billion by 2026. Medical software development market presents plenty of opportunities. In the blog below, we will look at some challenges we’ve faced while building IoT solution for healthcare, touch on a subject of software development, and discuss firmware development ten-stage work framework in detail. Compliance and security The […]

Kirill Zakharenkov
Use the power of PowerApps for fast data updates

We continue our series of blog posts dedicated to a large pharmaceutical company that required a broad range of infrastructure monitoring services. In this chapter, we will focus on the application that helps their sales team comply with the company rules. The customer created an iOS and Android app that stored compliance policies for regular activities of the sales team. Their sales agents are using the app to find information on regular activities. For example, they could clarify the company’s […]

Julio Luque
Building a complex IoT solution for healthcare: a process perspective, Part1

In recent years, healthcare technology development has gained momentum. Would you like to know one of its most promising directions? Then, let’s consider IoT healthcare solutions. Between 2019 and 2027, global IoT technology market is expected to grow at a compound annual growth rate of 24.9%. This technology can be used for building a great range of solutions, from remote monitoring systems to medication reminder tools. Surely, the ABCloudz team doesn’t stand aside from this trend. We do our best […]

Kirill Karpenko, Kirill Zkharenkov
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. In such conditions, making all databases efficient and consistent became a challenge. The customer decided to organize and upgrade all SQL Servers and the rest […]

Zymbytskyi Serhii
The flow and value of business analysis at ABCloudz

The application development process is a multi-layered activity with the core idea as the starting point and a well-functioning final product as the top layer. In this post, we will focus on the twists and turns involved in bringing the idea through to the final product. The role of business analysis is to identify and bring together business requirements and software solutions. So, one of the main roles of a business analyst is to outline and present a customer’s idea as a […]

Vlad Kalinichenko
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 allows our team to effectively deliver and deploy solutions that can significantly improve clients’ business results. The process of earning Microsoft competency is a complicated […]

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 support and monitoring team to handle any data infrastructure issues, but this did not solve the entire problem. The customer still had issues with organizing […]

Zimbitskiy Serhii
Why Use Microservices Architecture?
A Practical Guide

What is a Microservices Architecture? Microservices architecture is a style that structures an app as a set of predetermined services. At its core, such app is split into smaller independent segments that perform their own functions. This approach permits to view microservices as a group of undivided apps that handle their own features. As a result, we get an app that can perform a variety of functions by employing appropriate services. Pros & Cons of Microservices Approach Just like any […]

Maevskiy Konstantine, Starov Yevgen
Why Use Monolithic Architecture?
A Practical Guide

What is monolithic architecture? Monolithic architecture is known as a traditional approach to software development that is based on a single-unit design. This means that a program is basically a self-contained and independent unit. It consists of a database, client-side user interface, and server-side application. As it is possible to clearly see, a monolithic app is a single logical executable that usually does not interact with other services.   Pros & cons of monolithic approach Let us take a closer […]

Konstantyn Maevskiy, Yevgen Starov
Showcase: Blockchain solution for Ethereum and smart contracts

Cryptocurrency is one of the biggest trends of the decade that rapidly embraces the domain of online payments. With cryptocurrency and blockchain technology, you increase your technical capacity dramatically. Our development team could not stay aside from such trends, so they jumped into the research and experimented with the latest and greatest. As part of this research, the team had built a cryptocurrency trade app tied to Ethereum, one of the most promising blockchain networks. This is a fully workable […]

Valeriy Semenyuk, Konstantyn Maevskiy
Best practices: Making 3D modeling and 3D printing available for anyone

The 2022 forecast predicts that the board games market on the global level will reach $21.56 billion by 2025. At the same time, more and more creative individuals have gotten on board with independent game designing and self-publishing. It was just a matter of time until someone would come up with the idea of creating a 3D printed version of oneself for the board game. Well, the Hoplite Game Studios did just that. They turned to ABCloudz to develop a […]

Pavel Pozdniakov
Oracle to PostgreSQL migration with AWS SCT: How to handle unsupported NumToDSInterval function

In this post we continue exploring the technical aspects of Oracle to PostgreSQL migration using AWS SCT. We were using AWS SCT build#660 to convert one of our Oracle test databases. AWS SCT provides functionalities for the most efficient migration from Oracle to PostgreSQL. However, there is a common challenge with implementing the Oracle NumToDSInterval function in PostgreSQL. The Oracle NumToDSInterval function is responsible for the conversion of the provided number value of specified time units or expressions to an […]

Oleksii Savchenko
Oracle to MySQL migration with AWS SCT: How to convert BULK COLLECT clause

In this blog post we continue covering AWS SCT conversion issues, adding to the series where we help developers to deal with complex migration issues that can’t be automated with SCT. Today we are going to look into how SCT Build #660 addresses the conversion of statements with BULK COLLECT clause. In Oracle, you can retrieve an entire result set and store it in a PL/SQL collection type variable in a single operation. This can be completed with a SELECT […]

Artem Avetyan

Ready to start the conversation?

ABCloudz emerged from the world of data and established itself as a go-to partner for any IT needs. Our professionals are ready to help. Drop us a line today!

Hi there! How can I help you?

ABCAssist