Next Meeting

Date Wednesday, April 5, 2017, 6:00 PM - 8:00 PM

Speaker Eric Freeman

Topic: SSIS Process Automation Design for the T-SQL Developer

This session is geared towards T-SQL developers who are interested in ETL framework or process automation. In this session we will go over how to create a single SSIS package that can be used for process flow automation without the need to constantly update the SSIS package whenever there is a change. When something happens, something or multiple things need to happen. The architecture that will be presented is powered by tables, stored procedures and recursive CTEs. While the primary focus will be on the framework we will also go over auto-generation of HTML emails with dynamic query output, automating downloads and loading from staging to production.

Eric Freeman works as a Senior Business Intelligence Architect at John Burns Real Estate Consulting. He has 15+ years of experience working with Microsoft SQL Server and holds an MCTS in Business Intelligence with a strong emphasis on Performance Tuning, ETL and Data Warehousing. Former President of the Sacramento SQL Server User Group, and actively speaks at SQL Server events.

Twitter: https://twitter.com/sqlelf 
Blog: http://sqlelf.blogspot.com/ 
LinkedIn: https://www.linkedin.com/in/ericlfreeman/

Sponsor:

Robert Half Technology

RSVP:

If you plan to attend, please RSVP on Meetup.  Please join the Meetup group if you are not yet a member.  Your Meetup RSVP helps us plan food for the meeting.

Welcome

The Sacramento SQL Server User Group meets the first Wednesday of every month. Most sessions will have a presentation; however, throughout the year we schedule a few group sessions designed to provide a forum that allows attendees to discuss real-world SQL Server related questions, issues and concerns which are addressed as a group.

We start each meeting with some time to network and get situated. Unless otherwise noted, the schedule for each meeting will be:

6:00 PM - 6:15 PM: Mingle/networking, get food & beverages, presentation setup
6:15 PM - 6:30 PM: Group announcements, agenda, introduce speaker
6:30 PM - 7:30 PM: Presentation
7:30 PM - 8:00 PM: Post-meeting discussions


Meeting Location:

Patrick Hays Learning Center
2700 Gateway Oaks Drive
Suite 2600
Sacramento, CA 95833

Once inside the building, take the stairs or elevator to the second floor, then enter Suite 2600.


View Larger Map

 

Announcements

SQLSaturday Sacramento 2017 (SQLSaturday #650, #sqlsatsac):
SQLSaturday Sacramento 2017 (SQLSaturday #650) is July 15, 2017.
Speaker and attendee registration is now open!
http://www.sqlsaturday.com/650/EventHome.aspx

PASS Summit 2017 Registration Discount Code:
Save $$$ with the SACSQLUG registration discount code ??????? (check back in mid-April for our code) for PASS Summit 2017

SQLSaturday #540: SQLSaturday 540 was held on July 23, 2016
http://www.sqlsaturday.com/540/EventHome.aspx

SQLSaturday #399: SQLSaturday 399 was held on July 25, 2015
http://www.sqlsaturday.com/399/EventHome.aspx

SQLSaturday #312: SQLSaturday 312 was held on July 12, 2014
http://sac.pass.org/SQLSaturday/SQLSaturday312.aspx

PASS Summit 2013: Watch the Keynotes, select sessions, interviews and more from PASS Summit 2013 at the PASStv site: http://www.pass.org/summit/2013/PASStv.aspx

SACSQLUG Meeting Archive: Our meeting archive pages have been revised:
http://sac.pass.org/MeetingArchive.aspx

24 Hours of PASS: The Summer 2013 24 Hours of PASS session recordings are now available for viewing:
http://www.pass.org/summit/2013/Sessions/SneakPeeks.aspx

SQLSaturday #222: Our second annual Sacramento SQLSaturday was held on July 27, 2013; more info, pictures, blog and tweet links:
http://sac.pass.org/SQLSaturday/SQLSaturday222.aspx

Sorry, there are no upcoming meetings. Please check back for updates.