Meeting Information

Select Meeting  


Meeting Date
Wednesday, September 27, 2017




at the The Westbury Manor, room
in Westbury, Long Island


The Presession starts at 5pm
The Networking and Cocktail hour starts at 6pm

Click here to Register and Pay using Paypal (Save $$$)

Payment can be made at the door (cash or check only)!



3:30pm: SQL Views for Dummies

Scott Forstie
IBM

Presentation Description

SQL views provide the modern user interface to obtain system level information traditionally available via OUTFILE and API support. Attend this session and learn how easy it is to use a SQL view. SQL views provide the administrator of the system easy access to lots of system configuration and management information. This session will provide a list of available SQL views and their purpose as well as examples of how to use them. I will explain how the examples work and you'll leave with the skills necessary to be a better and more system administrator. This is not an introduction to SQL class, but rather an explanation of why you need to add SQL to your toolset and a quick-start guide showing you how to become a better systems administrator or security officer.

About Scott Forstie

Scott Forstie is a Senior Technical Staff Member at IBM. He is the DB2 for i Business Architect, working on all things related to the database on IBM i.
Scott is responsible for everything related to DB2 for i. He is a frequently published author and speaker at industry events. He also is the content manager of the IBM i Technology Updates wiki (www.ibm.com/developerworks/ibmi/techupdates) where IBM i operating system enhancements are described.
He can be reached at forstie@us.ibm.com or followed on Twitter @Forstie_IBMi. Scott enjoys running and is an avid cook.



5:00pm: SQL for the Security Officer

Scott Forstie
IBM

Presentation Description

The pressures and expectations for the security officer have never been higher. Come to this session to learn how to use SQL to accomplish critical security tasks, including the ability to easily automate security policies. You do not have to be an SQL expert to gain something from this session. I will give you examples that you can take back and use. In the session, I will explain how the examples work and you'll leave with the skills necessary to be a better and more productive IBM i security officer.

About Scott Forstie

Scott Forstie is a Senior Technical Staff Member at IBM. He is the DB2 for i Business Architect, working on all things related to the database on IBM i.
Scott is responsible for everything related to DB2 for i. He is a frequently published author and speaker at industry events. He also is the content manager of the IBM i Technology Updates wiki (www.ibm.com/developerworks/ibmi/techupdates) where IBM i operating system enhancements are described.
He can be reached at forstie@us.ibm.com or followed on Twitter @Forstie_IBMi. Scott enjoys running and is an avid cook.



8:00pm: ACS Run SQL Scripts & Other DB2 for i Tools Re-invented

Scott Forstie
IBM

Presentation Description

With the demise of the iAccess for Windows and it not being supported on Windows 10, we needed to come with new interfaces and tools to help the database engineer (DBE) do their job. This session will introduce the brand new Run SQL Scripts interface, show a number of live Demos as well as other tools centric to the success of the DB Engineer. The session will also include and explanation and demonstration of all the database tooling that has been added to this java-based tool.

About Scott Forstie

Scott Forstie is a Senior Technical Staff Member at IBM. He is the DB2 for i Business Architect, working on all things related to the database on IBM i.
Scott is responsible for everything related to DB2 for i. He is a frequently published author and speaker at industry events. He also is the content manager of the IBM i Technology Updates wiki (www.ibm.com/developerworks/ibmi/techupdates) where IBM i operating system enhancements are described.
He can be reached at forstie@us.ibm.com or followed on Twitter @Forstie_IBMi. Scott enjoys running and is an avid cook.