Learn more about

azure
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. Given the scale and criticality of their operations, the client required a partner who could not only manage and optimize their existing SQL Server infrastructure […]

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 capabilities, our solution leveraged Azure Databricks to enhance the client’s data scalability and processing efficiency, directly impacting their ability to manage and analyze large data […]

Sergey Shtypuliak (DB Engineer), Oleksii Svitlychnyi (Technical writer)
ABCloudz Achieves Microsoft’s Data & AI Solutions Partner Designation

Data is the lifeblood of any business. The ability to extract insight and value from data plays a critical role in determining long-term success. Efficient data utilization can drive streamlined business processes, reduce waste, and enable well-informed strategic decisions. With the advent of cloud-powered AI and analytics tools, organizations now have unprecedented access to transformative capabilities. That’s why ABCloudz is thrilled to announce its designation as a Microsoft Solutions Partner for Data & AI. This recognition underscores our expertise in […]

Adam Robertson
Unleashing the power of data integration: a head-to-head comparison of AWS Glue vs. Azure Data Factory

Nowadays, it’s hard to imagine effective Business Intelligence without ETL (extract, transfer, and load) tools. These tools help you integrate data from multiple sources into a single database environment. Instead of keeping data in silos, you get an efficient and consistent data warehousing method where all data brings you value, regardless of its format and source. By integrating data from multiple sources into a single database environment, you can automate data management and save valuable time, allowing you to focus […]

Oleksandr Smolovyk, Mykhailo Ievsieiev
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 the cloud offers additional benefits, such as improved scalability, database manageability, and cost-efficiency. There are three common options for deploying SQL Server in the cloud: […]

Sergii Zymbytskyi
Power BI Horizontal Fusion, the query optimization we’ve been waiting for

This last September’22 Microsoft announced an awaited query performance optimization for Data Analysis Expressions – or DAX queries – aimed at processing DAX queries more efficiently. On a nutshell, Horizontal Fusion means less trips back and forth to bring you the same result quicker than before. ABCloudz is hard-wired to the market for both new technologies, as well as the desired advancements and requested improvements the development and IT solutions community look forward to better providing to our customers. We […]

Denys Takahashi
Best practices: Security audit of Azure infrastructure for a healthcare data company

One of our customers runs a large Azure data center that works with Personal Health Information ( PHI). Before the client contacted us, many of their servers have been running on legacy OS and the overall infrastructure was rather disorganized. The Company’s management was concerned about potential security holes and requested to conduct a thorough security audit. Before contacting ABCloudz, the Company’s IT staff had been aware of potential security gaps in their infrastructure. For example, their data infrastructure included […]

Andrey Khudyakov, Roman Muzyka
DevOps and test automation: Docker saves the day!

Recently, the ABCloudz team migrated a customer’s database from Apache Cassandra to Amazon DynamoDB. As part of this project, we needed to run multiple tests to ensure perfect quality for our delivery. However, we faced a problem in setting up the test environment. Even though we were using AWS CloudFormation templates for the EC2 instances, it was taking over 30 mins to get the dev/test environment setup. In addition, our developers couldn’t run parallel regression testing. So, we decided to leverage Docker to automate the environment set up.
In this blog post, we will share our experience with using Docker for automating a NoSQL database migration dev/test environment.

Viacheslav Kim
Migrating to Azure SQL Managed Instance: Reasons and implications

Azure SQL Managed Instance (MI) is a highly-efficient Azure service that allows combining the broadest SQL Server database compatibility with numerous benefits of a fully managed PaaS (Platform as a Service). MI provides a much higher degree of capability than Azure SQL Database DTU and vCore service levels. Read this blog post to know the main reasons and implications of migrating to Azure SQL MI. Also, get to know how ABCloudz specialists can help you migrate quickly and efficiently. Why […]

Roman Muzyka, Andrey Khudyakov
Access modernization roadmap for a highly-outdated environment

One of our clients, a major health company, was operating a data system. Over the years, it had expanded dramatically. However, the client had never developed a comprehensive modernization strategy for their product. As a result, they ended up with a highly outdated and inefficient environment overloaded with thousands of Microsoft Access and SQL Server databases. The use of such an outdated system was associated with numerous performance, security, manageability, and scalability risks. In addition, there were frequent database corruptions. […]

Roman Muzyka, Andrey Khudyakov

Hi there! How can I help you?

ABCAssist