Learn more about
SQL Server
SQL Server, Data Connect, Ellucian SaaS, Banner SaaS, data-warehouse, higher-education, ETL, Amazon RDS, Azure, database-conversion, database-migration, Ellucian, Improving the performance, integration, modernization-roadmap, PostgreSQL, PowerShell, test automation, SaaS
Modernizing analytics pipelines with Data Connect
This post shares how ABCloudz and Ellucian helped one of the largest U.S. community college systems move from legacy SQL Server infrastructure to a cloud-native analytics platform on AWS, using Ellucian Data Connect to modernize data pipelines and integrations. We dealt with business-critical legacy procedures, manual PowerShell scripts, SQL Agent jobs, and a complete lack […]
application-modernization, UI/UX, Azure, cloud, application-development, architecture, web-app, React, .NET, SQL Server, devops, CI/CD, node.js
Modernizing a dealership CRM for car sales
Our client, an emerging player in the automotive sales software industry, had developed an initial CRM-like application designed to help car dealers streamline communication with potential buyers through visually appealing, GIF-based offers sent via email and SMS. The concept leverages dynamic visual engagement to simplify the negotiation process and improve conversion rates. However, the initial […]
operational-data-management, Azure, database monitoring, Active Directory, devsecops, high-availability, security, SQL Server, VMware
Managing data behind financial operations
In the financial industry, reliable data management is crucial. Downtime or performance issues are not just IT inconveniences; they can seriously disrupt daily operations. This reality was especially clear to one of our clients, a U.S.-based credit union serving public service professionals, including first responders. With a mission rooted deeply in community safety and resilience, […]
application-modernization, database-migration, Oracle to SQL Server, oracle-workload-migration, React, SQL Server, Azure
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 […]
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 […]
Database migration with SSMA: Handling typical conversion issues
Migrating databases from Oracle to Microsoft SQL Server can be a complex endeavor, especially when it comes to dealing with differences in schema structures, data types, and specific SQL clauses. The SQL Server Migration Assistant (SSMA) is a robust tool designed to automate these migrations and minimize manual effort. However, SSMA might not always produce […]
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 […]
operational-data-management, database monitoring, security, SQL Server, cost-optimization, SharePoint, ETL, health check, Azure SQL Database, 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. […]
devops, Databricks, Azure, big-data, data-warehouse, data platform, cloud-migration, business intelligence, SQL Server, Azure Data Factory, ETL, Oracle
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 […]
architecture, SaaS, deployment, CI/CD, devops, backend, microservices, AWS, Amazon S3, Amazon ECR, SQL Server, Redis, .NET, Active Directory, customer-story, healthcare
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 […]
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 […]
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 […]
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 […]
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. […]
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 […]