SQL Server Integration Services packages run a lot of nightly data movement. On AWS you can keep them on RDS for SQL Server with the SSIS option, run them on EC2 or RDS Custom, or rebuild them as Glue jobs orchestrated by Step Functions. The limits of each, and how to choose per package.
Book a free 30-minute call. You'll leave knowing what we'd do first and roughly what it costs, whether or not you hire us.
Simple SQL-to-SQL transfers and stored procedure calls: RDS SSIS, or replace with a scheduled stored procedure or DMS task.
Flat-file imports from partners: S3 events triggering Lambda or Glue, which is simpler to monitor than a nightly package polling a folder.
Warehouse loads: Glue, or zero-ETL from Aurora or RDS into Redshift where the source is supported, which removes the pipeline entirely.
Packages full of script tasks and custom components: EC2 first, then redesign.
Once a month: what changed in tech that month and what it means for you, from cloud and AI to security and the tools you build with. Every item links to its source. No sales pitch, unsubscribe in one click.
Book a free 30-minute call about it. Bring your setup and your bill; you'll leave knowing what we'd do first and roughly what it costs, whether or not you hire us.
Or keep reading
SQL Server 2016 Has Ended and 2017 Ends October 2027: Upgrade, Move to RDS, or Leave for PostgreSQL
SQL Server 2016 reached end of support on July 14, 2026; SQL Server 2017 follows on October 12, 2027, and SQL Server 2014's last ESUs end in July 2027. The three realistic paths on AWS (a newer SQL Server on EC2 or RDS, Aurora PostgreSQL with Babelfish, or a full conversion with AWS Transform) and what each costs in licences and effort.
Read
Build Your Own Pinpoint on AWS, and Make It Better: Segments in SQL, Journeys, Holdouts and Feedback Loops
A self-hosted replacement for Pinpoint is five parts: first-party events, a profiles table, segments as SQL, sending through SES and End User Messaging, and journeys on Step Functions or Lambda durable functions. What makes it better than Pinpoint ever was: holdout groups that measure real lift, one identity from first visit to revenue, and loops that learn from every send.
Read
As of October 25, 2026. Provided as is, for general information, and accurate to the best of our knowledge on the date shown. Not legal, compliance, tax, financial or other professional advice. Prices, limits and vendor services change; check current vendor documentation before relying on anything here. Terms of use.