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)!![]() 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. 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 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. 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 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. 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. |