ETL Case Study – Pharmaceutical

Resolving Critical Data Warehouse Deadlocks and 50-Minute Delays for Pharmaceutical Leader Learn how Fortified Data’s comprehensive database assessment identified and resolved persistent deadlocking issues, optimized SQL Server resource allocation, enhanced inadequate indexing, and transformed 200+ SSIS ETL packages for this global pharmaceutical company – eliminating nightly blocking chains and restoring critical data warehouse performance.

Healing Through Innovation: Final Steps in SQL Server to RDS Migration

In my last post, I shared a big win in the medical field: we successfully migrated a client’s SQL Server environment from Amazon EC2 to Amazon RDS Custom. This was no small feat — we moved over 600 databases, tackling some serious technical challenges along the way. While we initially considered using AWS Database Migration […]

A Big WIN in the Medical Field: Migrating SQL Server to Amazon RDS

It’s always awesome when I get to share about successes that benefit our clients, and this one knocks it out of the park. This is the start of a multi-post series that dives into a recent success I had with one of our clients in the medical industry where we took steps for migrating SQL […]

Streamlining Report Migration with Automation: A Client Success Story

With a high dependence on data and analytics, organizations often face tight deadlines and resource constraints when adapting to significant system changes. One of our recent projects perfectly illustrated this challenge: a client needed to migrate their reporting infrastructure from an on-premises SQL Server to Azure Databricks within an incredibly short timeframe. With limited resources […]