More with tags:

#database-services

#PowerBI

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

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

September of 20 has been an exciting month for Power BI adopters and Vue.js applications. Microsoft has just announced a new component that allows Power BI content to be embedded into Vue.js interfaces and websites. ABCloudZ is always working with the latest modern architectures, preparing our consultants and portfolio to offer the cutting edge of technology to all our customers. Similar to the well-known React and Angular frameworks, Vue.js is becoming increasingly popular among JavaScript frameworks. They have reportedly grown  22% in the last 5-year span […]

Data infrastructure is what powers the proper performance of your software. However, unexpected issues can occur making your system unavailable. That’s where the notion of a downtime, a time period when the system is not available, comes in. Downtime may have different causes and outcomes. But one thing is certain, downtime can be extremely expensive. One hour of system downtime can cost you more than $300,000. And, apart from direct losses, it is extremely damaging to your reputation. Especially when […]

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

With our long and diverse experience in data solutions, it became clear to ABCloudZ that a large majority of Business Intelligence and Analytics solutions will, at some point and degree, rely on a semantic or multi-dimensional type of model to support its architecture, providing fast aggregations, and the desired fact-dimension capability for all sorts of data iterations. Until recently, if we take Microsoft as an example, your Analysis Services instance – be it on premises or on the cloud –would […]

A modern medical company was running a large healthcare platform connecting patients with medical imaging providers. They had databases for the admin app, patient app, physician app, and the original service portal. All these databases were running on AWS cloud servers deployed and managed by Datica. The latter helped the customer scale and manage their data infrastructure and had control and access to their data. However, the customer wanted to go beyond the Datica service offer. They wanted to gain […]

In this post we continue exploring the technical aspects of Oracle to PostgreSQL migration using AWS SCT. AWS SCT promises a very high level of migration efforts, however it is very rare that 100% automation is achieved. In this article we’ll look into conversion of INSERT ALL statements, which are quite popular in Oracle code. We were using AWS SCT build #660 to convert one of our Oracle test databases. Oracle gives you an option to use the conditional insert […]

Our customer is the nation’s largest home outdoor care company, serving more than 2.3 million residential and commercial customers across the United States and having revenues reaching up to $2 billion. Before contacting ABCloudz they had severe business reporting issues. The client’s KPI (key performance indicator) reports were extremely inconsistent and took too much time to be completed. These issues dropped the overall efficiency of the client’s reporting. Besides, the client did not have much time and resources for building […]

Speed is everything in the highly competitive domain of e-commerce. Digital marketplaces of varied sizes appear at an ever-increasing rate and it becomes more challenging to stand out among the competition. According to estimates, a 6-months delay in a software product release can cut its profitability by at least 30%. These numbers had been relevant 30 years ago, and they have become even more relevant in the modern time or rapid digitization. That’s why entrepreneurs with a promising digital marketplace […]

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 the data transfer from Oracle to SQL Server. Because of the complexity of the project, the client sought software developers that would build an automated […]

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 over 400 hierarchical queries that could not be converted with SSMA. And second, the company’s technical staff was also unable to convert such queries. By […]

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. The problem Oracle database server includes an Oracle database and an Oracle instance. You may learn more about the architecture of the Oracle server here. […]

A materialized view is an important property of Oracle. SQL Server recreates the same behavior as this materialized view in several ways. Unfortunately, SSMA may have issues with converting this object to SQL Server. It flags certain conditions as an error. In this blog post, we will overview the error O2SS0522. It goes about cases in which the Oracle materialized view includes FLOAT columns, subqueries, GROUP BY or WHERE clauses, MINUS, INTERSECT, UNION, etc. By default, SQL Server Migration Assistant (SSMA) converts Oracle […]