Professional Association for SQL Server

Welcome to the Greenville, SC Chapter

 Welcome

We have meetings on the first Tuesday of most months.  Our group meets at the Greeville Campus of ECPI. Our normal room is room #236 but check the visual displays when you arrive to confirm.

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session.  Unless noted in the meeting notes the schedule for each meeting will be:

6:00 - 6:30 - Food and a chance to meet other SQL Server users. Sponsored by FGP

6:30 - 6:45 -
General Q&A session & Announcements

6:45 - 8:15 - Presentation(s)

8:15 - 8:30 - Question & Answer session

 Upcomming Events

Next Meeting: Tue, Aug 04 2015

Closing the SSIS Package Management Story with BIPS

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: http://ssig201508.eventbrite.com

6:00 – 6:30 Pizza and Networking sponsored by FGP
6:30 – 6:40 Announcements
6:40 – 7:00 TBD
7:00 – 8:15 Jim Christopher: Closing the SSIS Package Management Story with BIPS
8:15 – 8:30 Closing remarks

Closing the SSIS Package Management Story with BIPS
Existing SSIS automation solutions are focused on forward-motion activities: creating packages and pushing them to the server. Little or no thought is given to the management of the packages once they are in production - existing tooling offers nothing to help you understand and manage a live, money-printing ETL workflow based on SSIS packages.

BIPS is an open source project that allows you to manage a live SSIS package tree from PowerShell. It closes the automation loop, providing the ability to learn and discover the features of an existing package deployment tree as well as manipulate it. In short, the goal of BIPS brings a devops perspective to managing your SSIS packages.

In this session, you will learn how to leverage BIPS in your own environment. Specific attention will be given to searching and filtering tasks and data flows on arbitrary criteria and manipulating specific parts of the ETL workflow from the shell.

Jim gained 18 years of professional experience developing complex software projects in highly regulated industries, including education, gaming, and defense. His professional drive is designing software, systems, and user experiences for automation, a theme that has earned him a Microsoft MVP for PowerShell (2011-2016). Jim is a frequent speaker at technical user groups and conferences. He is currently Curriculum Director at Pluralsight.

When

iCal
UTC : Tue, Aug 04 2015 22:00 - 00:30
Event Time : Tue, Aug 04 2015 18:00 - 20:30 Eastern Daylight Time
Your Local Time: Tue, Aug 04 2015 22:00 - 00:30

Where

1001 Keys Dr
Greensville, South Carolina

Direction: None

Featured Presentation

Closing the SSIS Package Management Story with BIPS

Speaker: Jim Christopher, Owner Code Owls LLC

Summary: Existing SSIS automation solutions are focused on forward-motion activities: creating packages and pushing them to the server. Little or no thought is given to the management of the packages once they are in production - existing tooling offers nothing to help you understand and manage a live, money-printing ETL workflow based on SSIS packages. BIPS is an open source project that allows you to manage a live SSIS package tree from PowerShell. It closes the automation loop, providing the ability to learn and discover the features of an existing package deployment tree as well as manipulate it. In short, the goal of BIPS brings a devops perspective to managing your SSIS packages. In this session, you will learn how to leverage BIPS in your own environment. Specific attention will be given to searching and filtering tasks and data flows on arbitrary criteria and manipulating specific parts of the ETL workflow from the shell.

About Jim: Jim gained 18 years of professional experience developing complex software projects in highly regulated industries, including education, gaming, and defense. His professional drive is designing software, systems, and user experiences for automation, a theme that has earned him a Microsoft MVP for PowerShell (2011-2016). Jim is a frequent speaker at technical user groups and conferences. He is currently Curriculum Director at Pluralsight.

Attachments

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.
 Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

Red gate