I380 Corridor PASS Chapter

  Eastern Iowa's SQL Server User Group
  Cedar Rapids • Iowa City


Meeting Details




Jan Meeting: SSIS

  • In-Person @ 1850 Boyson Rd, Hiawatha, Iowa (map)
  • Tue, Jan 14 2014
    18:00 - 19:30 (UTC-06:00) Central Time (US & Canada)
  • Language: English

Featured Presentation:

Add SSIS to the developer tool belt without adding to the DBA’s work load

James Borland, DBA University of Iowa

Microsoft is pushing for more self-service BI from the end-user. Which is great but most times that data still needs ETL actions for the end-user first. SSIS is a powerful tool for this but up until SQL 2012 it has been cumbersome in deployment and for security issues for both the developers and DBAs alike. The latest version now has a new deployment model for SSIS packages. This session will discuss the various deployment modes. There will be an overview on how the University of Iowa is implementing a hosted self-service SSIS model leveraging project deployment.

About James:
Mr. Borland has broad hands-on Information technology experience across industries. The various industries experience range from governmental, hospital, biotechnology, and telemarketing. He started out as researcher and data analysis. Grabbing the operating in 1996 with a start-up company, he put on multiple IT hats and became an accidental DBA with MS SQL 2000. Over the next 10 years, Mr. Borland developed application from silo single user to complex n-tier multi-platform with MS SQL as the primary relational data stored choice. In 2006 the balance shifted and Mr. Borland became a full-time DBA. The latest start-up company had grown to two US production sites and one international in Belgium. The data needs had matured also. He dove into the role and expanded his SQL experience in SSRS, SSIS, and data warehousing. Mr. Borland currently works for the University of Iowa as a DBA overseeing 130+ SQL instances and involved in the Business Intelligence development and support efforts there.

Back to Top