More with tags:

#azure

#Azure SQL Database

#cost-optimization

#database monitoring

#ETL

#health check

#operational-data-management

#security

#SharePoint

#SQL Server

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 of Date and Time Conversion functions, after it was generated by SSMA. Key differences between Oracle and SQL Server Oracle and SQL Server handle date […]

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 […]

ABCloudz recently completed a significant project migrating an Enterprise Data Warehouse (EDW) from an on-premises SQL Server 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 volumes  […]

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 […]

According to Business Insider, a single minute of data infrastructure downtime in a data center costs the companies using this data center over $8,000. The more complex your data infrastructure is, the greater the risk of errors that can lead to downtime, compromised data quality, or disruption of vital processes. The challenge lies in the fact that even a well-tuned data infrastructure is vulnerable to unexpected errors and disruptions that can severely impact its performance. That’s why it’s crucial to […]

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 it, offering it to other healthcare providers under a white labeling model. To technically achieve this strategy, we needed to develop a scalable, distributed backend […]

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 […]

ConcertAI, one of the leading providers of medical research software,  has faced very common scenario for a mature healthcare data center as its infrastructure had developed over years to become extremely sophisticated but highly inconsistent. Some of the servers were running on an end of life OS and desperately needed upgrading. The client decided to implement a cloud-based solution for infrastructure migration and partnered with ABCloudz to make the system more manageable and prepared for the upcoming refinement. Our specialists […]

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: […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]