Premier Sponsors
 
http://www.sqlpass.org 
 
http://www.crescentsolutions.net 
 
http://www.pyramidinc.com/ 
 
http://reduxio.com/ 
 
http://kubisys.com/ 
 
http://www.infragistics.com/ 
 
http://oreilly.com/ 
 
http://pyramidanalytics.com/ 
 
http://www.sqlpower.com/ 
 
http://www.idera.com/ 
 
http://www.telerik.com/ 
 
http://pluralsight.com/training 
 
SQL PASS Community News: View
Download the latest ebook from Microsoft Press: Data Science with Microsoft SQL Server 2016
Los Angeles SQL Server Professionals Group Presents ....
Thursday, September 21, 2017
SSIS Project Deployment: The T-SQL Way
Abstract:
Do you deploy SQL Server Integration Services (SSIS) Projects using the Integration Services Deployment Wizard? If you're looking for a repeatable deployment method that can be source controlled, there's another way...the T-SQL way! In this session, you will see a demonstration of T-SQL script deployment of SSIS projects, using stored procedures in the SSISDB database. You'll learn how to query the SSIS catalog to find your project configurations so they can be captured and source controlled. Take control of your SSIS deployments...the T-SQL way!

Prerequisites: You should have previous experience with SQL Server Integration Services (SSIS) package deployment and/or development.
Goals:
. Learn about the SSISDB database and catalog objects
. See how to use T-SQL to deploy SSIS projects and packages
. Discover the new features of SSIS delivered with SQL Server 2016
Speaker: Peter Kral, Sr. Database Engineer, FTD
Bio: Certified SQL Server MCSA 2012/2014/2016 and Data Platform MCSE, Peter was recently the winner of the Speaker Idol Award at the PASS Summit 2016. Employed at e-commerce company FTD, he develops database solutions using T-SQL, SSIS and PowerShell. Peter is an active member in the PASS SQL Server User Group in San Diego, and has spoken at many SQL Saturdays and SoCal Code Camps.
6:30 PM, Registration and Refreshments
7:00 PM to 9:00 PM, Presentations
Our New Meeting Location:
Microsoft Store at Westfield Century City
10250 Santa Monica Blvd. Space #1045
Los Angeles, CA 90067
This meeting is generously sponsored by:
Reduxio Systems
http://reduxio.com/
Reduxio provides an enterprise-class "time machine" that enables instant restore to one-second recovery points without using snapshots. By obsoleting snapshots technology, Reduxio has reduced the recovery time from database failures from hours to seconds.

FREE Admission