2016 SSIS packages can access data anywhere throughout the network, but normally run on the server they are deployed on. And if something terrible happens to that server, the manual setup of the SSISDB can be time consuming. With 2017, SSIS packages can be deployed once and run on several servers, even simultaneously. At this meetup, Paul LaGrone will teach you how to set up 2017 SSIS Scale Out packages so that your SSIS packages can now be in a Highly Available and Disaster Recovery environment.
Speaker bio: Paul is currently in his fourth year as the ETL Manager for a local CRM software firm. Paul's database work dates back to early database platforms like Dbase III and has worked with every version of SQL Server since SQL 7.0 was introduced. His certifications include MCSE, MCDBA, and MCT. Along with holding a DBA job for the City of Fort Worth, Texas, he also taught T-SQL Intro and Advanced classes to several departments and the North Texas GIS community. In 2006, he founded and ran the Greater Fort Worth SQL Server group for three years, which still continues today. While moving data and other SSIS tasks are Paul's responsibility now, he has also been a Production DBA, worked heavily in the GIS database community, and has been known to use SQL Server in an AWS cloud environment.
Also for those who are new or haven't noticed, the next SQLSaturday Pensacola (http://www.sqlsaturday.com/743/eventhome.aspx) event is open for registration. This year's event will be held on June 2nd. Start spreading the word!
We are looking for sponsors and speakers for both the SQLSaturday and for this user group. Please contact me if interested or know of anyone who may be interested.
We hope to see you in February!
Karla and Rodney