Skip to content

Andrew Smith

AWS Engineer

  • Home
  • Bio/Contact

Tag: ETL

Source Control and SSIS

Source Control and SSIS

Source control plays an essential part of any software development project, where ETL is no exception.

At the very least it preserves source code such that recovery is possible to a previous point in time, whilst also allowing developers to work on multiple streams of the code such that new developments are isolated […] “Source Control and SSIS”

Author Andrew SmithPosted on Posted on 8th July 201626th May 2020Categories UncategorisedTags ETL, SQL Server, SSIS
SSIS Bulk Load Settings

SSIS Bulk Load Settings

This post explores the SQL Server bulk load settings that are exposed to SSIS, and measures their effect on a simple SSIS data flow.

It considers bulk loads into heaps and clustered indexes, as well as showing the effect of minimally logged inserts into a database running with the simple recovery […] “SSIS Bulk Load Settings”

Author Andrew SmithPosted on Posted on 2nd July 201626th May 2020Categories UncategorisedTags ETL, SQL Server, SSIS

Posts navigation

Newer Posts Page 1 … Page 6 Page 7

About

I’m Andrew Smith and I’m a software developer and systems architect/engineer with over two decades of experience, including work for blue chip companies such as IQVIA, Ford Motor Company and PricewaterhouseCoopers.

I now work primarily with AWS, for which I have certifications for AWS Solutions Architect, AWS SysOps Administrator and AWS Security (Specialty).

I’m also a specialist in SQL, with over a decade of experience in Oracle, Microsoft SQL Server, MySQL and PostgreSQL.

I’m no longer updating this blog – my newer articles are attached to my LinkedIn profile.

Contact

Email:
andrew@andrewleesmith.co.uk
Linked In:

Popular Tags

  • AWS (8)
  • ETL (20)
  • Python (6)
  • SQL Server (38)
  • SSIS (17)

Recent Posts

  • Optimising Query Execution for Amazon Redshift Spectrum
  • Processing IoT Data using Amazon Kinesis
  • Running ETL Jobs using Amazon Athena
  • Integrating AWS Glue Jobs with S3 Notifications and EventBridge
  • Loading data into Amazon Redshift using AWS Glue

Archives

  • June 2020
  • May 2020
  • April 2020
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • Home
  • Bio/Contact
Andrew Smith Proudly powered by WordPress
Close Bitnami banner
Bitnami